11 Şubat 2013 Pazartesi

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.

7 Şubat 2013 Perşembe

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

5 Şubat 2013 Salı

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

2 Şubat 2013 Cumartesi

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