Thursday, November 12, 2009

Changing ORACLE LISTENER port number

Stop Listener

Change the port number in the following path:
D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora

Change the port number to desired port number and save.

Start the listener.

Run the following statement in the SQL prompt as sys dba.
ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = host-name)(PORT = 1522))';

Check the status of listener, it should pick up your service name.

No comments:

Post a Comment