DBA Hub

📋Steps in this guide1/1

Set local_listener in db

-- Make the sure the a listener is already running with that port(i.e 1524 here)

oracle configurationintermediate
by OracleDba
19 views
1

Set local_listener in db

Code/Command (click line numbers to comment):

1
2
3
4
-- Make the sure the a listener is already running with that port(i.e 1524 here)
alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = 162.20.217.15)(PORT = 1524))' scope=both;
alter system register;
select type, value from v$listener_network where TYPE='LOCAL LISTENER';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!