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