Hi All,
From remote systems i can connect to database BUT i am unable to connect to database from the host where database is installed. I am receiving below error
ORA-12560: TNS:protocol adapter error
OS= Windows server 2003
DB=10g 64bit (10.2.0.1.0)
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cibsreport)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
CIBSINIT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CIBSREPORT)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CIBSINIT)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
lsnrctl services
C:\Documents and Settings\Administrator>lsnrctl services
LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 03-AUG-2011 18:23:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cibsreport)(PORT=1521)))
Services Summary...
Service "+ASM_XPT" has 1 instance(s).
Instance "+asm", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:7 refused:0 state:ready
LOCAL SERVER
Service "+asm" has 1 instance(s).
Instance "+asm", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:7 refused:0 state:ready
LOCAL SERVER
Service "CIBSINITXDB" has 1 instance(s).
Instance "cibsinit", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: CIBSREPORT, pid: 2588>
(ADDRESS=(PROTOCOL=tcp)(HOST=cibsreport)(PORT=1062))
Service "CIBSINIT_XPT" has 1 instance(s).
Instance "cibsinit", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:24 refused:0 state:ready
LOCAL SERVER
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
Service "cibsinit" has 1 instance(s).
Instance "cibsinit", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:24 refused:0 state:ready
LOCAL SERVER
The command completed successfully
C:\Documents and Settings\Administrator>set ORACLE_SID=CIBSINIT
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 3 18:24:17 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn system
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
but i can connect from system user from remote machine
followed the article 238664.1 as suggested in thread(
76240 but no result
Regards,
Asim