Oracle 11g R2 database Listener name and port change

Before change all this user account password if you don’t have

sqlplus / sysdba

SQL>alter user DBSNMP identified by Oraclesoft1234;

SQL>alter user SYSMAN identified by Oraclesoft1234;

SQL>alter user SYS identified by Oraclesoft1234;

Oracle 11G installation itself   it configure the listener   port and name default valves listener name 1521

Stop enterprise, manager if it’s running

$emctl stop dbconsole

Stop Listener service form oracle user

$lsnrctl stop

Shutdown database

SQL>shutdown immediate;

Configure Listener via netmgr 

add as following here my database , instance and Listener  name  is TEST 

change to  port 1521 to 1581

Start Listener

$lsnrctl start TEST

Start Database

$SQL>startup;

Change EM connection setting my environment

cd $ORACLE_HOME

$vi oracledb.asianalliance.lk_TEST/sysman/emd/targets.xml

<Targets AGENT_TOKEN="b456281d5c4179ddb61b0a9ddb9096ec49974a55">

        <Target TYPE="oracle_emd" NAME="oracledb.asianalliance.lk:1830"/>

        <Target TYPE="host" NAME="oracledb.asianalliance.lk"/>

        <Target TYPE="oracle_database" NAME="TEST.asianalliance.lk">

                <Property NAME="MachineName" VALUE="oracledb.asianalliance.lk"/>

                <Property NAME="Port" VALUE="1591"/>

                <Property NAME="SID" VALUE="TEST"/>

                <Property NAME="OracleHome" VALUE="/u01/app/oracle/product/11.2.0/db_1"/>

                <Property NAME="UserName" VALUE="6816abbd9dc4ab8d" ENCRYPTED="TRUE"/>

                <Property NAME="password" VALUE="75c3b2e1593efb64f4c4e4df64ce553a" ENCRYPTED="TRUE"/>

        </Target>

        <Target TYPE="oracle_listener" NAME="TEST_oracledb.asianalliance.lk">

                <Property NAME="Machine" VALUE="oracledb.asianalliance.lk"/>

                <Property NAME="LsnrName" VALUE="TEST"/>

                <Property NAME="Port" VALUE="1591"/>

                <Property NAME="OracleHome" VALUE="/u01/app/oracle/product/11.2.0/db_1"/>

                <Property NAME="ListenerOraDir" VALUE="/u01/app/oracle/product/11.2.0/db_1/network/admin"/>

        </Target>

</Targets>

Note:- change port number same as listener  port in my case I have changed  to 1521 to 1591

Save and exit

$vi oracledb.asianalliance.lk_TEST/sysman/config/emoms.properties

#Sat Apr 26 10:39:03 IST 2014

oracle.sysman.emSDK.svlt.ConsoleServerName=oracledb.asianalliance.lk\:1158_Management_Service

oracle.sysman.eml.mntr.emdRepPwd=084b8870e803f993c44c431a5baca45b

emdrep.ping.pingCommand=/usr/sbin/ping6 <hostname>

em_oob_shutdown=false

LargeRepository=false

oracle.sysman.eml.mntr.emdRepPort=1591

oracle.sysman.eml.mntr.emdRepDBName=TEST.asianalliance.lk

EMD_URL=https\://oracledb.asianalliance.lk\:1830/emd/main

em_email_address=%EM_EMAIL_ADDRESS%

oracle.sysman.eml.mntr.emdRepPwdSeed=1538274441055057388

oracle.sysman.emSDK.svlt.ConsoleMode=standalone

em_oob_crash=false

em.oms.dumpModules=omsThread,repos

oracle.sysman.emRep.dbConn.statementCacheSize=50

oracle.sysman.db.isqlplusUrl=http\://oracledb.asianalliance.lk\:/isqlplus/dynamic

em_oob_startup=false

oracle.sysman.emSDK.svlt.ConsoleServerPort=1158

oracle.sysman.eml.mntr.emdRepRAC=FALSE

em_from_email_address=%EM_FROM_EMAIL_ADDRESS%

oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

oracle.sysman.db.isqlplusWebDBAUrl=http\://oracledb.asianalliance.lk\:/isqlplus/dba/dynamic

oracle.sysman.emSDK.svlt.ConsoleServerHost=oracledb.asianalliance.lk

oracle.sysman.eml.mntr.emdRepDBID=2143789752

oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158

em_email_gateway=%EM_EMAIL_GATEWAY%

oracle.sysman.eml.mntr.emdRepServer=oracledb.asianalliance.lk

oracle.sysman.eml.mntr.emdRepSID=TEST

oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=oracledb.asianalliance.lk)(PORT\=1591)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))

oracle.sysman.emSDK.sec.ReuseLogonPassword=true

oracle.sysman.emkeyfile=/u01/app/oracle/product/11.2.0/db_1/oracledb.asianalliance.lk_TEST/sysman/config/emkey.ora

em.ip.ui.enable=true

oracle.sysman.eml.mntr.emdRepUser=SYSMAN

oracle.sysman.emSDK.svlt.PublicServletEnabled=true

Note :- Change all port numbers 1521 to  1591

$emctl start dbconsole

$emctl stop dbconsole

$emctl status dbconsole