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
No comments:
Post a Comment