oracle11g监听相关知识.docVIP

1.修改oracle11g动态监听端口步骤。（1）修改grid用户下的/opt/oracrs/product/11gR2/grid/network/admin/ Listener.ora把1521换成1523 LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523)) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1523)) ) ) ADR_BASE_LISTENER = /opt/oracrs/base ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON 重启监听服务 lsnrctl start,你会发现没有监听到服务 [grid@oracle ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-MAY-2014 23:48:54 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 24-MAY-2014 23:28:24 Uptime 0 days 0 hr. 20 min. 29 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracrs/product/11gR2/grid/network/admin/listener.ora Listener Log File /opt/oracrs/base/diag/tnslsnr/oracle/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1523))) The listener supports no services The command completed successfully 进入数据库修改动态注册，先执行一下create pfile from spfile,备份参数文件。 SQL alter system set local_listener=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1523))(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1523)))) sid=ora11g; SQL show parameter local_listener; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=orac le)(PORT=1523))(ADDRESS=(PROTO COL=TCP)(HOST=oracle)(PORT=152 ))) （4）在GRID用户下用lsnrctl status查看，表示已经有动态监听注册了，READY表示动态注册。 [