Posts Tagged ‘ORACLE DB’

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported

September 2nd, 2018, posted in Oracle, Solaris
Share

[orastg@eboso bin]$ perl adcfgclone.pl dbconfig /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml

                      Copyright (c) 2002 Oracle Corporation

                        Redwood Shores, California, USA

                         Oracle Applications Rapid Clone

                                  Version 12.0.0

                       adcfgclone Version 120.31.12010000.8

 Enter the APPS password :

 Running Rapid Clone with command:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

Running:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

APPS Password :

 Beginning dbconfig Apply – Fri May 17 01:37:14 2013

 /clone/oracle/product/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/clone/oracle/product/11.2.0/oui -classpath /clone/oracle/product/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/java:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/share.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyDatabase -e /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml -stage /clone/oracle/product/11.2.0/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /clone/oracle/product/11.2.0/appsutil/log/CLONE_ebso/ApplyDatabase_05170137.log

  |      0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again…

 ERROR while running Apply…

 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl

  Please check logfile.

[orastg@ebso bin]$


Summary 
During the post cloning steps at the dbTier of an E-Business Suite R12.1.3 i get the error:

RC-20200 Fatal: Could Not Find Unzip. At This Time Only Native UnZip 5.X is Supported

I check my unzip version:
$ unzip -version 
$ which uzip 
And i found out that i have Unzip version 6 !!

But at the source system i do have the version UnZip 5.52

Workaround: 
Copy from the source system the unzip version 5.52 and put it under target system:
/usr/bin/unzip 
/system_base_directory/db/tech_st/11.2.0/bin/unzip 

MyOracle Support offers a solution with a patch:
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported [ID 1410514.1] 

Tip: 
After solving the issue with unzip and running again the dbTier post cloning steps you might get the error:

[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:
          

  [INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/install/PRODAR_ebsdbprd
      adcrdb.sh               INSTE8


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

The problem now is that the file:
/u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/template/adcrdb.sh is Deleted from the first failed clone process.

Workaround:
Copy again all the template directory from the source system and put it to the “target” system.
Run again $ perl adcfgclone.pl dbTier

Share

ORA-0131 Insufficient privileges

December 11th, 2016, posted in Oracle Queries
Share

ORA-0131: Insufficient privileges,ORA-0131,Insufficient privileges,ORA 0131,ORA Error, Insufficient, privileges,DEBUG CONNECT SESSION,system privilege,Debugging requires the DEBUG CONNECT,ORA Debugging,ORA Debugging,ORA Debugging requires,Oracle APPS DBA,ORACLE DBA,ORACLE DB,
Title :
Getting “ORA-01031: insufficient privileges” error when trying to Debug.

Description :
When trying to debug a procedure, package, etc., the following error messages are received:

ORA-01031: insufficient privileges

Cause :
The Oracle user or schema account does not have the required Oracle rights to debug an object.

Resolution :
Ensure the User or Schema has all the required Oracle privileges granted for debugging objects on that database.

1. connect as sysdba
2. exec the sql:
 grant debug connect session to XXXXXX;

or
grant DEBUG ANY PROCEDURE to XXXXXX;;

Share