Problem solve Get help with specific problems with your technologies, process and projects.

Difference between static and dynamic registrations

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

What are the differences between static and dynamic registrations in Oracle?
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 last published in June 2007

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.