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

2 comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.