Ask the Expert

Difference between static and dynamic registrations

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

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: