修改Oracle监听端口

修改oracle监听端口

修改端口号的整体步骤：
1.1   查看当前监听的状态
1.2   停止监听
1.3   修改监听文件的端口号
1.4   修改初始化参数local_listener
1.5   重启监听器
1.6   修改完毕，使用新端口登录测试

实践步骤：

1.1 查看当前监听的状态

[test@ASI-1 ~]$lsnrctl status

 

1.2 停止监听

[test@ASI-1~]$lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-MAR-2011 16:36:49 Copyright (c) 1991, 2005, Oracle.  All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521))) The command completed successfully

 

1.3修改监听文件的端口号

把端口号修改为1530，分别修改listener.ora和tnsname.ora文件

[test@ASI-1 ~]$ cd/usr/opt/oracle/product/10.2.0/db_1/network/admin/

[test@ASI-1 admin]$ pwd

/usr/opt/oracle/product/10.2.0/db_1/network/admin

[test@ASI-1~]$vi  listener.ora

# listener.ora Network Configuration File: /usr/opt/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = /usr/opt/oracle/product/10.2.0/db_1)       (PROGRAM = extproc)     )     (SID_DESC =