Visit Counter

Monday, August 14, 2017

Rapid Clone Failed While Running "Adcfgclone.pl dbTier": ORA-01194 and RC-00118

Refer: 375389.1


While cloning Oracle EBS 12.1.1...I retry below command after getting this error.

$ perl adcfgclone.pl dbTier

...
...
...
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 581506616 bytes
Fixed Size 452152 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes

Control file created.

alter database open resetlogs




Solution:


Please follow one of the following solutions (In a crash and burn or non business critical instance):

Solution 1
Startup mount;
SQL> recover database using backup controlfile until cancel;
-- type CANCEL

SQL> alter database open resetlogs; 
Retry the clone. If the SQL commands or the reattempt of the clone fails to recover the database, then you must follow solution 2. There are no other solutions for this issue.


Solution 2
1. Shutdown the source database normally.
2. Re-copy the database files from the source to target and retry the clone process.

No comments:

Post a Comment