menurut pengalaman sih itu karena masalah di network nya, bisa saja karena koneksi yang intermitten. Gimana kalau coba telnet ke port listener nya?
--jo-- Andes Febrian wrote: > > 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] > >
