ERR 12505 [message #13175] |
Mon, 28 June 2004 13:05 |
mitra fatolahi
Messages: 38 Registered: October 2002
|
Member |
|
|
Hi All,
I am new to Oracle database and I am having trouble connecting to the database using our application. I have installed Oracle 10g on Windows 2000 with sp4.
Using the web-based EM I created a new user as sysdba. To connect to the database using our application control panel, I have entered the port number(1521), the database name(TEST), user name(mitra) and the password.
Our application is throwig the following error:
java.sql.SQLException:IO exception: Connection refused(DESCRIPTION= (TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)EMFI=4))))
In the tnsnames.ora file I do see an entry for the SID_Name ,TEST, that I am using to connect to the Oracle 10g database.
Here is what's in my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:oracleproduct10.1.0db_1networkadmintnsnames.ora
# Generated by Oracle configuration tools.
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test-svr3.eng.encryptx.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test.eng.com)
)
)
Please help!
Thanks,
Mitra
|
|
|
Re: ERR 12505 [message #13264 is a reply to message #13175] |
Sat, 03 July 2004 22:30 |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
Hi,
You are getting this error:
12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a SID for an instance (usually a database instance) that either
// has not yet dynamically registered with the listener or has not been
// statically configured for the listener. This may be a temporary condition
// such as after the listener has started, but before the database instance
// has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which instances are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SID parameter in the connect descriptor specifies
// an instance known by the listener.
// - Check for an event in the listener.log file.
Best regards.
Frank
|
|
|