Oracle Database Discussions

Hello community,

I have tried now for several times to make a clone of my existing database with DBCA and "-silent" option. I could improve my progress in cloning but now I always stick in the following error:

But first, what I have done so far:

1. Created a clone template of my Database with command:

dbca -silent -createCloneTemplate -sourceSID DBORIGIN -templateName myTest.dbc -datafileJarLocation /tmp/oratest

2. Create the clone-database by using the template from (1.) with command:

dbca -silent -createDatabase -templateName myTest.dbc -cloneTemplate -gdbname DBCLONE -sid DBCLONE -datafileJarLocation /tmp/oratest -datafileDestination /oradata -responseFile NO_VALUE -characterset AL32UTF8

Then the progress of execution is shown, it ends with a link to a log file. In this log file I can see the following contents:

==============================
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 26%
DBCA_PROGRESS : 33%
DBCA_PROGRESS : 37%
Creating and starting Oracle instance
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/oradata/DBCLONE/<OMF_CONTROL_0>'
ORA-27040: file create error, unable to create file

DBCA_PROGRESS : 38%
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4168
ORA-06512: at line 1

ORA-01507: database not mounted

DBCA_PROGRESS : 40%
DBCA_PROGRESS : 41%
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/oradata/DBCLONE/<OMF_CONTROL_0>'
ORA-27040: file create error, unable to create file

ORA-01507: database not mounted

DBCA_PROGRESS : 46%
DBCA_PROGRESS : 47%
ORA-01219: database not open: queries allowed on fixed tables/views only

ORA-01507: database not mounted

DBCA_PROGRESS : 52%
ORA-01219: database not open: queries allowed on fixed tables/views only

ORA-01507: database not mounted

DBCA_PROGRESS : 53%
DBCA_PROGRESS : 58%
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_DATAPUMP_UTL.REPLACE_DEFAULT_DIR' must be declared
....
....
and so on
....
=====================================================

I have no idea where the "<OMF_CONTROL_0>" comes from. It is nowhere included in my myTest.dbc-file. In my eyes, it looks like that DBCA tries to create the file exactly with this filename - and this fails on Solaris, sure...

Here is, what I have in my template file "myTest.dbc" regarding the control files:

=======================
<ControlfileAttributes id="Controlfile">
<maxDatafiles>100</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="o1_mf_2k1zmdmp_.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<image name="o1_mf_2k1zmdvo_.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</ControlfileAttributes>
====================================

To be honest, it is the first time that i try to use the DBCA with all these "special" options, especially the silent mode.

Does anyone have an idea what is going wrong in my case described here? What do I or could I change to come to a success clone?

Maybe, you can tell me where I can find some kind of "how to" for creating a clone using the silent-option.

Thanks a lot in advance for helping a newbie! ;-)
Regards
FireFighter