Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

After you applied a few OE patches,you have invalid objects like OE%.After you run utlrp.sql,these object aren't gone.When you want one of these objects manually you get PLS-00801 error.

But these invalid objects can effect this module.

Problem:

Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

We applied patch 10338643,this patch solved 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

Error Codes
---------------------------------------------------
PLS-00801

Solution:

1) start database in UPGRADE mode
(using STARTUP UPGRADE or ALTER DATABASE OPEN UPGRADE)

2) Run script $ORACLE_HOME/rdbms/admin/utlirp.sql
You must be connected AS SYSDBA to run this script.

3) Shut down the database and restart in normal mode

4) Run script $ORACLE_HOME/rdbms/admin/utlrp.sql
You must be connected AS SYSDBA to run this script.
There should be no other DDL on the database while running the script.


Note:It is very important and took 4 hours on my database which have 315000 objects

sh: adchkutl.sh: command not found

Problem:

sh: adchkutl.sh: command not found
i got this error while cloning
I ran
perl adcfgclone.pl dbTier
I got this error

Solution:


Add the directory with the PERL executable to the path (added . to the path, so that #2 will not occur).
Instead of:
perl adcfgclone.pl dbTier

Use:

perl ./adcfgclone.pl dbTier


Note:./filename - You are referring to filename in current directory

Done relinking module XDPCTRLS in product xdp

Problem:

When applying patch

adrelink is exiting with status 1

Done relinking module XDPCTRLS in product xdp
Done with link of product 'xdp' on Fri Oct 25 22:42:07 EEST 2013


Solution:

Relink

adadmin----------->2------------->1

relink xdp manually

ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt

PROBLEM:

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***


SOLUTION:

Run this query,you will see the locked table.


SQL> select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null
and owner not in ('SYS');

OWNER TABLE_NAME STATTYPE_LOCKED
-----   ----------       ---------------
SYSTEM DEF$_AQCALL ALL
SYSTEM DEF$_AQERROR ALL
ODM DMS_QUEUE_TABLE ALL
SYSTEM TBLMIG_MSG_QTAB ALL
APPLSYS FND_SOA_JMS_IN ALL
APPLSYS FND_SOA_JMS_OUT ALL
APPLSYS FND_CP_GSM_IPC_AQTBL ALL

Then run dbms_stats.unlock_schema_stats api to unlock this table.


SQL > exec dbms_stats.unlock_schema_stats('APPLSYS');

Pray & Tray :)

Error connecting to Database Concurrent error(EBS)

Problem:

When we look the output of this request,see the below:

Error connecting to database necoklon

Solution:

If you try to login as sysdba in sqlplus(sqlplus / as sysdba) you get max processor error,so you can’t login

Max process,you have to kill some LOCAL=NOJ

mscmatlab.sh INSTALL_SETUP

Problem:

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /appdata/cloneap2/data
_appl/inst/apps/necoklon_testnecoapp/admin/log/ApplyAppsTier_09262304.log for de
tails.
ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with  errors .



 mscmatlab.sh            INSTALL_SETUP      127

Solution:

add unzip PATH in your PATH

like this:

bash-4.2$ which unzip
/appdata/data_appl/apps/tech_st/10.1.2/bin/unzip

RC-50004: Fatal: Error occurred in ApplyDatabase

Problem:

When you running adcfgclone.pl you may get this error.

CREATE CONTROLFILE REUSE SET DATABASE "necoklon"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/dbdata/clonedb2/archive/a_txn_ind08.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


    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


APPS Password : Log file located at /dbdata/clonedb2/db/appsutil/log/necoklon_tes                                                                                        tburladb/ApplyDBTier_09250234.log
  \     50% completed       RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

ERROR while running Apply...
Wed Sep 25 02:37:33 2013

 ERROR: Failed to execute /dbdata/clonedb2/db/appsutil/clone/bin/adclone.pl

 Please check logfile.

Solution:

Check your hosts.You have double IP

Please take a "snapshot" of this APPL-TOP using "AD Administration" first

