- /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.153.17)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.233.17)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=orcl) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) (SID_NAME=orcl)))
listener.ora はこんな具合。
リスナーを起動すると、
$ lsnrctl start ... Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.153.17)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.233.17)(PORT=1521))) ...
問題なく起動できてるようだ。
リモートから sqlplus で接続してみると、
$ sqlplus system/manager@192.168.153.17:1521/orcl ... Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options $ sqlplus system/manager@192.168.233.17:1521/orcl ... Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
接続成功。。。
それだけっす。