Clone Failing On Create Controlfile

(Doc ID 430910.1)

Last updated on MAY 09, 2016

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 11-April-2013***


Symptoms

The following error occurs when running adcfgclone.pl dbTier:

 

From the ApplyDBTier_<timestamp>.log file:
RC-40201: Unable to connect to Database <db sid>.
StackTrace:
java.lang.Exception: Cannot connect to database using DBUtil
at oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3398)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:524)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)




Creating the control file for <instance name> database
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Apr 17 11:52:01 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
ERROR:
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
SP2-0640: Not connected
SP2-0640: Not connected


Also in the log file is the following line showing that ownership is being set to 'root' even though that is not the correct database owner.

 

  setting ownership: root:root

The context file for the new target db tier shows:

<dbuser oa_var="s_dbuser" osd="unix">root</dbuser>
<dbgroup oa_var="s_dbgroup" osd="unix">root</dbgroup>

The issue can be reproduced by running adcfgclone.pl dbTier.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms