Oracle Toplink Workbench - ORA-12505, TNS:listener error

[nav katoch]

Hi all,

I am getting the following error in the oracle toplink workbench while logging in to the database:-

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: localhost:1521:XE
Use name or password could be invalid.

Please guide me to fix this error.

Thank you so much for your inputs,

Naveen Katoch

[Leonardo Carreira]

Hi..

What application server do you use?..
could you login to your database with username & password which described in Connection Configuration?..
the log message told that

Use name or password could be invalid.

...

perhaps its only the wrong of username & password..

Please correct me if i'm wrong..

Thanks..

[nav katoch]

Hi Leonardo,

Thanks for your reply. I appreciate it. I am using Oracle 10g database and it's working fine with sql plus having user name as scott and password as tiger. I have the following files:-

1.

  # tnsnames.ora Network Configuration File: C:\oracleDatabase10201\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. SERVICE_NAME orcl, naveen.gateway.2wire.net

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = naveen.gateway.2wire.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

2.

# listener.ora Network Configuration File: C:\oracleDatabase10201\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracleDatabase10201)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = naveen.gateway.2wire.net)(PORT = 1521))
    )
  )

I tried changing host from localhost to naveen.gateway.2wire.net but I am getting the same error.

Thanks again,

Naveen

[James Sutherland]

You seem to be using the Oracle JDBC thin driver. This driver connects directly to your database, it does not use OCI. There is an OCI JDBC driver as well, if you wish to use it.

Your Oracle thin JDBC driver url seems that it should be,

jdbc:oracle:thin:@naveen.gateway.2wire.net:1521:orcl

[nav katoch]

Hi James,

Thank you so much for your fruitful input. It's working fine now.

Naveen