Service Name

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 to Resolve PRCR-1025 : Resource is still running

by Ed Chen
March 11, 2021October 13, 2022

PRCR-1025 Tried to remove a database service from the cluster, but it failed with PRCR-1025. [oracle@primary01 ~]$ srvctl remove service -d orclcdb -s crm PRCR-1025… Read More »

How to Add Service to Database

by Ed Chen
March 10, 2021December 24, 2022

There're several ways that can add a service to the normal, typical database (non-CDB) as followings. Instance Level: Alter System set Service_Names The traditional approach… 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 »

Alter System set Service_Names

by Ed Chen
March 7, 2021December 24, 2022

Add a Service to SERVICE_NAMES Adding a service to the server parameter SERVICE_NAMES is only working for normal, typical databases (non-CDB) or in root containers.… Read More »

JavaScript is not enabled. Please enable it and reload the page.