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

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

OAM 11.1.2.3 - Bad Oracle Access Manager Request Error After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717

After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717, when accessing the http resource then it was giving Bad Oracle Access Manager Like when accessing "http://hostname.domain:7779/index.html" we get following message in the logfile "diagnostics/logs/OHS/ohs1/oblog.log" 2018/10/26@15:29:46.68427       1890    1950    WEB     ERROR   0x0000151F      /ade/aime_ngamac_748106/ngamac/src/palantir/commonlib/src/apache2_req_info.cpp:294     ecid^005UIDZfNp87U8ups^h8iX0000SX00001w  rid^0   "WebGate Error Report"  Message^Unable to process the request due to unexpected error.  ReqReq^GET /public/index.html HTTP/1.1  ReqProto^HTTP/1.1       ReqHost^bdrvl-pd-oid01  ReqStatLine^    ReqStatus^200   ReqRawUri^/public/index.html    ReqUri^/public/index.html       ReqFilename^...
Read more