- /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
接続成功。。。
それだけっす。