What are the differences between static and dynamic registrations in Oracle?

    Requires Free Membership to View

    Login

On your database server, you have a program called the Oracle Listener. The job of the Listener is to listen for database connection requests (normally from outside the database server) and pass those requests on to the instance. Before the Listener can pass a request to an instance, the instance must be registered with the Listener. You can explicitly state the instance information (called static registration) by updating the listener.ora configuration file. Or, the instance's PMON process can contact the Listener and pass on the information automatically. When PMON performs this activity, it is called dynamic registration. This Oracle doc shows the details on both registration methods.

This was first published in June 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top