ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript
Recently I have faced this issue in Oracle 11G while connecting to a database via sql developer 4.0
ISSUE DESCRIPTION:
I have created one database with name "test" and password "test" and am able to connect to database using sql plus.
Initially the Host name of my "oracleservicetest" was set to localhost, so when i tried to connect with the sql developer with hostname = "172.16.xx.xx" it throws network adapter error could not connect exception.
Then i changed the host name to "172.16.xx.xx" for database "test" using Oracle NetManager.
then i changed the listenerservice hostname to "172.16.xx.xx"
After restarting the machine, when i tried to connect the database with sqldeveloper it throws the below exception.
"ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript"
Then i googled and found the below link.
SOLUTION :
I found that the hostname has not updated with IPaddress in tnsnames.ora file even though i have updated the listener service using oracle NetManager. It has updated the listener.ora file the hostname to "172.16.xx.xx" but not updated the tnsnames.ora hostname.
