dbms_service.start_service not available at 19.9?
Hello everybody,
at a Oracle Enterprise Edition Database Cluster first installed with 19.8 configured as Active - Passive DataGuard Cluster I've created a failover service together with a trigger so that I can switchover the active level to the other database without loosing the connection.
After an upgrade to latest Patch Bundle to 19.9 I'm not able to start the service anymore:
[oracle@testserver ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 2 13:56:03 2020
Version 19.9.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
SQL> exec dbms_service.start_service ('failover_service');
BEGIN dbms_service.start_service ('failover_service'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SERVICE.START_SERVICE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
0