Database Administration (MOSC)
MOSC Banner

How to create service with DBMS_SERVICE on sigle instance db to make services autostart

edited Dec 7, 2022 5:37PM in Database Administration (MOSC) 4 commentsAnswered

Hi!

We have created some services using package/procedure DBMS_SERVICE.CREATE and DBMS_SERVICE.START 

on a single instance node (Non-RAC, 19c. Linux x86_64 8.4, Single-Instance, Non-Pluggable, ASM)

but after reboot of server or database the created services need to be restarted manuallly again.

I did not find any info on how to set any "autostart" option.

We don't like to implement an AFTER STARTUP ON DATABASE trigger to restart the services.


Please, could you advice.


Regards

Norbert


P.S.

Because we use ASM my solution is currently by using srvctl command like the following:

srvctl add service -db MY1DB -service MY1SERVICE -policy AUTOMATIC

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