Modify the Oracle10g port and change EM

To modify the Oracle10g port, you must modify two files. (Modified by red hat linux as4u6)

Listener. ora and tnsnames. ora

All files are in the/opt/oracle10g/product/10.2.0.1/db_1/network/admin directory.

Modify listener. ora as follows:

--------------------------------------------

# Listener. ora Network Configuration File:/opt/oracle10g/product/10.2.0.1/db_1/network/admin/listener. ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME =/opt/oracle10g/product/10.2.0.1/db_1)

(PROGRAM = extproc)

)

 (SID_DESC =

(GLOBAL_DBNAME = SID Name)

(ORACLE_HOME =/opt/oracle10g/product/10.2.0.1/db_1)

(SID_NAME = SID Name)

)

)

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

(ADDRESS = (PROTOCOL = TCP) (HOST = zz.net) (PORT =New Port Number))

)

)

--------------------------------------------- The text in the middle is added in italic; tnsnames. ora ------------------------------------------- # Generated by Oracle configuration tools. BDHTDBSM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = zz.net) (PORT = new PORT number) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BDHTDBSMS ))) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO ))) ------------------------------------------- since the EM (Enterprise Manager) is connected to the original data, you need to modify emca-config dbcontrol db (Run "reconfigure" and enter the new port number as required)