Tag Archives: Patching

SQL Developer Vendor Code 17002

Posted by on May 2, 2012 1 comment

Problem:

When connect to an 11i E-Business Suite database using SQL Developer, the following error appears:

An error was encountered performing the requested operation:

IO Error: Connection reset

Vendor code 17002

Sometimes, the error reads:

An error was encountered performing the requested operation:

IO Error: Got minus one from a read call

Vendor code 17002

Issuing the tnsping command against the instance returns the following:

C:>tnsping vis3

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 02-MAY-2012 10:21:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
C:OracleDevSuiteHomenetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oel5vis3.localdomain)
(PORT=1524)) (CONNECT_DATA= (SID=VIS3)))
TNS-12537: TNS:connection closed

Pinging the instance on the database node completed successfully.

The problem started occurring after applying ATG RUP7.

Solution:

AutConfig was run as part of applying ATG RUP 7 patches. This regenerated the sqlnet.ora, which included the following two lines:

tcp.validnode_checking = yes
tcp.invited_nodes=(OEL5VIS3.localdomain)

This blocked all SQL connections to the server. Since this instance is a test environment, the above lines in sqlnet.ora were commented off and the listener bounced.

[amazon asin=1847196268&template=iframe image&chan=default]     [amazon asin=0071484744&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]

FAILED: file OKLTXRBKUG.sql on worker while running patch 9239090

Posted by on January 30, 2012 No comments

Problem:

While running patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLTXRBKUG.sql on worker  1.
           FAILED: file OKLTXRBKUG.sql on worker  2.
           FAILED: file OKLTXRBKUG.sql on worker  3.
           FAILED: file OKLTXRBKUG.sql on worker  4.
           FAILED: file OKLTXRBKUG.sql on worker  5.
           FAILED: file OKLTXRBKUG.sql on worker  6.
           FAILED: file OKLTXRBKUG.sql on worker  7.
           FAILED: file OKLTXRBKUG.sql on worker  8.
           FAILED: file OKLTXRBKUG.sql on worker  9.
           FAILED: file OKLTXRBKUG.sql on worker 10.
           FAILED: file OKLTXRBKUG.sql on worker 11.
           FAILED: file OKLTXRBKUG.sql on worker 12.

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

Solution:

The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus as sysdba and ran the following commands:

alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;

OKL_TRANSACTION_PVT now compiles without issue.

To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:

select count(*) from dba_objects where status = ‘INVALID’;

Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.

FAILED: file OKLTXRBKUG.sql on worker 1

Posted by on January 30, 2012 No comments

Problem:

While running patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLTXRBKUG.sql on worker  1.
           FAILED: file OKLTXRBKUG.sql on worker  2.
           FAILED: file OKLTXRBKUG.sql on worker  3.
           FAILED: file OKLTXRBKUG.sql on worker  4.
           FAILED: file OKLTXRBKUG.sql on worker  5.
           FAILED: file OKLTXRBKUG.sql on worker  6.
           FAILED: file OKLTXRBKUG.sql on worker  7.
           FAILED: file OKLTXRBKUG.sql on worker  8.
           FAILED: file OKLTXRBKUG.sql on worker  9.
           FAILED: file OKLTXRBKUG.sql on worker 10.
           FAILED: file OKLTXRBKUG.sql on worker 11.
           FAILED: file OKLTXRBKUG.sql on worker 12.

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

Solution:

The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus and ran the following commands:

alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;

OKL_TRANSACTION_PVT now compiles without issue.

To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:

select count(*) from dba_objects where status = ‘INVALID’;

Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.

mth_pre_upgrade.sql Failed While Rerunning Patch 9239090

Posted by on January 30, 2012 No comments

Problem:

When rerunning patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file mth_pre_upgrade.sql on worker  1.

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

Checked worker log file:
C:oracleTEST1appsapps_stappladminTEST1logadwork001.log

The following errors appeared:

