<brent.ryan@gmail.com> wrote in message
news:1147118577.608410.90030@i40g2000cwc.googlegro ups.com...
>I have a problem with a java application connecting to a test Oracle DB
> and everything works fine. However, once we were ready to move to
> production I changed the database URL and SID to connect to the new
> database and I get an error. Below are the configurations that I
> changed in my properties file and the error that was received from the
> TNS listener.
>
> OLD
> driver=oracle.jdbc.driver.OracleDriver
> url=jdbcracle:thin:@host:1521:h8sontst
>
> NEW
> driver=oracle.jdbc.driver.OracleDriver
> url=jdbcracle:thin:@new_host:1521:h8sontst
>
> Listener refused the connection with the following error:
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=(ADDRESS=(HOST=new_host)(PROTOCOL=tcp )(PORT=1521))(CONNECT_DATA=(SID=h8sontst)))
>
> I can connect using sqlplus with no issues from that server. Please
> help if you have any ideas? Both the test server and production server
> are running the same version of Oracle.
>

You may have to do a few more diagnostic tests before you can resolve the
problem.

What does the result of 'lsnrctl status <LISTENER_NAME>' say? What you
would be looking for is an indication that the listener has the Oracle
instance registered.

The problem would appear to be on the server side. You have only given us
information on the client side. You did not indicate how you connected to
the Oracle instance on the server.

<esp>Without any other information, my guess is that you have a typo in
listener.ora.</esp>

Douglas Hawthorne