LsInventory: OPatch Exception while accessing O2O

Problem:

bash-4.2$ opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /appdata/data_appl/apps/tech_st/10.1.2
Oracle Home Inventory : /appdata/data_appl/apps/tech_st/10.1.2/inventory
Central Inventory     : /appdata/data_appl/inst/apps/BRLTEST_testburlaapp/admin/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /appdata/data_appl/apps/tech_st/10.1.2/oui
OUI shared library    : /appdata/data_appl/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location         : /appdata/data_appl/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/LsInventory__03-07-2013_10-27-38.log"

Result:

LsInventory: OPatch Exception while accessing O2O


OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
OPatch Exception:
  OUI found no such ORACLE_HOME set in the environment
  Can not get details for given Oracle Home
  An exception occurs
  null


There is no Interim Patch



OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.


Solution:


cd $ORACLE_HOME/appsutil/clone
perl ouicli.pl

Then OPatch succeeded.

Ref:
How To Create, Update or Rebuild The Central Inventory For Oracle Applications EBS R12 [ID 742477.1]

JVMDUMP013I Processed Dump Event "gpf", detail ""

PROBLEM:

When you run $ORACLE_HOME/OPatch/opatch lsinventory you get some error on AIX just like below:

List of Homes on this system:

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

This error says that you have central inventory.You have to create central inventory.
But first you have to export JAVA_COMPILER.If you create central inventory without export JAVA_COMPILER=NONE you get this error below:

JVMDUMP013I Processed Dump Event "gpf", detail "".


SOLUTION:

export JAVA_COMPILER=NONE
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="<ORACLE_HOME_PATH>" ORACLE_HOME_NAME="<ORACLE_HOME_NAME>"

note:<ORACLE_HOME_NAME> is label.It is not important,you can give a name which you want



Output:

oratest@test:/test_db/testdb/db/oui/bin>ORACLE_HOME="/test_db/testdb/db" ORACLE_HOME_NAME="DEMO_ORACLE_HOME"                                                         <
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 16384 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-02-11_10-26-41PM. Please wait ...oratest@test:/test_db/testdb/db/oui/bin>The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /test_db/testdb/db/inventory
'AttachHome' was successful.

Untar file to destination folder

tar -xvf /dbdata/data_db/n.tar /dbdata/data_db/n.txt


/dbdata/data_db/n.tar-------->source file

/dbdata/data_db/n.txt-------->destination file



note:n.tar exract as a n.txt

ORA-20100: Error: FND_FILE failure. Unable to create file, o0077259.tmp in the directory, /usr/tmp error.

Problem:

You have a lot of ebs clone system db tier in one db server,you may go this error.


Solution:

su - root

rm -rf /usr/tmp/*.tmp

PLS-00801 reduce invalid objects

Problem:

I applied patch 10338643,this patch was solved my problem,but it generate 5 invalid in apps schema.

Invalid objects:

OE_ORDER_GRP
OE_OE_FORM_LOT_SERIAL
OE_DEFAULT_LOT_SERIAL
OE_DEFAULT_LINE_PATTR
OE_OE_FORM_HEADER_PAYMENT

I compiled apps schema via adadmin,I compiled these packages via alter package  <package_name> compile;but these packages are
invalid.I am getting PLS-00801 on compiling this objects.I followed this document below:

Getting PLS-00801 on compiling various ONT packages [ID 1062560.1]
Then I create a SR,then my problem was resolved.

Solution:

as a database user

sqlplus / as sysdba

SQL>shutdown immediate;
SQL>startup nomount
SQL>alter system set "_disable_fast_validate"=TRUE SCOPE=pfile
SQL>create spfile from pfile
SQL>shutdown immediate;
SQL>startup upgrade;
SQL>@?/rdbms/admin/utlirp.sql
SQL>shutdown immediate
SQL>startup
SQL>@?/rdbms/admin/utlrp.sql

All objects will be invalid via utlirp.sql,then utlrp.sql will compile them.

Note:"?" means $ORACLE_HOME

sh: No space left on device perl adcfgclone.pl

Problem:While run perl adcfgclone.pl we may get this error below:

sh: No space left on device

bash-4.2$ perl adcfgclone.pl dbTier

                     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 :

sh: No space left on device


WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above,


Solution:Check /tmp size,delete some file in there or add size  /tmp

SOLARIS CRONTAB PROBLEM

SOLARIS crontab problem

PROBLEM:

bash-3.2$ crontab -e

0


SOLUTION:

export EDITOR=vi