Problem:

When running adpatch with "prereq" flag, we might get an error message like:
Analyzing prerequisite patch information...
AutoPatch error: This patch has some prerequisites specified, but a "snapshot" of this APPL-TOP's file-system has never been taken, thereby rendering it impossible to check for the prerequisites.
Please take a "snapshot" of this APPL-TOP using "AD Administration" first.

This error message will show up if a snapshot on current APPL_TOP doesn't exists.


Solution:

To create such snapshot on APPL_TOP:

1) run adadmin
2) Select "Maintain Applications Files menu"
3) Select "Update current view snapshot"
4) Rerun adpatch

File server could not verify its initialization parameters

Problem:

file-server-could-not-verify-its-initialization-parameters


Solution:


1. Apply Patch 4244610.

2. View request and output.


Temporary workaround:

1. Modify the 8.0.6 listener.ora file and remove the spaces in between them for the
APPLFSTT parameter.

Example:

Change

APPLFSTT=WFTST_806_BALANCE; WFTST; WFTST_FO; WFTST_BALANCE

to

APPLFSTT=WFTST_806_BALANCE;WFTST;WFTST_FO;WFTST_BALANCE



2. Restart the apps listener.
lsnrctl stop apps_listener
lsnrctl start apps_listener

Note: Make a copy of the listener.ora file before editing.  If you don't apply the patch this issue won't solved permanenly.

Comment Out addisctl.sh R11

comment out addisctl.sh on 11i
-----------------------------

Set the AutoConfig variable s_discostatus to disabled. AutoConfig will still create the addisctl.sh, but adstrtal.sh won't run it.

1)vi $CONTEXT_FILE

2)set s_discostatus variable to disable

3)Shutdown appstier(run adstpall.sh)

4)run autonconfig(run adautocfg.sh)

5)Start appstier/run adstrtall.sh)

While appstier restarting

'addisctl.sh' will not running.

Ref:

How To Stop Autoconfig Creating Addisctl.Sh After Discoverer Upgrade (Doc ID 398835.1)

After upgrading Discoverer from version 4.1.48 to 10.1.2 per Metalink note 313418.1

Error creating new OC4J instance: create oc4j instance fails:

PROBLEM:

While running $FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws for Configuring Integrated SOA Gateway

I got an error:

Error creating new OC4J instance: create oc4j instance fails:
Invalid protocol or port range. invalid jvm options:
-Xss512k -Djava.awt.headless=true
-Xjit:exclude={orac

SOLUTION:

1) Backup the below files:

$IAS_ORACLE_HOME/opmn/conf/opmn.xml
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml


2) Remove the -Xss & -Xjit entries from both opmn files mentioned below:

$IAS_ORACLE_HOME/opmn/conf/opmn.xml
$ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml


3) Execute the following command to deploy the changes:

$FND_TOP/bin/txkrun.pl -script=DeployForms-c4ws


Ref:

Configuring OC4J Instance Fails: Invalid Protocol or Port Range. Invalid JVM Options (Doc ID 1386470.1)

Not:
It is AIX's bug

My error log is below:



##############################################################################################################################################################

