Database Networking (MOSC)

MOSC Banner

Listener service cannot be started in dynamic manner

edited Oct 28, 2013 7:15AM in Database Networking (MOSC) 9 commentsAnswered
Hi.

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

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