Pak, Konsepnya tuh begini:
Jika anda connect dengan cara "sqlplus / as sysdba" (tanpa menyebutkan netservicename). Connection Anda itu tidak melalui listener. Mau listener hidup, rusak, mati kek tetep bisa connect. Sebaliknya jika anda connect dengan cara "connect <username>/[EMAIL PROTECTED] Mau connect dari server atau dari client pc, tetep saja connectionnya lewat listener. Kalo listener nya gak beres yah gak bisa connect. Nah jadi sekarang kalo Anda connect "sqlplus / as sysdba", saya yakin bukan LISTENER masalahnya. biasanya kalo belum di set ORACLE_SID nya akan memberikan error seperti itu TNS protocol adapter error. ===================================================== C:\Documents and Settings\ysusanto>sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 6 09:36:56 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error ===================================================== ===================================================== C:\Documents and Settings\ysusanto>set ORACLE_SID=XE C:\Documents and Settings\ysusanto>sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 6 09:37:51 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> ====================================================== On 05/02/2008, Andes Febrian <[EMAIL PROTECTED]> wrote: > > gak bisa jg pak. > > kemudian database nya saya stop dan start begitu jg listenernya, masih gak > bisa. tp gini pak, waktu saya connect pertama kali, dgn command "sqlplus / > as sysdba" eror message pertama itu "eror ORAbla..bla..:tnslnsr ...exceeds > process..." saya lupa detailnya. tp setelah saya coba cari tau, dia > bilang, > "ini di sebabkan process dan memory yg terlalu tinggi, kill process yg > tidak > terpakai." tp setelah itu saya coba login lg, baru deh eror message "TNS > protocol adapter eror" coba2 set ORACLE_SID gak bisa jg. skrg saya restart > tu server, baru deh connect lg. tp knp ya tu listener bisa begitu ? dari > aplikasi log jg katanya listener yg refuse connect. knp ya ?? memory nya > kah > kurang, skrg memory di server tersebut 1GB. ini kejadian baru ini aja.. > kmrn2 gak pernah seperti ini. > > Terima kasih atas responnya. > > On 2/5/08, Yoel Susanto <[EMAIL PROTECTED] <yoel.susanto%40gmail.com>> > wrote: > > > > sebelum sqlplus / as sysdba, lakukan command berikut > > > > set ORACLE_SID=<nama DB> > > > > coba bisa gak? > > > > On 05/02/2008, Andes Febrian <[EMAIL PROTECTED]<pejantan4u%40gmail.com> > <pejantan4u%40gmail.com>> > > 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> > <johannes.sitorus%40pacomnet.com> > > <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] > > > > > > > > -- > Cheers, > ^_^ Andes ^_^ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