Time when worker started job: Mon Jan 30 2012 09:42:06

Start time for file is: Mon Jan 30 2012 09:42:06

sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql 

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Jan 30 2012 09:42:06

Time when worker started job: Mon Jan 30 2012 09:42:06

Start time for file is: Mon Jan 30 2012 09:42:06

sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql 

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Jan 30 2012 09:42:06

Solution:

1. Edit C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql  and uncomment SQL code for Exception. Then restart worker (did not try this solution).

2. Use adctrl (option 8) to skip and restart this step (tried this solution).

Reference:

https://forums.oracle.com/forums/thread.jspa?messageID=9224027

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

AC-30202: Unrecognized action specified, Context Value Management Failed

Posted by on December 7, 2011 No comments

Problem:

After sourcing APPSORA.env on and 11.5.10.2 environment and running AutoConfig, the following error appeared:

$ ./adautocfg.sh appspass=password

The log file for this session is located at: /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using APPL_TOP location     : /u01/test3/test3appl
        Classpath                   : /u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u01/test3/test3comn/java/appsborg2.zip:/u01/test3/test3comn/java

promptmsg=hide - AC-30202: Unrecognized action specified. Exiting.

ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:
    /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log
$

Solution:

After unsetting LD_ASSUME_KERNEL and applying patch 6365595, applied patch 5903765 (Applications Technology 11i.ATG_PF.H.delta.6). After patch completed, ran AutoConfig without problems.

 

Java HotSpot(TM) Client VM Error When Running dbua

Posted by on October 4, 2011 No comments

Problem:

After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:

[applmgr@centos53server ~]$ dbua
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C  [libnnz11.so+0x3c4d4]
#
# An error report file with more information is saved as hs_err_pid3662.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#
Aborted

 

Solution:

Apply patch p8670579_112010_LINUX.zip.

Read more »

OKSAUCVT.pll, OKSAUDET.pll, CSCUTILS.pll, OKCEXPOR.pll Not Generated Successfully

Posted by on September 20, 2011 No comments

OKSAUCVT.pll, OKSAUDET.pll, CSCUTILS.pll, OKCEXPOR.pll Not Generated Successfully

Problem:

Applying the R12.1.3 RUP patch to a R12.1.1 Vision instance on Windows Server 2003 Standard Edition Service Pack 2. After setting the _disable_fast_validate to TRUE in the initVIS12.ora file, and then bounced the 11g database. Restarted the R12.1.3 RUP patch (patch 9239090) from the beginning. The following error occurred while patching:

The following Oracle Forms objects did not generate successfully:

au      resource        OKSAUCVT.pll
au      resource        OKSAUDET.pll
au      resource        CSCUTILS.pll
au      resource        OKCEXPOR.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Solution:

Manually recompile the invalid libraries and then continue patch.

frmcmp module=%AU_TOP%/resource/OKSAUCVT.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKSAUCVT.plx module_type=library batch=no compile_all=special

frmcmp module=%AU_TOP%/resource/OKSAUDET.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKSAUDET.plx module_type=library batch=no compile_all=special

frmcmp module=%AU_TOP%/resource/CSCUTILS.pll userid=APPS/APPS output_file=%AU_TOP%/resource/CSCUTILS.plx module_type=library batch=no compile_all=special

frmcmp module=%AU_TOP%/resource/OKCEXPOR.pll userid=APPS/APPS output_file=%AU_TOP%/resource/OKCEXPOR.plx module_type=library batch=no compile_all=special

 

 

Compilation errors on CSC_PLAN_OUTCOMES:
PL/SQL ERROR 0 at line 18, column 17
Item ignored
PL/SQL ERROR 320 at line 73, column 41
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 67, column 3
Statement ignored
PL/SQL ERROR 320 at line 79, column 9
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 79, column 4
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library. 

FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/CSCUTILS.err


