******************************************************
* Description: Changing Oracle database listener port
* Date: 05:43 PM EST, 07/29/2019
******************************************************

		 
<1> Shutdown listener:
     |
     |__ CMD> lsnrctl stop
	 
	
	
	
<2> Update listener entry within listener.ora config file:
     |
     |__ o. LISTENER =
                 (DESCRIPTION_LIST =
                   (DESCRIPTION =
                     (ADDRESS = (PROTOCOL = TCP)(HOST = test003cm104.hhs.gov)(PORT = 5920))
                     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC5920))
                   )
                 )
				 
				 
				 
				 
<3> Update tnsnames.ora to ensure database knows the network service name:
     |
     |__ o. LISTENER =
                 (DESCRIPTION =
                         (ADDRESS = (PROTOCOL = TCP)(HOST = a1enr003cm106.hhs.gov )(PORT = 5920))
                 )


	
<4> Register the new listener info within database:
     |
     |__ SQL> alter system set local_listener='LISTENER' scope=BOTH;


	 

<5> Startup listener:
     |
     |__ o. When database created, the default listener port is 1521, and no listener files were created under $ORACLE_HOME/network/admin folder.
     |
     |__ o. In addition, the listener port can be updated by netmgr/netca untilities under $ORACLE_HOME/bin folder.
	
	
	
	
Reference:
     |
     |__ o. My Oracle Support [Doc ID 359277.1]: Changing Default Listener Port Number