Creating a standby database using Enterprise Grid Control fails with Initialization Error
Posted by John Paul van Helvoort on March 10, 2009
While creating a standby database with a OMS 10.2.0.4 and agents 10.2.0.3 on the source and target database server , i ran into some strange behavior.
As it seems , when datafiles are larger then 4 gb and you use the HTTP transfer protocol , you might run into the following error :
“Initialization Error” with Error Log “File does not exist or not accessible.”
After some research i found that datafiles larger then 4 Gb transferred with the HTTP protocol with agent 10.2.0.3,
could cause this error and therefor need ;
Patch 5372553
Description EMDCLIENT API SUPPORTS ONLY JAVA INT FOR OUTPUT SIZE LIMIT
Product Intelligent Agent
After applying this patch on the Intelligent Agents using opatch, the database clone(creation) works perfectly using Enterprise Grid Control.
Note that you need to apply this patch on the source – and target agent for this clone to succeed.
Don Parret said
Automated Oracle Standby Database Tool:
For an easy to use graphical alternative to Data Guard,try the Standby Wizard for Oracle.
The Standby Wizard automates standby database creation, maintenance, and switchover functions needed for any Oracle disaster-recovery or continuity planning senario.
Free downloads are available at:
http://www.relationalwizards.com
The Standby Wizard has been serving Oracle customers since 2001.
Darrin Weissinger said
Awesome! Thanks for posting the patch info. You just saved me a lot of work.
Darrin