Compilation errors on LAUNCH:
PL/SQL ERROR 905 at line 2194, column 3
object APPS.OKS_COPY_CONTRACT_PVT is invalid
PL/SQL ERROR 0 at line 2194, column 3
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library. 

FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKCEXPOR.err


Compilation errors on OKSAUDET_ACTIONS:
PL/SQL ERROR 905 at line 287, column 4
object APPS.OKS_COPY_CONTRACT_PVT is invalid
PL/SQL ERROR 0 at line 287, column 4
Statement ignored

Compilation errors on OKS$CONTRACT_LINE:
PL/SQL ERROR 0 at line 402, column 30
Item ignored
PL/SQL ERROR 0 at line 426, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library. 

FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKSAUDET.err

Compilation errors on OKSAUCVT_MAIN:
PL/SQL ERROR 0 at line 1029, column 10
Statement ignored
PL/SQL ERROR 0 at line 1034, column 11
Statement ignored
PL/SQL ERROR 0 at line 1901, column 33
Item ignored
PL/SQL ERROR 320 at line 1907, column 12
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1907, column 12
Statement ignored
PL/SQL ERROR 320 at line 1908, column 12
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1908, column 12
Statement ignored
PL/SQL ERROR 320 at line 1909, column 12
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1909, column 12
Statement ignored
PL/SQL ERROR 320 at line 1910, column 12
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1910, column 12
Statement ignored
PL/SQL ERROR 320 at line 1911, column 12
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1911, column 12
Statement ignored
PL/SQL ERROR 320 at line 1919, column 49
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 1913, column 6
Statement ignored


Compilation errors on OKSAUCVT_COV_TIMES:
PL/SQL ERROR 0 at line 337, column 26
Item ignored
PL/SQL ERROR 320 at line 377, column 56
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 376, column 1
Statement ignored
PL/SQL ERROR 320 at line 381, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 381, column 1
Statement ignored
PL/SQL ERROR 320 at line 385, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 385, column 1
Statement ignored
PL/SQL ERROR 320 at line 389, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 389, column 1
Statement ignored
PL/SQL ERROR 320 at line 393, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 393, column 1
Statement ignored
PL/SQL ERROR 320 at line 397, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 397, column 1
Statement ignored
PL/SQL ERROR 320 at line 400, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 400, column 1
Statement ignored
PL/SQL ERROR 320 at line 403, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 403, column 1
Statement ignored


Compilation errors on OKSAUCVT_COPY_COVERAGE:
PL/SQL ERROR 0 at line 37, column 4
Statement ignored


Compilation errors on OKSAUCVT_BILLING_RATES_REG:
PL/SQL ERROR 0 at line 651, column 26
Item ignored
PL/SQL ERROR 320 at line 695, column 69
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 693, column 1
Statement ignored
PL/SQL ERROR 320 at line 703, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 703, column 1
Statement ignored
PL/SQL ERROR 320 at line 706, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 706, column 1
Statement ignored
PL/SQL ERROR 320 at line 709, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 709, column 1
Statement ignored
PL/SQL ERROR 320 at line 712, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 712, column 1
Statement ignored
PL/SQL ERROR 320 at line 715, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 715, column 1
Statement ignored
PL/SQL ERROR 320 at line 718, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 718, column 1
Statement ignored
PL/SQL ERROR 320 at line 721, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 721, column 1
Statement ignored
PL/SQL ERROR 0 at line 910, column 26
Item ignored
PL/SQL ERROR 320 at line 940, column 69
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 938, column 1
Statement ignored
PL/SQL ERROR 320 at line 945, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 945, column 1
Statement ignored
PL/SQL ERROR 320 at line 948, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 948, column 1
Statement ignored
PL/SQL ERROR 320 at line 951, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 951, column 1
Statement ignored
PL/SQL ERROR 320 at line 954, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 954, column 1
Statement ignored
PL/SQL ERROR 320 at line 957, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 957, column 1
Statement ignored
PL/SQL ERROR 320 at line 960, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 960, column 1
Statement ignored
PL/SQL ERROR 320 at line 963, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 963, column 1
Statement ignored


