1 instance – more listener with more LAN card in Oracle 11g di Linux

12 May

1. periksa ip server
[oracle@orcl4 ~]$ /sbin/ifconfig
eth0      Link encap:Ethernet  HWaddr 00:16:76:9A:37:3C
inet addr:172.20.33.35  Bcast:172.20.255.255  Mask:255.255.0.0
inet6 addr: fe80::216:76ff:fe9a:373c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
RX packets:88951 errors:0 dropped:0 overruns:0 frame:0
TX packets:1436 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:7085890 (6.7 MiB)  TX bytes:421790 (411.9 KiB)
Interrupt:201 Base address:0xe000

eth1      Link encap:Ethernet  HWaddr 00:10:18:1D:30:4C
inet addr:172.20.33.37  Bcast:172.20.255.255  Mask:255.255.0.0
inet6 addr: fe80::210:18ff:fe1d:304c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST  MTU:1492  Metric:1
RX packets:91345 errors:0 dropped:0 overruns:0 frame:0
TX packets:62 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:8256689 (7.8 MiB)  TX bytes:13423 (13.1 KiB)
Interrupt:169

[oracle@orcl4 ~]$ cat /etc/hosts
127.0.0.1       localhost.localdomain   localhost
172.20.33.34    orcl3   orcl3.localdomain
172.20.33.35    orcl4   orcl4.localdomain
172.20.33.36    rac     rac.localdomain

2. setelah listener dijalankan & status
[oracle@orcl4 u01]$ lsnrctl start listener
[oracle@orcl4 u01]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 12-MAY-2010 08:10:12
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl4.localdomain)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date                12-MAY-2010 07:59:48
Uptime                    0 days 0 hr. 10 min. 24 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/orcl4/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl4)(PORT=1521)))
Services Summary…
Service “orcl4” has 1 instance(s).
Instance “orcl4”, status READY, has 1 handler(s) for this service…
Service “orcl4XDB” has 1 instance(s).
Instance “orcl4”, status READY, has 1 handler(s) for this service…
Service “orcl4_XPT” has 1 instance(s).
Instance “orcl4”, status READY, has 1 handler(s) for this service…
The command completed successfully

3. mengedit tnsnames.ora pada client
[oracle@orcl4 u01]$ vi /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
ORCL4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl4)
)
)

ORCL4b =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.33.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl4)
)
)

4. test koneksi
[oracle@orcl4 admin]$ sqlplus / as sysdba
SQL> conn scott/tiger@orcl4
Connected.
SQL> conn scott/tiger@orcl4b
Connected.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: