This content has been marked as final. Show 5 replies
Database Register in two way :
1.) Static Instance Registration
2.) Dynamic Instance Registration
** Static Instance Registration:
add the entries in $ORACLE_HOME\NETWORK\ADMIN\listener.ora file or by using the GUI
When you check Listener status --> unknown because no mechanism to guarantee that the specified status even exists.
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521)) )
**Dynamic Instance Registration
or service registration , registration is performed by the PMON process an instance background process of each database and doesn't need any configuration in the listener.ora
My intention is to know , what are the pros and cons of each registration type.
Do you face any issues with one method , such kind of issues will not be faced in other method. things like that?
scenarios like dynamic registration having advantages over static registartion and vice versa?
Some facilities (such as restart with the Data Guard Broker) will not work unless you defne an appropriate staticly registered service. Other facilities (such service failover) will not work unless you use a dynamically registered service.
Decide what you want to implement, and configure registration accordingly. There are no "pros and cons".