RAC db指定local_listener

来源:互联网 发布:办公软件相关书籍 编辑:程序博客网 时间:2024/06/14 19:56


异常:测试RAC DB装起来之后,port指定 1522,但 client连接时报错 No Listener

解决:

1)     在2个节点分别执行:

alter system set local_listener = '(ADDRESS =(PROTOCOL=TCP)(HOST=db303v)(PORT=1522))' sid ='trel2';

alter system set local_listener = '(ADDRESS =(PROTOCOL=TCP)(HOST=db103v)(PORT=1522))' sid ='trel1';

或 单独执行:alter system set local_listener = LISTENERS_TREL;

2)   重开 listener. 确认listener正常开启后, 测试连接instance