Monthly Archives: July 2007

11i Upgrade on Test Instance

Step No. Patch Number Type of Patch Patch Name Date Applied Start
Time
End
Time
Time Taken
(One Tier)
Comment Node Applied
Patches Applied June-July, 2007
15/06/2007 10:58 03/07/2007 2:24 17 days 15:25 hours Total time taken: 17 days 15 hours
Enable Maintenance Mode
Shut down Oracle services on application and database nodes
1 4238286 ONE-OFF PATCH TUMS-MP 11.5.10: TUMS UTILITY FOR THE 11.5.10 MAINTENANCE PACK Fri 15-Jun-07 10:58:53 11:03:13 0 days 0:04 hours
2 4712852 MINI PACK Minipack 11i.AD.I.4 Fri 15-Jun-07 12:25:18 12:50:59 0 days 0:25 hours GHL1TESTDATA
3 5107107 ROLLUP PATCH TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH N (AUGUST 2006) Fri 15-Jun-07 15:32:19 15:49:50 0 days 0:17 hours GHL1TESTDATA
4 4318672 ONE-OFF PATCH 11.5.10.2 Technology Stack Validation Patch (Revision 1 July, 2005) Fri 15-Jun-07 17:02:39 17:06:37 0 days 0:03 hours
5 4139957 INTEROP PATCH Interop Patch For 11.5.10 TechStack Component Only Install Sat 16-Jun-07 17:43:42 21:06:43 0 days 3:23 hours
6 4888294 INTEROP PATCH APPLICATIONS INTEROPERABILITY PATCH FOR DEVELOPER 6I PATCH 18* Sun -Jun-07 16:42:33 16:47:43 0 days 0:05 hours
7 5529008 SUPPORT PACK DIAGNOSTICS SUPPORT PACK NOVEMBER 2006 with Oracle Diagnostics 2.4 RUP A Sat 23-Jun-07 8:23:58 8:39:17 0 days 0:15 hours
8 3480000 MAINTENANCE PACK ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK Sat 30-Jun-07 15:25:16 2:24:34 2 days 10:59 hours Started: Sat Jun 30 2007 15:25:16
Completed: Tue Jul 03 2007 02:24:34
9 3275245 ONE-OFF PATCH 11.5.10 ONLINE HELP CONSOLIDATED PATCH Thu 05-Jul-07 12:19:33 1:18:37 0 days 12:59 hours
10 5117525 INTEROP PATCH APPLICATIONS INTEROPERABILITY PATCH FOR JINITIATOR 1.3.1.x Sat 07-Jul-07 19:57:17 20:06:05 0 days 0:08 hours
11 5759055 ROLLUP PATCH TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) Sun 08-Jul-07 19:22:20 19:38:08 0 days 0:15 hours
12 4653225 INTEROP PATCH 11.5.10 INTEROP PATCH FOR 10GR2 Sun 08-Jul-07 20:18:57 20:41:48 0 days 0:22 hours
13 5753621 ONE-OFF PATCH ONE-OFF REQUEST ON TOP OF 11.5.9 CU2 FOR BUG 5525015 Fri 13-Jul-07 17:04:06 17:11:36 0 days 0:07 hours
14 3636980 NEW PRODUCT Support Diagnostics (IZU) patch for AD Splice Mon 23-Jul-07 8:15:44 8:19:28 0 days 0:03 hours
15 2838093 ONE-OFF PATCH ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS Sat 28-Jul-07 11:36:10 11:38:47 0 days 0:02 hours C driver
16 2838093 ONE-OFF PATCH ONE-OFF FIXES FOR XSU 1.2.1 & XML PARSER FOR PL/SQL 1.0.2 FOR APPLICATIONS Sat 28-Jul-07 11:43:01 11:45:18 0 days 0:02 hours D driver
17 4464099 ROLLUP PATCH FUNDS CHECKER ROLLUP PATCH : STANDALONE FOR BASE11i OR ANY MAINTENANCE PACK Sat 28-Jul-07 12:01:07 12:07:34 0 days 0:06 hours
18 3180164 UPDATE APPLPROD.TXT TO ADD NEW PRODUCTS FOR 11.5.10 MAINTENANCE PACK Sat 28-Jul-07 16:46:28 17:03:32 0 days 0:17 hours

