Changing the Net Listener Port in Oracle Applications Server 10g
Changing the Net Listener Port in Oracle Applications Server 10g
In my previous post I discussed installing the 10g application server. The Application server installation uses the port 1521 as the default port for the application meta data repository. If you already have a listener using that port you have the option of either sharing the listener or configuring a new listener. In my case i tried to change the listener and found out it included just a little bit more than just changing the listener.ora file.
I am listing out the steps that i performed to configure a new listener and get the applications server back to shape.
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: asinf
Middle Tier OS user: asmid
Task
Current Listener running on port 1521.
Configuring a new listener on port 1525
Shutdown Services.
Shutdown all the infrastructure and middle tier services.
su - asmid
$opmnctl stopall
$emctl stop iasconsole
su - asinf
$opmnctl stopall
$emctl stop iasconsole
Shutdown Your Infrastructure Listener
# su - asinf
$lsnrctl stop
Change The Listener Configuration
Make the change to have the new post number in the lsitener.ora file on your infrastructure tier.
# su - asinf
$cd $ORACLE_HOME/network/admin
$vi listener.ora
SID_LIST_SAM =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u03/oracleAS/asinf/OraHome)
(PROGRAM = extproc)
)
)
SAM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
samlnx02.appsdbablog.com)(PORT = 1525))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
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.
$su - asinf
$ vi $ORACLE_HOME/network/admin/tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = samlnx02.appsdbablog.com)(PORT
= 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
SAM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = samlnx02.appsdbablog.com)(PORT =
1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sam.appsdbablog.com)
)
)
Also replicate this change in middle tier tnsnames.ora.
Start Your Listener
Start your infrastructure tier listener.
# su - asinf
$lsnrctl start SAM
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.
# su - asinf
$sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.4.2 - Production on Thu Oct 26 18:38:38 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system set local_listener='SAM';
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
# su - asinf
$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
Under Entry Management->cn=Oracle Context->cn=SAM->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
$ORACLE_HOME/sysman/emd/targets.xml
$ORACLE_HOME/Apache/modplsql/conf/dads.conf
