OS:
Oracle Linux Server release 5.7
DB:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
1、查看监听状态:
SQL> !lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-NOV-2013 01:36:29
Copyright (c) 1991, 2011, Oracle.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b28-122.jd.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
Version
Start Date
Uptime
Trace Level
Security
SNMP
Listener Parameter File
Listener Log File
Listening Endpoints Summary...
Services Summary...
Service "yoon" has 1 instance(s).
Service "yoonXDB" has 1 instance(s).
The command completed successfully
2、停止监听
SQL> !lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-NOV-2013 02:37:43
Copyright (c) 1991, 2011, Oracle.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b28-122.jd.com)(PORT=1521)))
The command completed successfully
3、修改tnsnames.ora和listener.ora文件中端口号
将1521修改为1515
4、在数据库中初始化参数local_listener
SQL> show parameter local_listener;
NAME
------------------------------------ --------------------------------- ------------------------------
local_listener
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = b28-122.jd.com)(PORT = 1515))';
System altered.
SQL> show parameter local_listener;
NAME
------------------------------------ --------------------------------- ------------------------------
local_listener
5、启动监听
SQL> !lsnrctl start
6、查看监听
SQL> !lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 12-NOV-2013 02:43:08
Copyright (c) 1991, 2011, Oracle.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b28-122.jd.com)(PORT=1515)))
STATUS of the LISTENER
------------------------
Alias
Version
Start Date
Uptime
Trace Level
Security
SNMP
Listener Parameter File
Listener Log File
Listening Endpoints Summary...
Services Summary...
Service "yoon" has 1 instance(s).
Service "yoonXDB" has 1 instance(s).
The command completed successfully