Oracle Database Discussions

I am using Oracle 10g. Facing the same kind of problem. Also I am not able to connect isqlplus as well

java.sql.SQLException: 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:orcl

Where as I am very much able to connect to DB through sqlplus but not through either TOAD or Java program.

I was very much able to connect earlier. I have made no changes to oracle.



output of "tnsping orcl" :

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JAN-2
011 00:02:53

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
F:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localho
st) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (30 msec)

output of "LSNRCTL SERVICES"


LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JAN-2011 00:04
:59

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully








- Thanks

Edited by: 832294 on Mar 3, 2011 9:56 AM