[skinchu]

Hi there

I have Oracle 10G Express installed locally. I can connect to Oracle from TOAD, but I cannot from DB Exporer. I have the latest Oralce JDBC thin driver installed and the connect details are as follows:
URL: jdbc:oracle:thin:@localhost:1521:HR
user: hr
password: hr
Dirver class: oracle.jdbc.driver.OracleDriver
Driver: ojdbc14.jar

Errors I got:
Error while trying to login to database: Listener refused the connection with the following error: ORA-12505, TNS:listener does nto currently know of SID given in connect descirtor
The Connection desciptor used by the client was: localhost:1521:HR

How should I specify SID from DB Explorer? My tnsnames.ora is as follows:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LX319570.wireless.corp.ads)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

I have tried URL: jdbc:oracle:thin:@XE, but no luck.

Thanks for your help.
Stephen

[Riyad Kalla]

Stephen,
It looks like you setup everything correctly, let me ask one of our DB devs to see what is going on.

[Brian Fernandes]

Stephen,

Can you try jdbc:oracle:thin:@localhost:1521:XE?
You seem to have tried something similar but missing the machine and port locations.

Let us know how it goes.

[skinchu]

Hi Brian

Can you try jdbc:oracle:thin:@localhost:1521:XE?

It works with the above URL; it’s undumented in ME through.
Thanks for your help.
Stephen

[Author]

Posts