Listener service cannot be started in dynamic manner
This database runs in Data Guard configuration. I have created a trigger to start service (DBNAME_VIP) only on primary database. It works well on ServerA, but I cannot start this service on server B for this database. Do you have any idea why although service is reported in the database it doesn't run on the listener?
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string DBNAME_VIP
SQL> select NAME,NETWORK_NAME from V$ACTIVE_SERVICES where NAME not in ('SYS$BACKGROUND','SYS$USERS');
NAME
----------------------------------------------------------------
NETWORK_NAME
--------------------------------------------------------------------------------
DBNAME_VIP
DBNAME_VIP
DBNAMEXDB