oracle 11g 修改默认监听端口1521
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. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b28-122.jd.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 22-OCT-2013 04:02:12
Uptime 20 days 22 hr. 34 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
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...
Service "yoon" has 1 instance(s).
Instance "yoon", status READY, has 1 handler(s) for this service...
Service "yoonXDB" has 1 instance(s).
Instance "yoon", status READY, has 1 handler(s) for this service...
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. All rights reserved.
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 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、启动监听
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. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=b28-122.jd.com)(PORT=1515)))
STATUS of the LISTENER
------------------------
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. 53 sec
Trace Level off
Security ON: Local OS Authentication
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...
Service "yoon" has 1 instance(s).
Instance "yoon", status READY, has 1 handler(s) for this service...
Service "yoonXDB" has 1 instance(s).
Instance "yoon", status READY, has 1 handler(s) for this service...
The command completed successfully
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· winform 绘制太阳,地球,月球 运作规律
· AI与.NET技术实操系列(五):向量存储与相似性搜索在 .NET 中的实现
· 超详细:普通电脑也行Windows部署deepseek R1训练数据并当服务器共享给他人
· 上周热点回顾(3.3-3.9)
· AI 智能体引爆开源社区「GitHub 热点速览」