这里的,状态UNKOWN即表明为静态注册(手动填写参数);服务“test”包含1个例程。例程"mydata",状态 UNKOWN,包含此服务的一个处理程序。。。服务"a"包含1个例程。例程"mydata",状态 READY,包含此服务的一个处理程序。。。
服务“test”包含1个例程。例程“mydata”,状态UNKOWN,包含此服务的一个处理程序。。。
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = test)(ORACLE_HOME = /orahome/oracle/product/10.2.0/db_1)(SID_NAME = mydata)))
ABC =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.23)(PORT = 1521)))(SERVICE_NAME =(CONNECT_DATA =
test)))
pmon在数据库启动到mount或open时,动态从参数文件中读取service_names值。service_names可以为多个值。1、缺省的动态注册
服务“test”包含1个例程。例程"mydata",状态 UNKOWN,包含此服务的一个处理程序。。。服务"a"包含1个例程。例程"mydata",状态 READY,包含此服务的一个处理程序。。。服务"b"包含1个例程。例程"mydata",状态 READY,包含此服务的一个处理程序。。。服务"c"包含1个例程。例程"mydata",状态 READY,包含此服务的一个处理程序。。。服务 "mydata.ccddt.cn" 包含一个例程。例程"mydata",状态 READY, 包含此服务的一个处理程序。。。
SQL>alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.23)(PORT=1525))';SQL>alter system register
System altered
3、查看监听器状态(DESCRIPTION =mytest =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST = 192.168.1.23)(PORT = 1525))
)
)这里的mytest也可以根据自己需要,修改为其他字符串。如a或b等。SQL>alter system set local_listener=mytest;设置参数,指定通过tnsnames.ora内的信息指定监听参数System alteredSQL>alter system register;
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.23)(PORT=1525)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 15-MAR-2011 10:43:47
Uptime 0 days 0 hr. 0 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /orahome/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /orahome/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraserver)(PORT=1525)))
Services Summary...
Service "a" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
Service "b" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
Service "c" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
Service "mydata" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
Service "mydataXDB" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
Service "mydata_XPT" has 1 instance(s).
Instance "mydata", status READY, has 1 handler(s) for this service...
The command completed successfully
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25264937/viewspace-689470/,如需转载,请注明出处,否则将追究法律责任。