Tag Archives: Maintenance Mode

Responsibilities not appearing after patching

Posted by on September 12, 2008 No comments

Problem:

After logging on to the E-Business Suite PROD instance, all the responsibilities have disappeared.

Solution:

In adadmin, enable maintenance mode. Exit adadmin. Run adadmin again and disable maintenance mode.

Invalid responsibility running patch 3262159

Posted by on September 10, 2008 1 comment

Problem:

When running patch 3262159, the following message appears:

ATTENTION: All workers either have failed or are waiting:
FAILED: file FNDLIBR      on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked adwork001.log:
/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV &ui_apps SYSADMIN 'System Administrator' SYSADMIN
List of errors encountered:
.......................................................................
_ 1 _
Please enter a valid responsibility.  The responsibility System
Administrator does not exist or is not active.  Check that the correct
application short name is specified for your responsibility.
(ROUTINE=AFPSSC)
.......................................................................
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.

Solution:

In adctrl, used option 8 to skip the worker. Needed to disable, then enable maintenance mode. Then sourced the environment and ran:

/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV apps/apps SYSADMIN ‘System Administrator’ SYSADMIN

Reference:

Note 259319.1 – Adpatch Fails With Sysadmin Does Not Exist Or Not Active

11i Upgrade on Test Instance

Posted by on July 28, 2007 No comments
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

Patch List for Cloning 11i

Posted by on July 11, 2007 No comments
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

 

There Are No Applications Available For This Responsibility Message While Selecting Any Responsibility.

Posted by on November 15, 2006 No comments

Problem: After logging on to Oracle Applications, the message appears, “There are no applications available for this responsibility. Please click on a different responsibility link to display the list of available applications.”

Solution: Disable maintenance mode and bounce the Apache server.

Step 1:        Disable the Maintenance mode by setting the site-level value of APPS_MAINTENANCE_MODE profile option NORMAL. Or Use the AD Administration Utility to set Maintenance Mode in 11.5.10.

Step 2:        Bounce the Apache Web server. Adapcctl.sh

Refer to Metalink Note:287116.1 (Subject:  There Are No Applications Available For This Responsibility Message While Selecting Any Responsibility)

Enabling Maintenance Mode in SQL

Posted by on September 10, 2006 No comments

Problem: Show how to enable or disable maintenance mode from SQL.

Solution: Run adsetmmd.sql

Step 1: Set up the environment by running APPSORA.env:

. ./$APPL_TOP/APPSORA.env

Step 2: Change directory to $AD_TOP/patch/115/sql/:

cd $AD_TOP/patch/115/sql/

Step 3: Run the SQL script:

sqlplus apps/apps @adsetmmd.sql ENABLE | DISABLE

Step 4: Bounce the Apache Web listener. (adapcctl.sh)

See Metalink Note: 291901.1 (Subject:  Maintenance Mode – A New Feature in 11.5.10)