hi there, I have three cdb environments that I am trying to set up with multiple pdbs each.
environment one works flawlessly. I remotely clone a non-cdb as a pdb and am able to clone that pdb.
environment two I've been able to remotely clone a pdb from environment one but am unable to clone that pdb.
environment three I am unable to remotely clone a pdb from environment one.
all OS/Oracle environments are copies of the same vm.
when attempting to remotely or locally clone a pdb in the problem environments I get messages like:
ORA-01537: cannot add file
'/u02/oradata/MYDATABASE/6F55366D27BA8D08E0537301640A0611/datafile/o1_mf_temp_flx8
3m8f_.dbf' - file already part of database
and
ORA-01119: error in creating database file '/u02/oradata/MYDATABASE/6F4B3732331A3679E0557106FFEDD42E/datafile/o1_mf_temp_flx8d8rt_.dbf'
ORA-27038: created file already exists
I've tried using the "tempfile reuse" clause when attempting to create the pdb but with the same results. I'm a little perplexed that these files do not exist in the file system beforehand or in v$tempfile.
can someone provide me with advice or reference to find out what I am doing wrong?
UPDATE: this is happening with all of my environments now... here is a sample run.
[oracle@mydatabase-db-qat-cdb MYDATABASE]$ pwd
/u02/oradata/MYDATABASE
[oracle@mydatabase-db-qat-cdb MYDATABASE]$ ls -hal
total 24K
drwxr-x---. 6 oracle oinstall 4.0K Jun 23 16:23 .
drwxrwxr-x. 3 oracle oinstall 4.0K May 11 16:08 ..
drwxr-x---. 3 oracle oinstall 4.0K Jun 23 15:04 6F5752FA9354B3EBE0537301640AE6A1
drwxr-x---. 2 oracle oinstall 4.0K May 11 16:37 controlfile
drwxr-x---. 2 oracle oinstall 4.0K May 11 16:37 datafile
drwxr-x---. 2 oracle oinstall 4.0K May 11 16:37 onlinelog
[oracle@mydatabase-db-qat-cdb MYDATABASE]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 23 16:39:38 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 mydatabase_PDB_QAT1 READ ONLY NO
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /u02/oradata
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 1000
SQL> set pagesize 1000
SQL> column name format a50
SQL> select con_id, name from v$datafile;
CON_ID NAME
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_sy
stem_fk3hpg70_.dbf
1 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_sy
saux_fk3hnpf2_.dbf
1 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_un
dotbs1_fk3hrjx5_.dbf
2 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_sy
stem_fk3htdns_.dbf
1 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_us
ers_fk3hrhns_.dbf
2 /u01/app/oracle/oradata/MYDATABASE/datafile/o1_mf_sy
saux_fk3htdkr_.dbf
3 /u01/app/oracle/oradata/MYDATABASE/6D9CCBC2E0C55CF6E
0537101640AD9F0/datafile/o1_mf_system_fk3jvlf3_.db
f
3 /u01/app/oracle/oradata/MYDATABASE/6D9CCBC2E0C55CF6E
0537101640AD9F0/datafile/o1_mf_sysaux_fk3jvlfj_.db
f
3 /u01/app/oracle/oradata/MYDATABASE/6D9CCBC2E0C55CF6E
0537101640AD9F0/datafile/o1_mf_users_fk3jwn4b_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_system_flxjz3sv_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_system_flxjz3tg_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_system_flxjz3tl_.dbf
ETC...
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_sysaux_flxjz3to_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_sysaux_flxjz3tq_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_users_flxjz3ty_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_suitt_sm_flxjz42f_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_suitt_sm_flxjz42h_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_suitt_la_flxjz42k_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_suitt_la_flxjz42m_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_eyor_tbs_flxjz42o_.dbf
4 /u02/oradata/MYDATABASE/6F5752FA9354B3EBE0537301640A
E6A1/datafile/o1_mf_ta_vvl_flxjz42q_.dbf
118 rows selected.
SQL> create pluggable database MYDATABASE_pdb_qat1_base from MYDATABASE_pdb_qat1;
create pluggable database MYDATABASE_pdb_qat1_base from MYDATABASE_pdb_qat1
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u02/oradata/MYDATABASE/6F58B6C10327CF03E0537301640ACEE0/datafile/o1_mf_temp_flxp
s78h_.dbf'
ORA-27038: created file already exists
Additional information: 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
4 MYDATABASE_PDB_QAT1 READ ONLY NO
5 MYDATABASE_PDB_QAT1_BASE MOUNTED
SQL> alter pluggable database MYDATABASE_PDB_QAT1_BASE open;
alter pluggable database MYDATABASE_PDB_QAT1_BASE open
*
ERROR at line 1:
ORA-65104: operation not allowed on an inactive pluggable database
Message was edited by: user521233
corrected capitalization