Difference between static and dynamic listener reg

admin

Can you explain
1) differences between static and dynamic listener registration?
2) What are the advantages and disadvantages of those two methods?
3) When should we use dynamic and when should we static?
4) What happens if we use both methods?

and we said...
1) the relevant one is that - if you want to remotely startup the database, you need to have a statically registered connect string, otherwise - since the database isn't up - it wouldn't be registered.

2) use dynamic registration for all application connects - all of them.  Use static only if and when you need to remotely start the database over the network.

3) see #2

4) nothing, you have more services to connect to.  Dynamic registration saves a lot of effort as things change over time, it also makes it easier to change what things are provided by what databases.