ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

My Environment where tested: OCI DBCS 19c



SQL> alter session set container=OCIBENCH;


Session altered.


SQL> drop pluggable database OCIBENCH;

drop pluggable database OCIBENCH

*

ERROR at line 1:

ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged



SQL> drop pluggable database OCIBENCH including datafiles;


Pluggable database dropped.


SQL> 


SQL> sho pdbs


    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 ORCL_PDB1   READ WRITE NO

SQL> 


Comments

Post a Comment

Popular posts from this blog

adop phase=prepare [ERROR] META:18:03:58.800: bad stylesheet: kustrigc (Tested on R12.2.5 by me)

Initializing.     Run Edition context  : /oradev/oracle/r12/uat/fs1/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch edition context: /oradev/oracle/r12/uat/fs2/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch file system free space: 222.29 GB Validating system setup.     Node registry is valid.     [ERROR]     META:18:03:58.800: bad stylesheet: kustrigc     Encountered the above errors when performing database validations.     Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail) $ Solution: 1. To find the current version of the adgrants.sql script on the instance, do the following:   a. Source the database environ...
Read more

After cloning - adapcctl.sh: exiting with status 204

After cloning on appsTier, following was error as on source SSO was enabled: Error: applprod@hostname:…1_hostname/admin/scripts$ sh adapcctl.sh start                                                                                            You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance ... adapcctl.sh: exiting with status 204 In the logfile: 19/07/09 20:35:17 Start process -------- /erp_ndr/app/inst/apps/SID_hostname/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing ht...
Read more

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more