1. Dari hasil cek listener, status Listener belum running. Coba jalankan listener secara manual sebagai user oracle (su oracle) dan cek status kembali. > lsnrctl start > lsnrctl status
2. Check dan pastikan apakah database sudah running dengan login via sqlplus sebagai sys as sysdba sebagai user oracle # su oracle > sqlplus sys as sysdba Masukan password sys/system sesuai saat install pertama kali. Bila muncul pesan Connected to idle instance berarti database belum running. Start database dengan perintah: sql> startup 3. Check kembali status Listener. Pastikan orcl terdapat dalam list listener. ----- Original Message ----- From: "dian Cakra" <[email protected]> To: "Abraham Sulaeman" <[email protected]>, "Mailing List Komunitas openSUSE Indonesia" <[email protected]> Sent: Wednesday, January 19, 2011 3:07:12 PM GMT +07:00 Bangkok, Hanoi, Jakarta Subject: Re: [*openSUSE-ID*] Install Oracle 10g Release 2 (10.2) diopenSUSE11.2 (i586) Listener tidak Bisa UP 2011/1/19 Abraham Sulaeman < [email protected] > Coba : 1. Sebagai user oracle (su oracle), cek Status Listener dengan perintah >lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-JAN-2011 15:04:30 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.235)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused 2. Edit /etc/hosts, hapus/comment "192.168.100.235 orcl.hanoman.com orcl" 3. Sebagai user oracle cek parameter ORACLE_SID >env | grep ORACLE_SID ORACLE_SID=orcl Regards, Abraham ----- Original Message ----- From: "dian Cakra" < [email protected] > To: [email protected] , "Mailing List Komunitas openSUSE Indonesia" < [email protected] > Sent: Wednesday, January 19, 2011 11:56:19 AM GMT +07:00 Bangkok, Hanoi, Jakarta Subject: Re: [*openSUSE-ID*] Install Oracle 10g Release 2 (10.2) diopenSUSE11.2 (i586) Listener tidak Bisa UP thanks atas responnya... Semuanya sdh dilakukan Mas, hasilnya errornya masih sama - Hapus File/Folder /var/tmp/.oracle - isi /etc/hosts $ cat /etc/hosts #127.0.0.1 localhost.localdomain localhost 192.168.100.235 orcl.hanoman.com orcl $ cat listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.235)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/ 10.2.0.1 ) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /opt/oracle/ 10.2.0.1 ) (SID_NAME = orcl) ) ) $ cat tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.235)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 2011/1/19 Suyanto < [email protected] > > Coba lagi > > TNS-12560: TNS:protocol adapter error > > Coba hapus file yg ada di soket directory /var/tmp/.oracle > > > > > > Thanks & Regards, > > jazznuno.wordpress.com > > -----Original Message----- > From: dian Cakra < [email protected] > > Sender: [email protected]: Tue, 18 Jan 2011 13:50:48 > To: Mailing List Komunitas openSUSE Indonesia< [email protected] > > Reply-To: Mailing List Komunitas openSUSE Indonesia < > [email protected] > > Subject: Re: [*openSUSE-ID*] Install Oracle 10g Release 2 (10.2) di > openSUSE11.2 (i586) Listener tidak Bisa UP > > Thanks Atas responnya, > > konfigurasi IP sudah sama Mas > > 2011/1/18 Suyanto < [email protected] > > > > Tebak-tebak buah manggis > > > > Coba cek IP Host anda > > Samakan dengan yang ada di tnsnames.ora dan di listener.ora > > > > > > > > > > > > Thanks & Regards, > > > > jazznuno.wordpress.com > > ______________________________________________ > > --- > > Info Milis : http://opensuse.or.id/milis > > Keluar dari Milis : Kirim email ke > [email protected] > > Manajemen Keanggotaan : > > http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org > > > ______________________________________________ > --- > Info Milis : http://opensuse.or.id/milis > Keluar dari Milis : Kirim email ke [email protected] > Manajemen Keanggotaan : > http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org > ______________________________________________ > --- > Info Milis : http://opensuse.or.id/milis > Keluar dari Milis : Kirim email ke [email protected] > Manajemen Keanggotaan : > http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org > ______________________________________________ --- Info Milis : http://opensuse.or.id/milis Keluar dari Milis : Kirim email ke [email protected] Manajemen Keanggotaan : http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org ______________________________________________ --- Info Milis : http://opensuse.or.id/milis Keluar dari Milis : Kirim email ke [email protected] Manajemen Keanggotaan : http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org ______________________________________________ --- Info Milis : http://opensuse.or.id/milis Keluar dari Milis : Kirim email ke [email protected] Manajemen Keanggotaan : http://lists.opensuse-id.org/listinfo.cgi/milis-opensuse-id.org
