28 April 2012

Unique constraint error (00001) is OK if key already exists

Error:-
Unique constraint error (00001) is OK if key already exists
ADD call failed with exit code 127

Trying to update information ...

UPDATE call failed with exit code 127

Generating /oracle/PROD1/prod1appl/fnd/11.5.0/secure/dev144.chainsys.com_prod1.dbc
DBC generation failed with exit code 127

Generating /oracle/PROD1/prod1appl/fnd/11.5.0/secure/dev144_prod1.dbc
DBC generation failed with exit code 127

Updating Server Security Authentication
Updating Server Security Authentication failed with exit code 127
adgendbc.sh exiting with status 127
ERRORCODE = 127 ERRORCODE_END

.end std out.
touch: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
sqlplus: error while loading shared libraries: libdl.so.2: cannot open shared object file: No such file or directory
grep: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
sed: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
cp: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
cp: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
cp: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

Solution:-

[oracle@dev144 02231428]$ . /oracle/PROD1/prod1appl/APPSPROD1_dev144.env
[oracle@dev144 ~]$ unset LD_LIBRARY_PATH
[oracle@dev144 ~]$ echo $LD_ASSUME_KERNEL
2.4.19
[oracle@dev144 ~]$ unset LD_ASSUME_KERNE
[oracle@dev144 ~]$ cd 6365595/
[oracle@dev144 6365595]$ adpatch

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                         Oracle Applications AutoPatch

                                 Version 11.5.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.


Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.


Your default directory is '/oracle/PROD1/prod1appl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify.  Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adpatch.log] : 6365595.log

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? 

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [PROD1] : PROD1 *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [dev144] : dev144 *



You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'PROD1'
using ORACLE executables in '/oracle/PROD1/prod1ora/8.0.6'.

Is this the correct database [Yes] ?

AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: manager


The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:

                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y



Identifier for the current session is 1756

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base        

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.

AD code level : [11i.AD.I.2]



Trying to obtain a lock...


  Attempting to instantiate the current-view snapshot...

  Was already instantiated. So no instantiation done this time.


     **************** S T A R T   O F   U P L O A D ****************

Start date: Thu Feb 23 2012 14:32:06



0 "left over" javaupdates.txt files uploaded to DB: Thu Feb 23 2012 14:32:06

0 patches uploaded from the ADPSV format patch history files: Thu Feb 23 2012 14:32:06


Uploading information about files copied during the previous runs ...

0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Feb 23 2012 14:32:06

     ****************** E N D   O F   U P L O A D ******************

End date: Thu Feb 23 2012 14:32:06

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/home/oracle/6365595] :

Please enter the name of your AutoPatch driver file : u6365595.drv

Getting Oracle Applications Release...

Current installed release is  11.5.10.2

Reading patch driver file...

  Parsing and loading patch driver file...
        154 lines processed.

  Not checking patch integrity as integrity checking flag is turned off.

Successfully read patch driver file.

Determining target release...

Current target    release is  11.5.10.2


Determining which bug fixes to apply...

Done determining which bug fixes to apply.


Log and Info File sync point:
  Thu Feb 23 2012 14:32:11
 
Turning off actions that reference unrecognized products.


Log and Info File sync point:
  Thu Feb 23 2012 14:32:11
 
End of unrecognized products checking.


AutoPatch will run in serial mode.


Did not need to apply new applterr.txt.

Applying new applprod.txt (if any)...

  Did not need to apply new applprod.txt.

Performing version checking for driver files...

Log and Info File sync point:
  Thu Feb 23 2012 14:32:11
  AutoPatch found some files which it will not apply.
  These files are listed in the AutoPatch informational message file.


Copying driver files into installation area...

  No driver files were selected for copying.

Skipping...
 ForceCopy driver files into installation area for Specified driver
 since no such action is present for this driver file

Screening out files not valid for this installation...

Determining valid on-site files...

Skipping...
 Extract object modules from libraries for Specified driver
 since no such action is present for this driver file

Performing version checking...

Log and Info File sync point:
  Thu Feb 23 2012 14:32:17
  AutoPatch found some files which it will not apply.
  These files are listed in the AutoPatch informational message file.


Skipping...
 Determine directories to create for Specified driver
 since no such action is present for this driver file

Skipping...
 Determine executables to link for Specified driver
 since no such action is present for this driver file

Skipping...
 Determine forms to generate for Specified driver
 since no such action is present for this driver file

Skipping...
 Determine Oracle Reports libraries to generate for Specified driver
 since no such action is present for this driver file

Skipping...
 Determine reports to generate for Specified driver
 since no such action is present for this driver file

Skipping...
 Determine if need to generate message files for Specified driver
 since no such action is present for this driver file

Looking for active bug fixes with no active actions...


Reading customized files list (if any)...

This patch replaces the following customized files:

  No customized files are replaced by this patch.
Copying files into installation area...

**********************************************************
You are running admvcode

