CREATE_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-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 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 »