Home » SQL & PL/SQL » SQL & PL/SQL » ERR 12505
ERR 12505 [message #13175] Mon, 28 June 2004 13:05 Go to next message
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 Go to previous message
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
Previous Topic: can any dody send my about interfaces,multiorg questions and answers
Next Topic: How I get Table Script , Urgent
Goto Forum:
  


Current Time: Thu Mar 28 08:58:21 CDT 2024