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.comorcl" > 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
