DBMS_SERVICE

How to Resolve ORA-44303: service name exists

by Ed Chen
November 26, 2021October 19, 2022

ORA-44303 Tried to add a service to a database, but it failed with ORA-44303. SQL> exec dbms_service.create_service('ERPAPP1', 'ERPAPP1'); BEGIN dbms_service.create_service('ERPAPP1', 'ERPAPP1'); END; * ERROR at… Read More »

How to Resolve ORA-44773: Cannot perform requested service operation

by Ed Chen
November 10, 2021November 10, 2021
2 Comments

ORA-44773 Tried to start a service of a cloned PDB, but it failed with ORA-44773. SQL> exec dbms_service.start_service('ERPGEN', DBMS_SERVICE.ALL_INSTANCES); BEGIN dbms_service.start_service('ERPGEN', DBMS_SERVICE.ALL_INSTANCES); END; * ERROR… Read More »

How to Switch Service Name to Another PDB

by Ed Chen
November 3, 2021March 25, 2022

In this case, we have two PDBs in a container and a general service name needs to be be switched between them back and forth.… Read More »

How to Resolve ORA-44305: service is running

by Ed Chen
October 18, 2021March 30, 2022
2 Comments

ORA-44305 Tried to delete a non-default service from the database, but it failed with ORA-44305. SQL> exec dbms_service.delete_service('ERPAPP2'); BEGIN dbms_service.delete_service('ERPAPP2'); END; * ERROR at line… Read More »

How to Resolve ORA-44786: Service operation cannot be completed

by Ed Chen
October 13, 2021October 13, 2021

ORA-44786 There're several error patterns about ORA-44786 when we operate on a service in a pluggable database (PDB). Stop Service Start Service A. Stop Service… Read More »

How Srvctl Add Service

by Ed Chen
March 9, 2021December 30, 2022

Srvctl Add Service The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some other entries to service different kinds… Read More »

How DBMS_SERVICE.CREATE_SERVICE

by Ed Chen
March 8, 2021November 3, 2022

How to Use DBMS_SERVICE to Create a New Service? The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some… Read More »

How to Add Service to PDB

by Ed Chen
March 6, 2021January 24, 2023

By default, Container Database (CDB) provides only one service for every Pluggable Database (PDB) for connections, but we can create our own services for various… Read More »

How to Set Server-Side Transparent Application Failover (TAF)

by Ed Chen
February 5, 2020January 24, 2023
2 Comments

I have talked about how to set client-side Transparent Application Failover (TAF) pretty much. This time, we turn to server-side TAF. There're 2 ways to… Read More »