Database Consultant (Passionate about Database & Cloud Technologies)

Database Architect,Core DBA ,APPSDBA,Mysql DBA,MongoDB,PostgreSQL,Installations,Upgrades on all Flavors of UNIX (LINUX,SOLARIS,HP(AIX)). Oracle E-Business Suite R12 (Upgrades,Patching,Cloning) AWS upgrades and implementation expert. OCI (Oracle Cloud Infrastructure) Architect, Exadata (Oracle Database Exadata Cloud at Customer(Exacc)),Superclusters ,Autonomous Databases, AWS RDS Customs , Sql Tuning Expert. ***Never Stop sharing,Learning and Growing***

Tuesday, September 27, 2016

Clone with more than 200 datafiles

When you have a E-Business Suite database with more than 200 datafiles and
want to create a new CLONE you may get some errors at the recreation of control file at the post cloning steps.

The workaround is to go to the directory $ORACLE_HOME/appsutil/clone/context/db of the database
and change at file CTXORIG.xmlthe parameter 500 to someting more, for example 500.