Changing the Net Listener Port in Oracle Applications Server 10g

Change port number 1521 to 1531 or anyone

Find the step by step that i performed to configure a new listener .

System Overview

10g Application server with infrastructure and middle tier installed on the same box.

Infrastructure Tier Services
OID
HTTP Server

Middle Tier Application
Portal

OS Users

Infrastructure OS user: oracle
Middle Tier OS user: oracle

Task
Current Listener running on port 1521.
Configuring a new listener on port 1531

Shutdown Services.

Shutdown all the infrastructure and middle tier services.

INFRA

$opmnctl stopall
$emctl stop iasconsole

MIDDLE TIER

$opmnctl stopall
$emctl stop iasconsole

Shutdown Your Infrastructure Listener

$lsnrctl stop

Change The Listener Configuration

Make the change to have the new post number in the lsitener.ora file on your infrastructure tier.
bash-2.05b$ more listener.ora
# listener.ora Network Configuration File: /u01/scr/disco10g/OraHome_10/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/scr/disco10g/OraHome_10)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1531))
)
)

)

Change Your TNSNAMES

After this you need to make the change reflecting the new port in your TNSNAMES.ora file on both the infrastructure tier and the middle tier.

bash-2.05b$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/scr/disco10g/OraHome_10/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

BLDISCO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bldisco.doyen.com)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = apollo.doyen.com)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

Also replicate this change in middle tier tnsnames.ora.


Start Your Listener
Start your infrastructure tier listener.

$lsnrctl start bldisco

Set The New Listener At The Database Level.

You must execute this command in your infrastructure database to have the parameter local_listener set to your new listener.


$sqlplus "/ as sysdba"
SQL> alter system set local_listener='bldisco';
system altered

Bounce The Database.

Stop and startup your meta data repository database to have it register the new listener name.

Start Your OID On The Infrastructure Tier
$opmnctl startproc ias-component=OID

Change The Port Number In OID.

Start the Oracle Directory Manager from your desktop if you have the client installed else you can use the one on the server at $ORACLE_HOME/bin/oidadmin





Click add button and provide 10g infra hostname



Provide infra username and password

UserName : orcladmin
Password : xxxxxxxx







Click Entry Management –> cn=OraleContext ->bldisco(SID NAME) -> orclnetdescstring chnage the value of the new port here




Change The Other Config Files.

Based on your installation you may need to change the following files also

/u01/scr/disco10g/OraHome_10/sysman/emd/targets.xml
/u01/scr/disco10g/OraHome_10/Apache/modplsql/conf/dads.conf