HOW TO CHANGE THE LISTENER PORT NUMBER ?

1)    first down the listener and the database.

       

2)go to cd $ORACLE_HOME/network/admin----àlistener.ora

                   vi listener.ora

 (KEY=EXTRROC1521)

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebus.testvision.com)(PORT=1521)))

Here change 1521--->1535 in both cases.

Then save it :wq

3)start listener.it will start with new port number.then start the database also.then check in toad with new port number.it will show the error.Since we are not registered the new port number with sid it will throw the error.

ORA-12505 TNS listener does not currently known of SID given in connect descriptor.

Since we are not registered the new port number with sid it will throw the error.

4)then connect to sqlplus

Sql>ALTER SYSTEM SET LOCAL_LISTENER=”(ADDRESS=(PROTOCOL=TCP)(HOST=ebus.testvision.com)(PORT=1535))”;

System altered

5)sql>ALTER SYSTEM REGISTER;