终于把oracle lsnrctl 动态监听搞懂了

步骤

1.netca ,add ,一路下去,就ok 了,默认1521 ,

 

如果这步他提示监听端口已经被占用,那么把 $oracle_home/network/admin下面的 listener.ora,给删了,动态监听不需要自己配置

默认

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

host 是主机名,比如说我的vps3,那么要在/etc/hosts下绑定一下

127.0.0.1  vps3

不然会出现莫名的ip ,你就永远也得不到正确的监听了。。这步很重要。

2.database startup ,pmon 会自动监听的,lscnctl status 会

Service "testdb" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
Service "testdbXDB" has 1 instance(s).
  Instance "testdb", status READY, has 1 handler(s) for this service...
The command completed successfully

posted @ 2013-06-03 18:11  过去的我  阅读(1232)  评论(0编辑  收藏  举报