pl/sql监听配置

数据库正常连接后：
主机：test2> cd $ORACLE_HOME ；

主机：test2>cd network/admin;

ADR_BASE_URIS = $ORACLE_BASE;
主机：test2> ifconfig ///view ip

test2=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =VIP)(PORT=PORT))
)
)

SQL >lsnrctl start test2 //配置监听
SQL >lsnrctl status test2 //查看监听状态

SQL > alter system set local_listener=’(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VIP)(PORT=PORT)))’;

SQL > alter system register;

打开pl/sql
用户名：sys
密码：
数据库：ip:port/test2
权限：sysdba

ok

监听程序查看:
lsnrctl help | start | status | stop
主机：test2> lsnrctl status;

Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM2”, status READY, has 1 handler(s) for this service…
//服务名为+ASM2，实例名为+ASM2,状态动态注册

Service “DBUA0257759” has 1 instance(s).
Instance “DBUA0257759”, status BLOCKED, has 1 handler(s) for this service…
//服务名为+ASM2，实例名为+ASM2,状态BLOCKED