How to Switch Service Name to Another PDB
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 Switch Service Name to Another PDB
DELETE_SERVICE
How to Resolve ORA-44305: service is running
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-44305: service is running
How to Resolve ORA-44786: Service operation cannot be completed
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 ORA-44786: Service operation cannot be completed
How to Add Services to PDB
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 Add Services to PDB
How to Add Service to Database
There're two ways to add a service to a database (non-CDB): DBMS_SERVICE Create Service It's an administration package for managing services of a database. SRVCTL… Read More »How to Add Service to Database