Common Cloning Issues

Issue : 1

-----------

After upgradation from DB 10.2.0.3 to 11.2.0.4 in OEL 4.6 of Release 12.2.5 application, did the autoconfig and preclone process successfully in both db and apps tier.

While cloning to the target instance getting error from DbTier.

$perl adcfgclone.pl dbTier

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution.  Errors are grouped by directory and phase.

The report format is:

[filename]  [phase]  [return code where appropriate]

[APPLY PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /u01/oracle/AJI/db/tech_st/11.2.0/perl/bin/perl -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/perl /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/clone

ouicli.pl   INSTE8_APPLY 255

AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.

/u01/oracle/AJI/db/tech_st/11.2.0/appsutil/driver/regclone.drv

Solution :

--------------

I have resolved this issue by copying java folder to the appsutil folder. I have already installed the latest Java 6.0. The issue is caused by [DB oracle home]/appsutil not containing the jre directory

$cp -R /usr/java/jdk1.6.0_16/  $ORACLE_HOME/appsutil/jre

Again run the cloning process,

perl adcfgclone.pl dbTier

ApplyDatabase Completed Successfully.

Issue : 2

-----------

 perl adcfgclone.pl dbTier fails with below error

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /tlcc/db/tech_st/11.2.0.4/perl/bin/perl -I /tlcc/db/tech_st/11.2.0.4/perl/lib/5.10.0 -I /tlcc/db/tech_st/11.2.0.4/perl/lib/site_perl/5.10.0 -I /tlcc/db/tech_st/11.2.0.4/appsutil/perl /tlcc/db/tech_st/11.2.0.4/appsutil/clone
      ouicli.pl               INSTE8_APPLY       1



AutoConfig is exiting with status 1

Cause:

The script was trying to register the oracle home in inventory but its failing to update it.

Solution:


We need to ensure there are no files currently located in the Inventory directory, If there are any files in this directory then we should delete these files.

Issue : 3

--------------

perl adcfgclone.pl dbTier fails with RC-00110

Error:

APPS Password : Log file located at /d01/PREPROD/oradb/11.2.0.3/appsutil/log/PREPROD_rgovis/ApplyDBTechStack_12201105.log
  \      0% completed       RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

ERROR while running Apply...
Sat Dec 20 11:06:07 2014

 ERROR: Failed to execute /d01/PREPROD/oradb/11.2.0.3/appsutil/clone/bin/adclone.pl

 Please check logfile.


 Detail log :/d01/PREPROD/oradb/11.2.0.3/appsutil/log/PREPROD_rgovis/ApplyDBTechStack_12201105.log
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /d01/PREPROD/oradb/11.2.0.3/perl/bin/perl -I /d01/PREPROD/oradb/11.2.0.3/perl/lib/5.8.3 -I /d01/PREPROD/oradb/11.2.0.3/perl/lib/site_perl/5.8.3 -I /d01/PREPROD/oradb/11.2.0.3/appsutil/perl /d01/PREPROD/oradb/11.2.0.3/appsutil/clone
      ouicli.pl               INSTE8_APPLY       255


AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.
/d01/PREPROD/oradb/11.2.0.3/appsutil/driver/regclone.drv

Solution:

Set the perl to point to the <ORACLE_HOME>/perl/bin
Eg:
 export PATH=<ORACLE_HOME>/perl/bin:$PATH  

Issue : 4

-----------

 

ORACLE instance shut down.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1071333376 bytes

Fixed Size                  1369420 bytes

Variable Size             436210356 bytes

Database Buffers          620756992 bytes

Redo Buffers               12996608 bytes

Control file created.

Database altered.

Tablespace altered.

Tablespace altered.

Database altered.

PL/SQL procedure successfully completed.

File created.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

exit_code=0

Checking for errors ...

.end std out.

.end err out.

---------------------------------------------------------------

                   ADX Database Utility

---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->

    APPS_JDBC_URL='null'

    Trying to get connection using SID based connect descriptor

getConnection() -->

    sDbHost    : lcctest9

    sDbDomain  : lakshmicardclothing.com

    sDbPort    : 1523

    sDbSid     : dlcc

    sDbUser    : apps

    Trying to connect using SID...

getConnectionUsingSID() -->

    JDBC URL: jdbc:oracle:thin:@lcctest9.lakshmicardclothing.com:1523:dlcc

    Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

    Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lcctest9.lakshmicardclothing.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=dlcc)))

    Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

    Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lcctest9.lakshmicardclothing.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=dlcc.lakshmicardclothing.com)))

    Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database

Raised by oracle.apps.ad.clone.ApplyDatabase

Solution:

-------------

Workaround Done :-

1. Modify the Contextfile 'CTXORIG.xml', whcih is created by the pre-cloning script, which is found under the Database $ORACLE_HOME/appsutil/clone/context/db directory :

ORIGINAL :
<DB_LISTENER oa_var="s_db_listener" default=""><Name of the SOURCE DB listener></DB_LISTENER>

ACTION Taken:

UPDATE the file with the SID name of the TARGET Instance, e.g. TEST :

<DB_LISTENER oa_var="s_db_listener" default=""><Name of the TARGET DB listener></DB_LISTENER>

execute 'perl adcfgclone.pl dbTier <physical Path to the DB Tier Contextfile>

Or

You can restart the adcfgclone after making the required changes.

Issue : 5

-----------

Executing service control script:
/dlcc/apps/inst/apps/dlcc_lcctest9/admin/scripts/adformsctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
****************************************************

You are running adformsctl.sh  version 120.12.12000000.6

Starting OPMN managed FORMS OC4J instance  ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
ERROR processing <arg> txkrgf : Argument value cannot be an empty string
Error while executing the perl script txkChkFormsDeployment.pl
/dlcc/apps/inst/apps/dlcc_lcctest9/logs/appl/admin/log/adformsctl.txt


adformsctl.sh: exiting with status 1

Tried adstpall and below is the status

Executing service control script:
/dlcc/apps/inst/apps/dlcc_lcctest9/admin/scripts/adformsctl.sh stop
script returned:
****************************************************

You are running adformsctl.sh  version 120.12.12000000.6

Stopping OPMN managed FORMS OC4J instance  ...

adformsctl.sh: exiting with status 150

-------------------------------------------------------------------------------------------

Workaround
-------------------
Simply again tried adstrtal.sh and this time all the services are started properly and
adstrtal.sh exited with status 0.