Tuesday, January 24, 2012

Enable "Dynamic service registration" with Oracle TNS Listener

-- shows if it is enabled
sqlplus / as sysdba
show parameter local_listener

alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521))'
alter system register;

No comments:

Post a Comment