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
6 Şubat 2013 Çarşamba
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
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
Kaydol:
Kayıtlar (Atom)