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.
setijoagus
