High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

How to force to start one service on port 1521 when I have already configured the local_listener par

Hello everybody,

I have a DataGuard environment configured with Broker in Oracle Database 12c (12.1.0.2.0)

I have configured one different listener on port 1525 to be used by Broker and transport of redos.

This enviroment works very well.

Now, I need to configure two service names to switchover users transparently.

These service names can not be configured as static service on listener.ora, they need to be dynamics, because I have already configured two triggers (startup and db role changes) and those triggers will startup and will stop those service names dynamically, as according with role of database (primary and standby).

If database role is primary, then start the service name "prim_db", and stop the service name "standby_db" ; if database role is physical standby, then start the service name "standby_db" and stop the service name "prim_db".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center