[oracle@standby oracle]$ cd /opt/oracle/product/9.2.0/network/admin/
[oracle@standby admin]$ cat listener.ora
# listener.ora network configuration file: /opt/oracle/product/9.2.0/network/admin/listener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc))
)
(address_list =
(address = (protocol = tcp)(host = standby)(port = 1521))
)
)
)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /opt/oracle/product/9.2.0)
(program = extproc)
)
(sid_desc =
(global_dbname = primary)
(oracle_home = /opt/oracle/product/9.2.0)
(sid_name = primary)
)
)
[oracle@standby admin]$ cat tnsnames.ora
# tnsnames.ora network configuration file: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# generated by oracle configuration tools.
standby =
(description =
(address_list =
(address = (protocol = tcp)(host = 172.16.33.46)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = primary)
)
)
primary =
(description =
(address_list =
(address = (protocol = tcp)(host = 172.16.33.58)(port = 1521))
)
(connect_data =
(server = dedicated)
(service_name = primary)
)
)
[oracle@standby admin]$ lsnrctl start
lsnrctl for linux: version 9.2.0.4.0 - production on 16-aug-2004 10:46:31
copyright (c) 1991, 2002, oracle corporation. all rights reserved.
starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...
tnslsnr for linux: version 9.2.0.4.0 - production
system parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora
log messages written to /opt/oracle/product/9.2.0/network/log/listener.log
listening on: (description=(address=(protocol=ipc)(key=extproc)))
listening on: (description=(address=(protocol=tcp)(host=standby)(port=1521)))
connecting to (description=(address=(protocol=ipc)(key=extproc)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 9.2.0.4.0 - production
start date 16-aug-2004 10:46:31
uptime 0 days 0 hr. 0 min. 0 sec
trace level off
security off
snmp off
listener parameter file /opt/oracle/product/9.2.0/network/admin/listener.ora
listener log file /opt/oracle/product/9.2.0/network/log/listener.log
listening endpoints summary...
(description=(address=(protocol=ipc)(key=extproc)))
(description=(address=(protocol=tcp)(host=standby)(port=1521)))
services summary...
service "plsextproc" has 1 instance(s).
instance "plsextproc", status unknown, has 1 handler(s) for this service...
service "primary" has 1 instance(s).
instance "primary", status unknown, has 1 handler(s) for this service...
the command completed successfully
5.配置备用数据库监听器及tnsnames.ora文件
配置后文件如下:
|
