Pathcing Issues

1. Encountered the following erro while applying the patch :

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

or continue without prerequisite checking.

Continue as if prerequisite patches have been applied? [Yes] ?


Solution :

************

When you get the above error, Check for the list of preequisite patches that the adpatch has queried from the patch log file , if they are already applied, Give Yes and continue with the patching process. Once all the patches are applied , Run adadmin and update

Current view snapshot.

2. Encountered the following erro while applying the patch :

ATTENTION: All workers either have failed or are waiting:

FAILED: file pa_proj_levels_tmp.xdf on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Table Name is PA_PROJ_LEVELS_TMP

Table does not exist in the target database

Executing create Statement

Create Statement is

CREATE GLOBAL TEMPORARY TABLE "APPS"."PA_PROJ_LEVELS_TMP"

( "FROM_ID" NUMBER(15,0),

"TO_ID" NUMBER(15,0),

"FROM_LEVEL" NUMBER(15,0),

"TO_LEVEL" NUMBER(15,0),

"DIRECTION" VARCHAR2(1),

"ATTRIBUTE1" VARCHAR2(30),

"ATTRIBUTE2" VARCHAR2(30),

"ATTRIBUTE3" VARCHAR2(30),

"ATTRIBUTE4" VARCHAR2(30),

"ATTRIBUTE5" VARCHAR2(30),

"ATTRIBUTE6" VARCHAR2(30)

) ON COMMIT DELETE ROWS

Start time for statement above is Mon Apr 23 09:18:03 CDT 2007

Exception occured ORA-00955: name is already used by an existing object

java.sql.SQLException: ORA-00955: name is already used by an existing object



Solution :

************

Bounced the database and restarted the patch application. Patch was applied successfully.



3. ****************The below error occurs almost often*****************

Encountered the following erro while applying the patch :

ATTENTION: All workers either have failed or are waiting:

FAILED: file fndcct.jar on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Loading contents of archive file into database with arguments


-ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/XFuEVowV@auohsmrkm13:10010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar


Calling /usr/java/j2sdk1.4.2_10/bin/java ...

SQL Error while connecting with thin driver to auohsmrkm13:10010:PMRKMI: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869824)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

could not open connection

loadjava: 2 errors

AD Worker error:

The above program failed. See the error messages listed

above, if any, or see the log and output files for the program.

Time when worker failed: Sun Apr 29 2007 14:27:47



Solution :

********************

Manually executed the command as follows :



$java -ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/xxxxx@auohsmrkm13:10010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar

$ 0010:PMRKMI1" /pmrkmi/applmgr/11510/admin/PMRKMI/out/p001ldjva.jar

$

4.************The Below Error Occurs Often in 10G instances***************
  
Encountered the following erro while applying the patch :
                       
AutoPatch error:

The following ORACLE error:

ORA-38301: can not perform DDL/DML over objects in Recycle Bin


occurred while executing the SQL statement
DROP TABLE AD_DEFERRED_JOBS

AutoPatch error:

adfrjp(): Error dropping FND_INSTALL_PROCESSES table


An error occurred while generating Oracle Forms files.

Continue as if it were successful [No] :

You should check the file
/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.log

for errors.


********************************************************************

* PATCH HAS FAILED !!! *

********************************************************************

Patch failed, please rerun patch when problem has been fixed !

Please check logfiles for errors at:

/pmrkmi/applmgr/11510/admin/PMRKMI/log/4725549_F

Solution :

********************
SQL> sho user

USER is "APPLSYS"

SQL> exec execute immediate 'purge recyclebin';

PL/SQL procedure successfully completed.

SQL>

AutoPatch is complete.

AutoPatch may have written informational messages to the file

/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.lgi

Errors and warnings are listed in the log file

/pmrkmi/applmgr/11510/admin/PMRKMI/log/u4725549f.log
and in other log files in the same directory.


5. Encountered the following erro while applying the patch :

Error while applying patch -2 :

=========================================

AutoPatch is complete.

-ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/*****@AUOHSROIN12.oracleoutsourcing.com:10010:PROINI" /proini/applmgr/11510/admin/PROINI_BALANCE/out/p001ldjva.jar


Calling /proini/applmgr/common/util/java/1.4/j2sdk1.4.2_04/bin/java ...

SQL Error while connecting with thin driver to AUOHSROIN12.oracleoutsourcing.com:10010:PROINI: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

Solution :
Executed the command manually :

java -ms128m -mx256m oracle.aurora.server.tools.loadjava.LoadJavaMain -f -thin -user "APPS/apppwd@AUOHSROIN12.oracleoutsourcing.com:10010:PROINI1 " /proini/applmgr/11510/admin/PROINI_BALANCE/out/p001ldjva.jar

Skipped the worker and continued with patching.

6. Encountered the following erro while applying the patch :

create tablespace IZUD datafile '/dczb3i/oradata/data01/izud01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;
create tablespace IZUX datafile '/dczb3i/oradata/data01/izux01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;

create user izu identified by izu default tablespace izud;

grant connect,resource to izu;

select tablespace_name from dba_tablespaces where tablespace_name='IZUD';


TABLESPACE_NAME

------------------------------

IZUD
create tablespace IZUX datafile '/dczb3i/oradata/data01/izux01.dbf' size 500M autoextend on next 25M maxsize 1800M extent

management local;

select tablespace_name from dba_tablespaces where tablespace_name='IZUX';

TABLESPACE_NAME

------------------------------

IZUX

Run adsplicer :

******************

Please enter the directory where your AD Splicer control file is located.


The default directory is [/dczb3i/applmgr/11510/admin] :

Please enter the name of your AD Splicer control file [newprods.txt] :


Processing file /dczb3i/applmgr/11510/admin/newprods.txt...

Loading information for product 'izu'...

Warning: Because the database is in new tablespace mode, AD Splicer is ignoring the tablespace settings in your control file!

Successfully read file /dczb3i/applmgr/11510/admin/newprods.txt.

Verifying localizations...

Validating inter-product dependency information...

Re-organizing product information lists...

Adding new languages into FND_LANGUAGES...

Creating ORACLE usernames for products...

AD Splicer is creating or updating the ORACLE username IZU

with password ***** for Oracle Support Diagnostic Tools tables.

Granting privileges for tablespaces...
Granting required system privileges and creating APPS*DDL packages...

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaddls.pls ***** IZU *****

Spawned Process 16221

Done running adaddls.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaaddls.pls ***** IZU *****

Spawned Process 16224

Done running adaaddls.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaddlb.pls ***** IZU *****

Spawned Process 16239

Done running adaddlb.pls for IZU

sqlplus -s IZU/***** @/dczb3i/applmgr/11510/ad/11.5.0/admin/sql/adaaddlb.pls ***** IZU *****

Spawned Process 16240

Done running adaaddlb.pls for IZU

Registering ORACLE usernames/passwords.

**

**Inserting application information for new products...

**

Running fnd_application_pkg.add_language ...

**

**Updating product information for new products...

**

Populating INSTALL_GROUP_NUM column to FND_ORACLE_USERID table.

**

**Updating product dependency information...

**

Recording modules in the database...done.

**

**Updating Data Groups...

**

Reading existing data groups from database.

Registering any new data groups.

Registering any new data group units.

Updating Data Group "Standard" to point to

APPS #1 Account (ORACLE ID = 900)
Updating Patch Advisor tables to include new product information ..

sqlplus -s APPS/***** @/dczb3i/applmgr/11510/ad/11.5.0/sql/adpaseed.sql *****

Spawned Process 16255

Done.
Saving module actions...done.

Saving product actions...done.

Product top directory for product "izu" exists.

Directory is /dczb3i/applmgr/11510/izu/11.5.0

Directory "log" for product "izu" exists.

Directory "out" for product "izu" exists.

Directory "mesg" for product "izu" exists.

Directory "sql" for product "izu" exists.

File "sql/IZUNLINS.sql" for product "izu" exists.

Directory "admin/sql" for product "izu" exists.

File "admin/sql/IZUNLADD.sql" for product "izu" exists.

Directory "admin/driver" for product "izu" exists.

File "admin/driver/izucon.drv" for product "izu" exists.

File "admin/driver/izuseq.drv" for product "izu" exists.

File "admin/driver/izutab.drv" for product "izu" exists.

File "admin/driver/izutbm.drv" for product "izu" exists.

File "admin/driver/izuos.drv" for product "izu" exists.

File "admin/driver/izupls.drv" for product "izu" exists.

File "admin/driver/izuvw.drv" for product "izu" exists.

File "admin/driver/izuplb.drv" for product "izu" exists.

File "admin/driver/izupdt.drv" for product "izu" exists.

File "admin/driver/izudat.drv" for product "izu" exists.

File "admin/driver/izuupg.drv" for product "izu" exists.

File "admin/driver/izudfr.drv" for product "izu" exists.

File "admin/driver/izuen.drv" for product "izu" exists.

File "admin/driver/izudep.drv" for product "izu" exists.

Do you wish to regenerate your environment file [Yes] ? no

AD Splicer is complete.

***********Skip the process of regenerating the env file as it will force to run autoconfig

select APPLICATION_ID from fnd_application where ALICATION_SHORT_NAME = 'IZU';

APPLICATION_ID

--------------

278

Edit the existing env file with the entry of the product top and save the changes.



/dczb3i/applmgr/11510/izu/11.5.0



7. Encountered the following erro while applying the patch :

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

Time when worker failed: Tue Oct 17 2006 08:47:04

========================================================



Isssue while applying a patch :



========================================================

FNDLOAD apps/IFm9bC29 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @PO:patch/115/import/US/poprg.ldt

While applying the patch 5249967, FAILED: file poprg.ldt on worker 1.

After looking at the log file , the worker 01 failed with this error :

Error loading seed data for VSET_TABLE: FLEX_VALUE_SET_NAME = PO_SRS_CHART_OF_ACCOUNTS, ORA-20001:

Later found that, the table VSET_TABLE does not exists.

SQL> select name,user from v$database;

NAME USER

--------- ------------------------------

TATENI APPS

SQL> select * from dba_objects where object_name='VSET_TABLE';
no rows selecte
SQL> select * from dba_objects where object_name='VSET_TABLE' and object_type='TABL
no rows selected
SQL> desc VSET_TABLE
ERROR:
ORA-04043: object VSET_TABLE does not exist
SQL>
Hence Skipping the worker using adctrl.

0 comments:

Post a Comment