Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\admin>d:
D:\>javac SelectTest.java
D:\>java SelectTest
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
localhost:1521:ORCL.REGRESS.RDMS.DEV.US.ORACLE.COM
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java
:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java
:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnecti on.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtensio
n.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SelectTest.main(SelectTest.java:12)
D:\>javac SelectTest.java
D:\>java SelectTest
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
localhost:1521:ORCL.REGRESS.RDMS.DEV.US.ORACLE.COM
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java
:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java
:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnecti on.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtensio
n.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SelectTest.main(SelectTest.java:12)
i am getting tns refused please tell to me
and how to change global_neme oracle name please tell as soon as possible