sebelum sqlplus / as sysdba, lakukan command berikut set ORACLE_SID=<nama DB>
coba bisa gak? On 05/02/2008, Andes Febrian <[EMAIL PROTECTED]> wrote: > > pak jo, makasih atas replynya.. tp disini saya coba login bukan dari > client > tp dari server databasenya sendiri. klo di tnsping dari server itu sendiri > bisa. maksud koneksi intermitten apa ya ? > > > On 2/5/08, Johannes Christian <[EMAIL > PROTECTED]<johannes.sitorus%40pacomnet.com>> > wrote: > > > > 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] > > > > > > > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
