oracle11g怎么重新设置端口,oracle11g修改或增加默认监听端口

■■oracle11g修改默认监听端口

正常情况下，oracle数据库服务端口一般是默认的1521端口，因为安全等原因可能需要修改此端口号为其他端口，以下为标准的步骤概要。

■在sqlplus修改数据库参数local_listener

备份原配置参数：create pfile='/home/oracle/listener.ora.orig20190530' from memory;

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1527))' scope=both;

■停监听

lsnrctl stop

■改监听配置文件listener.ora，把1521改为1527，其他地方不动

标准的配置格式

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cos6512c)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

ADR_BASE_LISTENER = /u01/app/oracle

■启动监听

lsnrctl start

■检查监听状态、数据库状态

■■增加监听端口

■listener.ora配置文件增加端口配置

LISTENER1527 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cos6512c)(PORT = 1527))

)

)

■启动新端口

lsnrctl> start listener1527

■数据库修改配置配置参数

alter system set local_listener='(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1527))))' scope=both;