Hi.
In Oracle 19c I have created a custom database instance service using below command:
EXECUTE dbms_service.create_service('app_service', 'app_service');
Then I successfully started it and I was able to connect to the database instance using this newly created service. However, after the database restarted I had to manually start this service again. I have made a workaround which you can see here:
CREATE OR REPLACE TRIGGER start_app_service
AFTER STARTUP ON DATABASE
BEGIN
dbms_service.start_service('app_service');
END;
But I am not happy with it cause I believe there is a better way to tackle this issue, something like SAVE STATE command related to PDBs which can open PDBs after resetting the database.
Could you please tell me are there any other methods to have a database instance service automatically started after resetting the database? I will be thankful for any help.