Coba :
1. Sebagai user oracle (su oracle), cek Status Listener dengan perintah
>lsnrctl status
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
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
