RE: Service registration after listener restart

From: D'Hooge Freek <>
Date: Thu, 27 Jan 2011 21:03:11 +0100
Message-ID: <>


Since you are already on 11.2, I would suggest that you install grid infrastructure for a standalone server (aka oracle restart). This will allow you to use srvctl to register the database in the GI and to specify services in the GI for that database. Roles can then be attached to these services so they will for example only be started when the database has the primary role.


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

From: [] On Behalf Of Michael Schmitt [] Sent: 27 January 2011 19:54
Subject: Service registration after listener restart

Hi All,

We have setup Dataguard with a physical standby running 11.2. We created a service that we want to run on the primary for the users to connect to. We have a system trigger that will register the service with the listener for the primary after the database opens. I am registering the service with dbms_service.start_service('<SERVICE>','<INSTANCE>')

This seems to work fine, but if the listener is ever shutdown and restarted, the service will no longer be configured and we need to execute dbms_service again.

Is there a way where I can get that service to run on the primary through a listener restart? I was just going to write a script to monitor it, but was wondering if there was a different way. I can't configure it in the listener.ora since I do not want it to run if the database ever becomes the standby.


Received on Thu Jan 27 2011 - 14:03:11 CST

Original text of this message