Dynamic registration in Oracle
· * In a server if there is a listener running, then an Oracle database can dynamically register it in the listener to provide its service. · * This dynamic registration is automatic if the listener is running in the Oracle default listening port 1521 · * Incase if you want to allow dynamic database registration only to certain databases in the server. You need to run the listener in non-default port. (For example: 1522 or 1530 etc) · * To allow dynamic registration of database services in the listener with non-default port we need to modify few parameters in database level. No changes needed in listener.ora file. Below are the parameters o In case if the listener and database are in same server change the parameter LOCAL_LISTENER For example: Alter system set local_listener=”orclnew” scope=both; Where listener2 should be r...