Stopping all OPMN processes.
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...
OPMN stopped.
Removing OC4J instance if it exists: forms-c4ws
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/bin/removeinstance -instanceName forms-c4ws
Removing OC4J instance "forms-c4ws"...
Jul 25, 2013 11:47:08 AM oracle.security.jazn.JAZNConfig getJAZNProperties
SEVERE: JAAS: Configuration file "/data_appl/test_appl_05072013/apps/tech_st/10.1.3/j2ee/forms-c4ws/config/jazn.xml" does not exist. Check your configuration settings.
The OC4J instance "forms-c4ws" does not exist.
OC4J instance "forms-c4ws" does not exist.
Creating OC4J instance: forms-c4ws
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/bin/createinstance -instanceName forms-c4ws
Creating OC4J instance "forms-c4ws"...
Set OC4J administrator password for "forms-c4ws" (password text will not be displayed as it is entered):
Error creating new OC4J instance: create oc4j instance fails: Invalid protocol or port range. invalid jvm options: -Xss512k -Djava.awt.headless=true -Xjit:exclude={orac
le/sysman/emSDK/eml/util/iAS/IASLogConfig.getViewLogsURL(Ljavax/servlet/ServletContext;Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)L
java/lang/String;},exclude={oracle/security/jazn/util/OHSH.update([B)V},exclude={com/phaos/ASN1/ASN1Sequence.<init>(Ljava/io/InputStream;)V},exclude={com/phaos/crypto/D
ES.l([B[IZ)V} -Djava.security.policy=$ORACLE_HOME/j2ee/forms-c4ws/config/java2.policy -Dhttp.webdir.enable=false -Xms512M -Xmx1024M
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl start
opmnctl: opmn started.
Execute SYSTEM command : /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl startproc  instancename=forms-c4ws

Errors encountered running /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl

*******FATAL ERROR*******
PROGRAM : /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDeployForms-c4ws.pl(/data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/bin
/txkrun.pl)
TIME    : Thu Jul 25 11:47:11 2013
FUNCTION: TXK::Process::run [ Level 3 ]
MESSAGES:
Command error: <rc> = 38400, <command> = /data_appl/test_appl_05072013/apps/tech_st/10.1.3/opmn/bin/opmnctl startproc  instancename=forms-c4ws


STACK TRACE
        TXK::Error::abort('TXK::Error','HASH(0x20119984)') called at /data_appl/test_appl_05072013/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 299
        TXK::Common::doError('TXK::Process=HASH(0x213aacd0)','Command error: <rc> = 38400, <command> = /data_appl/test_appl...','undef') called at /data_appl/test_appl_
05072013/apps/apps_st/appl/au/12.0.0/perl/TXK/Common.pm line 314
        TXK::Common::setError('TXK::Process=HASH(0x213aacd0)','Command error: <rc> = 38400, <command> = /data_appl/test_appl...') called at /data_appl/test_appl_0507201
3/apps/apps_st/appl/au/12.0.0/perl/TXK/Process.pm line 449
        TXK::Process::run('TXK::Process=HASH(0x213aacd0)','HASH(0x213aaa00)') called at /data_appl/test_appl_05072013/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkDepl
oyForms-c4ws.pl line 1008

##################################################################################################################################################################

Shell Script to Send Mail via Telnet

      Sometimes you need to test send mail via telnet,but it's bored after 5-6 times.So you can a script.This script send mail via telnet.This script for solaris.If you use another operating system,you have to change .profile line;otherwise you can use direct.

Script takes two parameter.

MAIL=first parameter(mail adress)

STRING=second parameter(message body)

example;

ksh send_mail.ksh necati@natica.com.tr "Hello"

###############################send_mail.ksh########################################
#!/bin/ksh
. /export/home/oracle/.profile
MAIL=$1
STRING=$2

{
echo "helo"
sleep 1
echo "mail from:sender@doganay.com"
sleep 1
echo "rcpt to:$MAIL"
sleep 10
echo "data"
sleep 1
echo "subject:Mail Test"
sleep 1
echo "from: receiver@doganay.com"
sleep 1
echo "to: $MAIL"
sleep 2
echo data
sleep 2
echo subject:  Mail Test
echo
echo
echo "$STRING"
sleep 5
echo .
sleep 5
echo "quit"
} | telnet 10.10.67.102 25
#################################################################################
10.10.67.102=SMTP server ip
25=SMTP server port

OPMN Starting Process Time Out

Problem:

Time out while waiting for a managed process to start


Solution:

Make timeout change in $IAS_ORACLE_HOME/opmn/conf/opmn.xml file

<start timeout="1200"/>

Reload opmn services

$IAS_ORACLE_HOME/opmn/bin/opmnctl reload

OGG-00717-Found unsupported in-memory undo record in sequence ... Minimum supplemental log

Problem:

ERROR   OGG-00717  Found unsupported in-memory undo record in sequence 3, at RBA 1089040, with SCN 0.1030748 (1030748) ... Minimum supplemental log
ging must be enabled to prevent data loss.

I got an error while starting extract ext1;it abended.Viewed report then I saw;


Solution:

1. Make sure supplemental logging is enabled properly


SQL>SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
---------
YES

If it is not enabled, use the following commands to enable it.


SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL>ALTER SYSTEM SWITCH LOGFILE;

2. Alter the extract to a position when the supplemental logging has been enabled.


GGSCI>alter extract, ext1 begin now


3)Then start extract ext1.

Reference:OGG Error "OGG-00717: Found Unsupported In-Memory Undo Record in ..." When Starting, Extract Abends [ID 1362136.1]

RMAN-06043 TAG option not supported for archive log copies

Problem:

Error » RMAN-06043
Detailed information about the Oracle error RMAN-06043:
DESCRIPTION
TAG option not supported for archive log copies


Solution:

Remove the TAG operand and re-enter the command





Reference : Metalink Note 576587.1

Error In Writing to File $ORACLE_HOME/jdk/bin/libiverel23.so

Problem:

Error in writing to file
'/data02/data_appl/apps/tech_st/10.1.3/jdk/bin/libiverel23.so'.
 /data02/data_appl/apps/tech_st/10.1.3/jdk/bin/libiverel23.so(Cannot open or remove a file containing a running program.)

Solution:

While upgrading oracle ebs application server upgrade(from 10.1.3.0 to 10.1.3.5.0) I got this error above.My file operating system is IBM AIX

I checked these are below:

1)Any running process?

ps -ef | grep $ORACLE_HOME

2)run /usr/sbin/slibclean as a root


