Hi,
I'm trying to figure out how we could have our app-specific services restarted
with every reboot of 12c databases.
We created an AFTER STARTUP trigger at container level, that contains:
begin
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN services=all';
end;
to make sure our pluggable databases will restart along with their container
every time the latter is rebooted. But the "services=all" options seems to be
ignored, all services made with
exec DBMS_SERVICE.CREATE_SERVICE('APP_BIZ_POC','APP_BIZ_POC')
remain down, we must manually start them.
In fact even an
SQL> alter pluggable database all open services=all;
at sqlplus prompt does not the job, this "services=all" option seems to be
ignored... (the pluggable service gets up for sure, but not its APP_BIZ_POC
service, yet this is the suggested solution in Metalink note 2006021.1)
Any idea ?
Thanks.
Regards,
Seb