OS:
Oracle Linux Server Release 5.7
Db:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
1. Check the Listening status:
sql>!lsnrctl Status
Lsnrctl for linux:version 11.2.0.3.0-production on 12-nov-2013 01:36:29
Copyright (c) 1991, Oracle. All rights reserved.
Connecting to (description= (address= (protocol=tcp) (host=b28-122.jd.com))
STATUS of the port=1521
------------------------
Alias LISTENER
Version Tnslsnr for linux:version 11.2.0.3.0-production
Start Date 22-oct-2013 04:02:12
Uptime hr. Min. SEC
Trace level off
Security on:local OS Authenticati On
SNMP OFF
Listener Parameter file/u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log file/u01/oracle/diag/tnslsnr/b28-122/listener/alert/log.xml
Listening Endpoints Summary ...
(description= (address= (protocol=tcp) (host=b28-122.jd.com) (port=1521))
(description= (address= (PROTOCOL= IPC) (key=extproc1521))
Services Summary ... The
Service "Yoon" has 1 instance (s).
Instance "Yoon", status ready, have 1 handler (s) for the This service ... The
Service "Yoonxdb" has 1 instance (s).
Instance "Yoon", status ready, have 1 handler (s) for the This service ...
The command completed successfully
2. Stop Monitoring
Sql>!lsnrctl Stop
Lsnrctl for linux:version 11.2.0.3.0-production on 12-nov-2013 02:37:43
Copyright (c) 1991, Oracle. All rights reserved.
Connecting to (Description= (address= (protocol=tcp) (host=b28-122.jd.com) (port=1521)))
The command completed successfully
3. Modify the port number in the Tnsnames.ora and Listener.ora files
Change 1521 to 1515
4. Initialize the parameter Local_listener in the database
Sql> Show parameter Local_listener;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
Local_listener string
Sql> alter system set local_listener= ' (ADDRESS = (PROTOCOL = TCP) (HOST = b28-122.jd.com) (PORT = 1515)) ';
System altered.
Sql> Show parameter Local_listener;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
Local_listener string (ADDRESS = (PROTOCOL = TCP) (HO
ST = b28-122.jd.com) (PORT = 15
15))
5. Start monitoring
Sql>!lsnrctl Start
6. View Monitoring
sql>!lsnrctl Status
Lsnrctl for linux:version 11.2.0.3.0-production on 12-nov-2013 02:43:08
Copyright (c) 1991, Oracle. All rights reserved.
Connecting to (description= (address= (protocol=tcp) (host=b28-122.jd.com))
STATUS of the port=1515
------------------------
Alias LISTENER
Version Tnslsnr for linux:version 11.2.0.3.0-production
Start Date 12-nov-2013 02:42:15
Uptime 0 days 0 hr. 0 min. $ sec
Trace level off
Security on:local OS authentication< Br>snmp OFF
Listener Parameter file/u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File/u01/oracle/diag/tnslsnr/b28-122/listener/alert/log.xml
Listening Endpoints Summary ...
(description= (address= (protocol=tcp) (host=b28-122.jd.com) (port=1515))
(description= (address= (PROTOCOL= IPC) (key=extproc1515))
Services Summary ... The
Service "Yoon" has 1 instance (s).
Instance "Yoon", status ready, have 1 handler (s) for the This service ... The
Service "Yoonxdb" has 1 instance (s).
Instance "Yoon", status ready, have 1 handler (s) for the This service ...
The command completed successfully
Oracle 11g modifies the default listening port 1521