3)All of two are normal.There is no process and I run slibclean.But problem isn't resolve

Finally I tried this;



mv $ORACLE_HOME/lib32/libiverel23.so $ORACLE_HOME/lib32/libnjssl10.so.ba

mv $ORACLE_HOME/lib32/libnjssl10.so.ba $ORACLE_HOME/lib32/libiverel23.so

And installation finished successfully:))


Note:This problem is AIX's bug.

FRM-92050:Failed to connect to the Server

SOLUTİON:

You have to open port number 9010 on application server

ORA-19804: cannot reclaim string bytes disk space from string limit

Problem:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit

Solution:

Increase your db_recovery_file_dest_size parameter.

SQL>alter system set db_recovery_file_dest_size=<size> scope=BOTH

'Both' means,parameter will change memory an spfile.This parameter dynamic parameter.So you can test backup now :)))

Happy Friday:))

RMAN-06214: Datafile Copy

Problem:

RMAN-06214: Datafile Copy   /u01/backup/online_backup/data_D-NECODB_I-439097153_TS-APPS_TS_SUMMARY_FNO-396_6fntn4p3


Solution:

RMAN> crosscheck copy;
RMAN> delete expired copy;

Sending An Attachment Via Unix

mutt -s "Test Mail" -a /home/applprod/doganay.zip doganayn@yahoo.com < /home/applprod/n.txt




Note:/home/applprod/n.txt is dummy txt.It can use for not opening the MUTT emulator

There Are No Active Responsibilities Available For This User

Problem:

While you are configuring DMZ Server on EBS you can some harmful changing
like 'Responsibility Trust Level’ profile
If  'Responsibility Trust Level’ status changed to 'external' from 'normal'
you may get this error below:

There are no active responsibilities available for this user


Solution:

1)

Run this procedure below with apps user:
--------------------------------------------------------------------
DECLARE
stat boolean;
BEGIN
stat := FND_PROFILE.SAVE('APPL_SERVER_TRUST_LEVEL', '2', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
--------------------------------------------------------------------

2)Then shutdown application(adstpall.sh)

3)Then run autoconfig(autocfg.sh)

4)Finally startup your application(adstrtall.sh)

Login ebs and see your success:)


Pray and Tray:))

ORA-01565: error in identifying file

