ORA-44787: Service cannot be switched into

Hot Fix ORA-44787: Service cannot be switched into



SQL> alter session set container=GIMR_DSCREP_10;
ERROR:
ORA-44787: Service cannot be switched into.




Cause: The service did not exist in the new pluggable database or the service was not started in the pluggable database.

Action: Use a valid service name for the pluggable database or start the service in the pluggable database first.

The Easiest way to resolve this issue is,  Restart the PDB.

Note:- Please be Aware of the fact that restarting the PDB will lead to downtime of the PDB

SQL> alter pluggable database GIMR_DSCREP_10 close immediate;

Pluggable database altered.

SQL> alter pluggable database GIMR_DSCREP_10 open;
Pluggable database altered.

SQL> alter session set container=GIMR_DSCREP_10;
Session altered.

No comments:

Post a Comment