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".