Header information is:
  $Header: aiopatch.lc 115.44 2004/07/07 09:05:05 cbhati ship $

Start of admvcode session
Date/Time is Thu Feb 23 2012 14:32:17

Filelist file is: /oracle/PROD1/prod1appl/admin/PROD1/out/copymast.txt
Patch   Character Set is: us7ascii
On-site Character Set is: US7ASCII

Log and Info File sync point:
  Thu Feb 23 2012 14:32:17
 
Information about files copied to the APPL_TOP would be written to the
informational message file.

No character set conversion is required.


Copying files to APPL_TOP...

   0 directories created.
   1 files copied without         character set conversion.
   0 files copied with successful character set conversion.

   1 files copied successfully.
   0 files had fatal errors.

admvcode is exiting with status 0

End of admvcode session
Date/time is Thu Feb 23 2012 14:32:17
**********************************************************

Done copying files into installation area.

Skipping...
 ForceCopy files into installation area for Specified driver
 since no such action is present for this driver file

Skipping...
 Archive object modules into product libraries for Specified driver
 since no such action is present for this driver file

Skipping...
 Create Directories for Specified driver
 since no such action is present for this driver file

Skipping...
 Relink for Specified driver
 since no such action is present for this driver file

Performing second half of mirrored copies...

  No mirrored copies were executed in this patch.

Updating Oracle Applications Java files if necessary...

  No Oracle Applications Java files required updates.

  Checking to see if any files possibly included in the product JAR files
  were copied by this patch...

    No files possibly included in the product JAR files
    were copied by this patch.


Skipping ...
  Running AutoConfig to instantiate templates which affect
  the generation of JAR files since none of these templates
  were patched during this run of adpatch.

   No product JAR files need to be re-generated.


  Checking to see if adjborg.txt or any files included in
  adjborg.txt were copied by this patch...

   Neither adjborg.txt nor any file included in
   adjborg.txt was copied by this patch.

  Checking to see if adjborg2.txt or any files included in
  adjborg2.txt were copied by this patch...

   Neither adjborg2.txt nor any file included in
   adjborg2.txt was copied by this patch.

Compiling JSP files...

  Not compiling JSPs: no JSPs in patch.

  No JSP files were compiled.

Skipping...
 Run SQL scripts and EXEC commands for Specified driver
 since no such action is present for this driver file

Attempting to maintain MRC...


No action necessary for MRC.


Skipping...
 Compile invalid objects for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate forms library files for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate forms menu files for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate forms for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate reports libraries for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate reports for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate graphics libraries for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate graphics for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate Messages for Specified driver
 since no such action is present for this driver file

Skipping...
 Generate Workflow resource files for Specified driver
 since no such action is present for this driver file

Skipping ...
 Running AutoConfig since none of its templates were
 patched during this run of adpatch.

Saving Patch History information to Database...

Trying to obtain a lock...

> Inserted 1 patch history records (total).

Gathering Statistics for AD_PATCH_HIST_TEMP

Done Gathering Statistics for AD_PATCH_HIST_TEMP

>>> Inserted 1 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).

Gathering Statistics for AD_PATCH_HIST_TEMP

Done Gathering Statistics for AD_PATCH_HIST_TEMP

>>> Inserted 9 bug history records for this patch (total).
>>>>> Inserted 52 action history records for this bug (total).

  Updating the current-view snapshot...

  Done saving Patch History information.


About to do IREP processing...

  Attempting to process IREP files ...

  The package FND_ADPATCH does not exist, continuing...

Done IREP processing.

Copying applprod.tmp to applprod.txt (if needed)...

  Did not need to copy applprod.tmp to applprod.txt.

Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...

Did not need to copy admin/PROD1/applterr.txt to admin/applterr.txt.


There is no timing information available for the current session.


AutoPatch is complete.

AutoPatch may have written informational messages to the file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.lgi

Errors and warnings are listed in the log file
/oracle/PROD1/prod1appl/admin/PROD1/log/6365595.log

and in other log files in the same directory.

[oracle@dev144 ~]$ cd /oracle/PROD1/prod1comn/admin/scripts/PROD1_dev144/
[oracle@dev144 PROD1_dev144]$ ./adautocfg.sh
Enter the APPS user password:
AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using APPL_TOP location     : /oracle/PROD1/prod1appl
        Classpath                   : /oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/PROD1/prod1comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/PROD1/prod1comn/java/appsborg2.zip:/oracle/PROD1/prod1comn/java

        Using Context file          : /oracle/PROD1/prod1appl/admin/PROD1_dev144.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring ABM_TOP.......COMPLETED
        Configuring ECX_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring GL_TOP........COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring XNC_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring PA_TOP........COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring IMT_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
The log file for this session is located at: /oracle/PROD1/prod1appl/admin/PROD1_dev144/log/02231433/adconfig.log
[oracle@dev144 PROD1_dev144]$

No comments: