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 DBMS_SERVICE.CREATE_SERVICE
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 DBMS_SERVICE.CREATE_SERVICE
How to Add Service 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 Service to PDB