oracle怎么增加端口号,如何修改oracle的端口号

请看文件在ORACLEHOME/network/admin/listener.ora

的内容,

# LISTENER.ORA Network Configuration File: /oracle/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = bmser)(PORT = 1521))#这是端口号

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle)

(PROGRAM = extproc)

)

(SID_DESC =  (GLOBAL_DBNAME = bmdb)

(ORACLE_HOME = /oracle)

(SID_NAME = bmdb)

)

)

修改完后,重起,

lsnrctl start

试试