Dear all,
Listener di server saya sudah running dan database service jg sudah start,
tp ketika saya login dgn "sqlplus / as sysdba" maka oracle akan memunculkan
eror ERROR:ORA-12560: TNS:protocol adapter error. tp klo saya tnsping SID
nya.. maka akan di kembalikan ok oleh oracle. dan klo saya cek status maka
listenernya ok. saya coba login di server ini, tidak melalui client.
saya menggungakan server Windows Server 2003 dgn oracle database 10g
10.1.0.2.0
SID = orcl
berikut listener nya:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = helpdesksvr.ts.test.co.id)(PORT =
1521))
)
)
)
dan untuk tnsnamesnya :
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = helpdesksvr.ts.test.co.id)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
--
Cheers,
^_^ Andes ^_^
[Non-text portions of this message have been removed]