we get errors below while doing adcfgclone in test environment.

Problem:

ORA-01565: error in identifying file '/test1_db/sys/system11.dbf'
ORA-27048: skgfifi: file header information is invalid



Solution:

Resize dbfs which are full.


How to detect and fix a corruption in the datafile OS header/Block Zero - ORA-27047 (Doc ID 360032.1)
So please run the following command on the source database
dbfsize /test1_db/sys/system11.dbf

Done relinking module WSCMTM in product wsm

Problem:

While applying patch 12603409

Done relinking module WSCMTM in product wsm
Done with link of product 'wsm' on Fri Mar 29 19:34:26 EET 2013
adrelink is exiting with status 1


via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :


Solution:

via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :

adadmin-------->choose 2----->choose 1---->relink

Continue as if it were successful [No] :

Choose 'yes'

ORA-27048 skgfifi: file header information is invalid

Problem:

We got this error while running adcfgclone.pl

ORA-27048 skgfifi: file header information is invalid

Solution:

Check all the dbfs like this below:

dbfsize /test_db/sys/system01.dbf

If the output is 'Bad block'.This is dbf corruption.But don't worry.

You try to resize this dbf,then run see the dbsize again.

Ref:

R12: Rapidclone fails with error 'ORA-27048 skgfifi: file header information is invalid' [ID 1406053.1]

FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Problem:


FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Solution:

Apply the patch 13017245
Set ICX: Numeric characters = 10.000,00

Retest the issue

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

Xlib: connection to "x:0.0" refused by server

Problem:

When you running concurrent reports you get this error.

Xlib: connection to "x:0.0" refused by server

Xlib: Invalid MIT-MAGIC-COOKIE-1 key

REP-3000: Internal error starting Oracle Toolkit

REP-0004: Warning: Unable to open user preference file while running reports.

xlib connection to 1.0 refused by server oracle concurrent

Xlib: connection to "hostname:1.0" refused by server

Solution:

su - root

export DISPLAY=hostname:1.0

xhost +

./adcmtl.sh stop

./adcmtl.sh start

Note:
This problem happened AIX,SOLARIS OS,not LINUX.Because  reports use DISPLAY,Linux OS has DISPLAY,but others doesn't have.If you use Linux,don't panic.You won't come across this problem:)

AutoConfig could not successfully instantiate

Problem:

AutoConfig could not successfully instantiate the following files:

    Directory: $ORACLE_HOME/appsutil/install/CLONEDB_testburladb

      adcrdb.sh               INSTE8

adcfgclone is failing with AC-00423, RC-50014 adcrdb.sh missing from file system [ID 549872.1]

The template adcrdb.sh is missed in the target location "<10.2 DB $ORACLE_HOME>/appsutil/template"

Solution:

To implement the solution, please execute the following steps :

1. copy the missing 'adcrdb.sh' template from the Source to the Target Instance :

Source Location :

<10.2 DB $ORACLE_HOME>/appsutil/template

Target Location :

<10.2 DB $ORACLE_HOME>/appsutil/template

2. Change ownership and permission of adcrdb.sh file to match with the other templates, which resides in the template directory.

3. Re-start the adcfgclone dbTier on the Target Instance.

RC-00110: Fatal Error occurred while relinking of ApplyDBTechStack

Problem:

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

Solution:

rm $ORACLE_HOME/lib32/ldflags

ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/ldflags

RC-50208: Exception in method Timed Process.run

Problem:

RC-50208: Exception  in method TimedProcessProcess.run

Raised by oracle.apps.ad.util.TimedProcess$TimedProcessProcess: java.io.IOException: Cannot run program "unzip": error=2, No such file or directory

Solution:

Set java ve unzip set in your .profile(bash_profile) file.Add this line below:

$ORACLE_HOME/appsutil/jre/bin:$ORACLE_HOME/bin

ORA-12545: Connect failed because target host or object does not exist

Problem:

ORA-12545: Connect failed because target host or object does not exist


Solution:

Check hostname in your /etc/hosts file