Setting Up Custom GL Menus and Functions

Step 1: Navigate to Security > Responsibility > Request. Enter a new record with a new Group, Application, and Code. Then enter a new Request type.

Step 2: Next, navigate to Application > Function. Press F11 and search for CS%FND%. Locate CS_FNDRSRUN. Click the Form tab. Copy and paste the Parameters value to text file.

Step 3: Insert a new record in Form Functions named MFGL_FNDRSRUN. Paste the copied value into the Parameters field and modify the APPL_SHORT_NAME.

Step 4: Get menu name: GL_SUPERUSER

Navigate to Security > Responsibility > Define. Search for the custom responsibility by pressing F11 and entering the searching string, then press Ctrl+F11.

Step 5: Navigate to Application > Menu. We want to modify the Import Journals and review data Menu. Pull up GL_SUPERUSER menu and click View Tree. Navigate to Journals, then Import. Right-click and choose Properties. Alternatively, search for GL%IMPORT%.

Step 6: The GL_SU_J_IMPORT menu appears. Insert a new menu line together with its Prompt and Function Name. Then Save.

Running Custom Reports in ADI 7.3

This documents the process of running a custom report in ADI.

Step 1:        Log on to ADI (ILLUMINAT/******@TEST)

Step 2:        Submit Ledger Process > Report

Step 3:        Existing Report: MGFL%

Step 4:        “MGFL Unaudited Revenue Stmt”

Step 5:        Period: MAR-06

Step 6:        Click Publishing Button

Step 7:        Spreadsheet, New Workbook

Step 8:        Publish To:

Step 9:        Report Type: Financial Statement

Step 10:   Green button: Submit and Clear the Form

Step 11:    Then click Publish Report

Troubleshooting APP-10000: ORA-12500 Error

While creating a new vendor in Oracle Applications, the following error appeared:

APP-10000: ORA-12500: TNS:listener failed to start a dedicated server process
ORA-06512: at "PO.API_PUT_ERROR_SP", line 9
ORA-06512: at "PO.API_POVNDHDR_TRG", line 208
ORA-12500: TNS:listener failed to start a dedicated server pricess
ORA-04088: error during execution of trigger 'PO.API_POVNDHDR_TRG' occurred in AP_VENDORS_PKG.INSERT_ROW<-APXVDMVD with parameters (ROWID = , VENDOR_ID = 10282) while performing the following operation:
Insert into PO_VENDORS

The following steps were taken to troubleshoot the issue:

1. Ensured the respective Oracle services were running properly (OracleServicePROD, OracleStartPROD, the Concurrent Manager and TNS Listener) by stopping and restarting them.

2. Obtained TNS-12500 troubleshooting document from Oracle’s Metalink website and ensured that all items on the list were resolved.

3. Checked the Event Log on EWSD1PROD for error messages.

4. Checked Oracle’s ALERT.LOG file on ORA errors messages.

5. Ran ScanDisk on the E: of the EWSD1PROD (Oracle Financials) server.

6. Checked the SQL code in the procedure “PO.API_PUT_ERROR_SP”, which appeared in the error message. This showed that the procedure was attempting to access the MAXIMO instance.

7. Completed the backup on MAXIMO and allowed the Oracle database services on the MAXIMO server to restart.

Solution: Transactions were being pushed from Oracle Applications to the MAXIMO server, which had been shut down. Upon restarting MAXIMO server, the issue was resolved.

Resolving REP-3000 Error

Problem: When the Active Users (PDF) report is run, it completes in error with the following log file:

+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDSCURSPDF module: Active Users (PDF)
+---------------------------------------------------------------------------+
Current system time is 17-JUL-2007 11:37:42
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to:  /u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Spawned Process 27647
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
Report Builder: Release 6.0.8.24.0 - Production on Tue Jul 17 11:37:53 2007
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Enter Username:
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 3019814.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 17-JUL-2007 11:38:06
+---------------------------------------------------------------------------+

Solution: Change the DISPLAY environment variable in Oracle Applications.

Log on to Oracle Applications Manager, and navigate to Site Map > AutoConfig.

There are two context files: one for the Database tier and the other for the Applications Tier. In the Applications tier row, click Edit Parameters. Click the Environments tab. Expand oa_environment:generic_service. Under X11 Display (s_display), change ‘hostname:0.0’ to ‘:0.0’. Save the changes. Then log out of Oracle Applications Manager.

The context file for the application tier must be regenerated. On the server, source the environment, stop the application tier services (adstpall.sh), run AutoConfig on the application tier (adconfig.sh), then restart the application tier services (adstrtal.sh).

Refer to:

Metalink Doc ID: Note: 181244.1

Subject:  Configuring VNC Or XVFB As The X Server For Applications 11i

Metalink Doc ID: Note: 200474.1

Subject:  Comprehensive REP-3000 Troubleshooting and Overview Guide

Registering New Active Users Report

This documentation illustrates how to copy an existing report to a new report and register it in Oracle Applications. The Active Users report shall be used as an example.

Step 1:        Log on to Oracle Applications and choose the System Administrator responsibility. Navigate to Concurrent > Program > Define.

Step 2:        The Concurrent Programs form appears. Press F11 and type ‘Active%’ in the Program field. Then press Ctrl+F11.

Step 3:        The Active Users program appears in the form. Click the Copy To button.

Step 4:        The Copy To form appears. Enter ‘Active Users (PDF)’ in the Program field, and ‘FNDSCURSPDF’ in the Short Name field. Then click OK.

Step 5:        The Active Users (PDF) program appears in the form. Change the Output Format field to ‘PDF’. Then click Save.

Step 6:        Navigate to Security > Responsibility > Define. The Responsibilities form appears. Press F11. Type ‘System Administrator’ in the Responsibility Name field and ‘System Administration’ in the Application field, and press Ctrl+F11.

Note the Request Group Name and Application.

Step 7:        Navigate to Security > Responsibility > Request. The Request Group form appears. Press F11 and type ‘System Administrator Reports’ in the Group field and ‘Application Object Library’ in the Application field. Then press Ctrl+F11.

Step 8:        Select the record to insert the new record under, then click New. In the Name field, select ‘Active Users (PDF)’ from the list. Then click Save.

Step 9:        The report now appears in the Concurrent Requests list under System Administrator.

Step 10:   If there are any issues viewing the PDF reports, it may be necessary to change the PDF profile options. Search for ‘PDF’ or ‘Viewer’.

Patch List for Cloning 11i

Step No. Patch Number Type of Patch Patch Name Date Applied Comment Node Applied
Patches Applied to PROD on July 5, 2007
Refer to Metalink Doc ID: 230672.1 (Cloning Oracle Applications Release 11i with Rapid Clone)
Enable Maintenance Mode
Shut down Oracle application tier services
1 5035661 Minipack UPGRADE OUI TO VERSION 2.2 5-Jul-07 Apply to iAS and RDBMS homes linux-blade
2 4712852 Minipack MINIPACK 11I.AD.I.4 5-Jul-07 See Metalink Doc ID: 233044.1 linux-blade
3 5759055 Rollup Patch TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) 5-Jul-07 See Metalink Doc ID: 165195.1 linux-blade
Update RDBMS ORACLE_HOME with AutoConfig files from Application Tier
4 5225940 Family Pack POST ADX-F FIXES 5-Jul-07 linux-blade
Disable Maintenance Mode before copying files
Continue cloning process
Restart Oracle application tier services
Note:
Patches 3453499 and 4709948 were applied by 5759055; there is no need to apply these patches.
linux-blade: Database tier, concurrent processing server, administration server, reports server, forms server, web server
Source directory: /emca/PROD/
Target Directory: /u0/oracle

 

Installing Oracle Application Express

This documentation shows the steps covered in installing Oracle Application Express.

Refer to: http://www.oracle.com/technology/products/database/application_express/index.html

10gR1 Installation

Step 1:        Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.

Step 2:        Install HTML DB from Oracle Database 10g Companion CD.

Step 3:        Point browser to http://oracleserver.support.com:7777/pls/htmldb

 

10gR2 Installation

Step 1:        Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.

Issue encountered where it was not able to write to directory. It was defaulting to D:oracleoradata for the data files. This is the CD-ROM drive, so I had to do Advanced installation and specify E:oracleoradata.

Step 2:        Install HTML DB from Oracle Database 10g Companion CD.

Step 3:        Point browser to http://oracleserver.support.com:7777/pls/htmldb

VIS12 Installation

Step 1:        Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.

Step 2:        To determine products installed, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/ and source the environment

(. ./VIS12_appslinux.env).

Step 3:        Next, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/oui/bin and run runInstaller (./runInstaller)

Step 4:        Download and install the apex_3.0.zip file from Oracle.com onto any directory that applmgr owns (e.g. /u0).

Step 5:        Unzip apex_3.0.zip into the /u0 directory.

[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u0]$ unzip apex_3.0.zip

Step 6:        The VIS12 instance shall be used. Navigate to the VIS12 10.2.0 Oracle Home and source the environment.

[applmgr@appslinux u0]$ cd /u5/oracle/VIS12/db/tech_st /10.2.0/
[applmgr@appslinux 10.2.0]$ . ./VIS12_appslinux.env
[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 10 18:29:00 2007
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_CALCLIP
APPS_OMO
APPS_TS_ARCHIVE
APPS_TS_DISCO
APPS_TS_DISCO_OLAP
APPS_TS_INTERFACE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TOOLS
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_UNDOTS1
B2B_DT
B2B_IDX
B2B_LOB
B2B_RT
BAM
CTXSYS
CWMLITE
DCM
DISCO_PTM5_CACHE
DISCO_PTM5_META
DSGATEWAY_TAB
GEOR_TBS
HTMLDB
IAS_META
MTR
NOETIX
NON_APPS_TS_DATA
OCATS
ODM_DATA
OLTS_ATTRSTORE
OLTS_BATTRSTORE
OLTS_CT_STORE
OLTS_DEFAULT
OLTS_SVRMGSTORE
OPMOR
ORABPEL
OWAPUB
PORTAL
PORTAL_DOC
SYNCSERVER
SYSAUX
SYSTEM
TEMP1
TEMP2
XDB
55 rows selected.
SQL>

VIS4 Installation

Step 7:        Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.

Step 8:        Download and install the apex_3.0.zip file from Metalink onto any directory that applmgr owns (e.g. /u0).

Step 9:        Unzip apex_3.0.zip into the /u3 directory.

[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u3]$ unzip apex_3.0.zip

Step 10:   The VIS4 instance shall be used. Navigate to the VIS4 9.2.0 Oracle Home and source the environment.

[applmgr@appslinux u3]$ cd /u3/oracle/vis4db/9.2.0/
[applmgr@appslinux 9.2.0]$ . ./VIS4_appslinux.env

Step 11:    Change directory to the apex working directory.

[applmgr@appslinux u3]$ cd /u0/apex
[applmgr@appslinux apex]$ ls
apex_epg_config11.sql  core
apex_epg_config.sql    coreins.sql
apexins.sql            doc
apexvalidate.sql       images
apxconf.sql            load_trans.sql
apxremov.sql           owa
apxxepwd.sql           utilities
builder                welcome.html

Step 12:   Log on to sqlplus and check if the required tablespaces exist:

[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Jun  27 10:51:04 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Pro duction
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_TS_ARCHIVE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_TX_INTERFACE
APPS_UNDOTS1
CTXSYS
TABLESPACE_NAME
------------------------------
DATA
ODM
OLAP
OWAPUB
PORTAL
SYNCSERVER
SYSTEM
TEMP
19 rows selected.

Step 13:   The Temp tablespace exists, but there is no SYSAUX. This tablespace shall be created for use with APEX.

SQL> create tablespace sysaux
datafile '/u3/oracle/vis4data/sysaux.dbf' size 32M
autoextend on
maxsize unlimited
permanent
online
extent management local;
Tablespace created.

Step 14:   Run the command:

SQL> @ apexins oracle sysaux sysaux temp /i/

Step 15:   Run the command:

SQL> @apex_epg_config11 /u0

Step 16:   Run the command:

SQL> alter user anonymous account unlock;
User altered.

Step 17:   Run the command:

SQL> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
-----------
0

Step 18:   Run the command:

SQL> exec dbms_xdb.sethttpport(8080);

Step 19:   Run the command:

[applmgr@appslinux ~]$ cd /u5/oracle/VIS12/apps/apps_st/ appl/
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ cp -rf /u0/apex/images/ /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/Apache/

To source 9.2.0 RDMBS environment:

cd /u5/oracle/VIS12/db/tech_st/10.2.0/
. ./VIS12_appslinux.env
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ echo $ORACLE_HOME
/u5/oracle/VIS12/apps/tech_st/10.1.2 (INCORRECT HTTPD HOME)

SQL to remove schemas after a failed new installation

drop user flows_030000 cascade;
drop user flows_files cascade;

SQL to remove Oracle Application Express from the Database

@apxremov.sql
drop user FLOWS_010500 cascade;
drop user FLOWS_020000 cascade;
select username from dba_users order by 1;
select owner, object_name, object_type, status from dba_objects where status = ‘INVALID’;

SQL to install Oracle Application Express from the Database

@apexins oracle sysaux sysaux temp1 /i/

THE BELOW IS CORRECT:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/ora/10.1.3

Location of updated dads.conf: /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/modplsql/conf

Log file:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/logs/ora/10.1.3/Apache/

To stop and start HTTP server:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/admin/scripts

UTL_FILE Sample Code

Here is some sample code using the UTL_FILE package:

DECLARE
  string1 VARCHAR2(32767);
  file1 UTL_FILE.FILE_TYPE;
BEGIN
--  file1 := UTL_FILE.FOPEN('TEMP_DIR','log_file_test','A'); -- open in append mode
  file1 := UTL_FILE.FOPEN('/usr/tmp','log_file_test','A'); -- open in append mode
  string1 := TO_CHAR(SYSDATE) || ' UTL_FILE test';
  UTL_FILE.PUT_LINE(file1, string1); -- write a string to the file
  UTL_FILE.FFLUSH(file1);
  UTL_FILE.FCLOSE_ALL; -- close all open files
END;
/

[amazon asin=0596514468&template=iframe image&chan=default]    [amazon asin=0137142838&template=iframe image&chan=default]    [amazon asin=0071614214&template=iframe image&chan=default]

Resolving Yellow Bar Issue

Problem: When the Oracle Application BRAVO instance is loaded, the ‘yellow bar’ appears when the forms are loaded.

Solutions:

1. Refer to Metalink Doc ID: 162488.1, “Section 6: Troubleshooting and those Yellow Warning Bars”

Navigate to Start > All Programs > JInitiator Control Panel 1.1.8.16

Check “Show Java Console”

Exit and reload BRAVO instance.

Java Console shows no errors.

Try:

(a) Uninstall Jinitiator and clear browser cache

(b) Log back into Applications to get the new plugin, (oajinit.exe) including the new identitydb.obj

(c) Install the Jinitiator on the Client PC and then Log into the Oracle Applications to download the new signed JAR files

IE Tools > Internet Options > Security

Trusted > Custom Level

Download unsigned ActiveX controls: Prompt

Automatic Prompting for File Downloads: Enable

Had to copy jinit11816.exe manually off the server and install on client

Try:

1. Source the environment and recreate certificate:

adjkey -initialize

2. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

3. Run adadmin and generate product jars (FORCE REGENERATION)

4. Then:

(a) Uninstall JInitiator, clear browser cache, and jcache

(b) Log back into Applications to get the new plugin, (oajinit.exe) including the new identitydb.obj

(c) Install the Jinitiator on the Client PC and then Log into the Oracle Applications to download the new signed JAR files

Rename C:Program FilesOracleidentitydb.obj

Then retry from step 4 above

Try:

1. Removed identitydb.obj from /home/applmgr

2.Source the environment and recreate certificate:

adjkey -initialize

3. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

4. Run adadmin and generate product jars (FORCE REGENERATION)

5. Then:

(a) Cleared browser cache

(b) Removed files from C:Documents and SettingsjeffersonbOracle Jar Cache

Try:

1. Copied identitydb.obj.20070703 to identitydb.obj in /home/applmgr

2. Repackage JInitiator:

adjbuild.sh /u0/bravo/bravocomn/util/jinitiator /u0/bravo/bravocomn/util/jinitiator/jinit11816.exe

3. Run adadmin and generate product jars (FORCE REGENERATION)

4. Then:

(a) Cleared browser cache

(b) Removed files from C:Documents and SettingsjeffersonbOracle Jar Cache

(c) Launched Oracle Applications and loaded form

Solution 1:

Copied $OA_HTML/oajinit.exe off the server and onto the client machine.

Unzip oajinit.exe in a directory and run adjbuild/jinit11816.exe.

The following solution worked:

Refer to:

Subject:  How to use,create and /or update Digital Certificates for 11i Applications

Doc ID:   Note:365735.1

How to share Digital Certificate across multiple instances

———————————————————-

1. Copy Associated Files

+ Copy from alpha to bravo the following files respectively:

a. ADCERT.txt (certificate directive file)

$APPL_TOP/admin/out/adcert.txt

b. ADSIGN.txt (used to pass arguments to JRI for signing JAR files.)

$APPL_TOP/admin/adsign.txt

c. APPLTOP.cer (Certificate file that gets imported into the identitydb.obj)

$APPL_TOP/admin/appltop.cer

d. OAJINIT.exe (Repackaged Jinitiator executable that includes identitydb.obj)

$OA_HTML/oajinit.exe

Note: It will not be necessary to repackage your JInitiator file oajinit.exe if you copy it over.

e. IDENTITYDB.obj (Identity Database File used to sign JAR files on the server)

$HOME/identitydb.obj

DO NOT repackage Jinitiator.

2. Regenerate JAR files on bravo

+ Run ADADMIN to Regenerate (sign) the JAR files on each middle tier

a. Launch ADADMIN (Ensure you are APPLMGR with permissions to write to adadmin.log)

b. Choose option number 1 to Generate Files, then 5 to regenerate JAR Files making sure to enter ‘yes for force regeneration, which will resign every JAR file using the new digital certificate that you just copied over from the alpha instance.

In Summary:

Started to get yellow bar:
1. Deleted C:Program FilesOracleidentitydb.obj
2. Deleted Profile Oracle Cache
3. Uninstalled all JInitiators, verified by checking C:Program FilesOracle
4. Manually reinstalled JInitiator (oajinit.exe) from november instance – yellow bar still appearing on logon
5. Tried regenerating JAR files using adadmin – completed with error
6. Regenerated certificate using adjkey -initialize, then reran adadmin to regenerate JAR files – yellow bar still appearing on logon
7. Cleared browser cache and jcache – C:Program FilesOracleJInitiator 1.1.8.16jcache – yellow bar still appearing on logon
8. Manually copied identitydb.obj from /home/applmgr to  C:Program FilesOracle – WORKING