Compilation errors on OKSAUCVT_BILLING_RATES_H:
PL/SQL ERROR 0 at line 646, column 26
Item ignored
PL/SQL ERROR 320 at line 686, column 69
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 684, column 1
Statement ignored
PL/SQL ERROR 320 at line 690, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 690, column 1
Statement ignored
PL/SQL ERROR 320 at line 693, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 693, column 1
Statement ignored
PL/SQL ERROR 320 at line 696, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 696, column 1
Statement ignored
PL/SQL ERROR 320 at line 699, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 699, column 1
Statement ignored
PL/SQL ERROR 320 at line 702, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 702, column 1
Statement ignored
PL/SQL ERROR 320 at line 705, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 705, column 1
Statement ignored
PL/SQL ERROR 320 at line 708, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 708, column 1
Statement ignored
PL/SQL ERROR 0 at line 885, column 26
Item ignored
PL/SQL ERROR 320 at line 915, column 69
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 913, column 1
Statement ignored
PL/SQL ERROR 320 at line 920, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 920, column 1
Statement ignored
PL/SQL ERROR 320 at line 923, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 923, column 1
Statement ignored
PL/SQL ERROR 320 at line 926, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 926, column 1
Statement ignored
PL/SQL ERROR 320 at line 929, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 929, column 1
Statement ignored
PL/SQL ERROR 320 at line 932, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 932, column 1
Statement ignored
PL/SQL ERROR 320 at line 935, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 935, column 1
Statement ignored
PL/SQL ERROR 320 at line 938, column 4
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 938, column 1
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library. 

FRM-30119: Errors and warnings written to file G:oracleVIS12appsapps_stapplau12.0.0/resource/OKSAUCVT.err

Note that when these four libraries were manually compiled, they still returned errors. Nevertheless, the patch was continued by entering Yes at the prompt.

Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies

Posted by on September 20, 2011 No comments

Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies

Problem:

While running patch 9239090 (R12.1.3 RUP) on Windows, the following Oracle Forms objects did not generate successfully:

wsh     forms/US        WSHQSSUI.fmx
wsh     forms/US        WSHSTREF.fmx
wsh     forms/US        WSHFSTRX.fmx

To resolve this, the invalid WSH packages were identified and compiled. However, while compiling the invalid WSH package bodies, compilation errors resulted.

Solution: Flush the shared pool before compiling the package bodies.

Read more »

Oracle Forms objects not generating in Patch 9239090 (R12.1.3 RUP)

Posted by on September 15, 2011 No comments

Problem: While running R12.1.3 patch (9239090), the following error appears:

The following Oracle Forms objects did not generate successfully:

au      resource        OKEKAULN.pll
au      resource        OKLCSASD.pll
au      resource        OKSAUCVT.pll
au      resource        OKSAUDET.pll
au      resource        CSCUTILS.pll
au      resource        OKCEXPOR.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Solution:

Manually regenerate the forms, and then continue patch 9239090.

Read more »

admsi.pl Not Running on Windows

Posted by on September 14, 2011 No comments

Problem:

After sourcing the apps environment and running admsi.pl from Command Prompt, admsi.pl opens in Notepad instead of launching the Java forms patch wizard.

Solution:

Set the DISPLAY parameter and run the script from Perl.

D:patches9239089>which admsi.pl
/cygdrive/g/oracle/VIS12/apps/apps_st/appl/ad/12.0.0/bin/admsi.pl

D:patches9239089>%AD_TOP%binadmsi.pl

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....
Please set the DISPLAY variable and re-run this script

D:patches9239089>echo $DISPLAY
$DISPLAY

D:patches9239089>echo %DISPLAY%
%DISPLAY%

D:patches9239089>set DISPLAY=.0:0

D:patches9239089>perl %AD_TOP%binadmsi.pl
Invoking Oracle Patch Application Assistant....