Tag Archives: 11i Troubleshooting - Page 2

File server could not verify its initialization parameters

Posted by on September 18, 2008 No comments

Problem:

After cloning Production to Test, Active Users report is run from System Administrator responsibility. When View Output is clicked, the following message appears:

ERROR

File server could not verify its initialization parameters

Solution:

In the 8.0.6/network/admin/<CONTEXT_NAME>/listener.ora file, open the file and search for APPLFSTT and delete it. Ensure that there are no spaces between semicolons.

For example:

Change:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSTT=PROD_806_BALANCE; PROD; PROD_BALANCE; PROD_FO,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

To:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

Exit the application, bounce the application tier services and then log back in.

References:

Metalink Doc ID: 662053.999

File server needs to be re-initialized

Posted by on September 18, 2008 No comments

Problem:

After cloning Illuminat Production to Test, Active Users report is run from System Administrator responsibility. When View Output is clicked, the following message appears:

ERROR

File server needs to be re-initialized

Solution:

In the 8.0.6/network/admin/<CONTEXT_NAME>/listener.ora file, open the file and search for APPLFSTT. Change the order of the service names so that the SID (PROD) appears first in the list and there are no spaces between semicolons.

For example:

Change:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSTT=PROD_806_BALANCE; PROD; PROD_BALANCE; PROD_FO,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

To:

( SID_DESC = ( SID_NAME = FNDFS  )

( ORACLE_HOME = /u0/oracle/prodora/8.0.6 )

( PROGRAM = /u0/oracle/prodappl/fnd/11.5.0/bin/FNDFS )

( envs=’EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,SHLIB_PATH=/usr/lib:/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/u0/oracle/prodora/8.0.6/lib,APPLFSTT=PROD;PROD_806_BALANCE;PROD_BALANCE;PROD_FO,APPLFSWD=/u0/oracle/prodappl/admin;/u0/oracle/prodcomn/temp;/u0/oracle/prodcomn/html/oam/nonUix/launchMode/restricted’ )

)

Then bounce the concurrent manager.

References:

Metalink Doc ID: 662053.999

sh: adchkutl.sh: command not found (Cloning)

Posted by on September 16, 2008 No comments

Problem:

When trying to clone Illuminat TEST database, the following error occurred:

sh: adchkutl.sh: command not found

Solution:

  1. Add the directory with the PERL executable to the path (added . to the path, so that #2 will not occur).
  2. Instead of:

perl adcfgclone.pl dbTier

Use:

perl ./adcfgclone.pl dbTier

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.

Error occurred while compiling application flexfields

Posted by on September 11, 2008 No comments

Problem:

While compiling flexfields using adadmin, the following message appears:

Deleting existing compiled flexfield information.
Compiling all application flexfields.
/u0/oracle/prodappl/fnd/11.5.0/bin/fdfcmp APPS/***** 0 Y
An error occurred while compiling application flexfields.
Continue as if it were successful [No] :

Solution:

Exit adadmin, and then recompile flexfields using adadmin once more.

Grants missing after applying patch 6502082

Posted by on September 7, 2008 No comments

Problem: The following error occurs when applying patch 6502082 for the second time:

AutoPatch error:

Your database is missing important grants on SYS objects.

To fix this:

1) Log on as the database server owner, and set your environment for maintaining your database server.  Create a directory called $ORACLE_HOME/appsutil/admin and copy $APPL_TOP/admin/adgrants.sql to that directory.

2) Connect to the database as the SYS user and run adgrants.sql passing the name of the schema containing FND tables. For example, if the schema that contains FND tables in your database is called APPLSYS, you would run adgrants.sql as follows:

$ cd $ORACLE_HOME/appsutil/admin

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> @adgrants.sql APPLSYS

Solution: Perform steps listed above

FAILED: file affurgol.sql on worker 1

Posted by on August 25, 2008 No comments

Problem: When applying patch, the following error appears:

ATTENTION: All workers either have failed or are waiting:
           FAILED: file affurgol.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checked log file /u0/oracle/testappl/admin/TEST/log/adwork001.log:

declare
*
ERROR at line 1:
ORA-01653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 2362205 in
tablespace APPLSYSD
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2380
ORA-06512: at line 55

Solution: Resize the next extent to 40K.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960  1.9351E+10           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE storage (next 40K);
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       40960           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE allocate extent;
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       65536           1         505           50          5

adpcpset.pls hangs applying patch 6502082

Posted by on August 22, 2008 No comments

Problem:

While applying patch 6502082, the patch hangs at the line:

Assigned: file adpcpset.pls on worker  1 for product ad  username APPLSYS.

Solution:

  1. Stop and restart database tier services (9.2.0 TNS Listener and database)
  2. Apply patch 3586394 (BRANCHED PATCH FOR BUG 3211492 (ADUTLRCMP.PLS) OVER 3242200 (ADHPCP))

The Parallel Compile step can take about 32 minutes to run.

Journal Wizard: Viewer application profile is not set.

Posted by on July 7, 2008 1 comment

Problem: When creating a document in Journal Wizard, an error is displayed: Viewer application profile is not set.

Solution: Set the ‘GL : Default Desktop Viewer’ to a value.

Step 1:        To reproduce the error:

  1. (N) General Ledger, Vision Operations (USA) > Journals > Launch Journal Wizard
  2. Click (B) Create Document

Viewer application profile is not set.

Step 2:        Open the Find System Profile Values form:

(N) System Administrator > Profile > System

Step 3:        Find the profile ‘GL : Default Desktop Viewer’.

Step 4:        Enter a value for the ‘GL : Default Desktop Viewer’, such as Excel 2000, Excel 2002, Excel 2003 or Excel 97.

Reference:

Metalink Doc ID:  Note:459431.1 (Subject:  Launch Journal Wizard Fails With Viewer Application Profile Is Not Set)

Troubleshooting instance after cloning

Posted by on May 29, 2008 No comments

Situation: After reinstalling Red Hat Enterprise Linux AS 4 on the server and restoring Oracle Applications, the instance is started.

Problem: When accessing page http://ebusiness.support.com:8001/oa_servlets/AppsLogin, the following error is encountered:

Internet Explorer cannot display the webpage

   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

   What you can try:
     Diagnose Connection Problems  

     More information 

This problem can be caused by a variety of issues, including: 

Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server (DNS) is not reachable.
The Domain Name Server (DNS) does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. 

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds 

Click the Favorites Center button , click Feeds, and then click the feed you want to view. 

To view recently visited webpages (might not work on all pages) 

Click Tools , and then click Work Offline.
Click the Favorites Center button , click History, and then click the page you want to view.

Solution: Apply patch 4198954. Create a directory 4198954, copy the patch into this directory and extract the patch (two RPMS and README). Install the RPMS using rpm -ivh … . The RPMS install without issue

Then reran patch 3830807. Relink Application files using adadmin, use all defaults for the relink (takes about ten minutes).
Did not work.

Updated /etc/hosts

Checked Apache logs

/u0/oracle/testora/iAS/Apache/Apache/logs/error_log
/u0/oracle/testora/iAS/Apache/Jserv/logs/mod_jserv.log

See Metalink Doc ID: Note: 231137.1 “Troubleshooting the Self Service Framework with Oracle Applications”

Search for: File does not exist: /oa_servlets/AppsLogin
See Metalink Doc ID: Note: 344379.1  “Subject:  File Not Found /oa_servlets/AppsLogin”

http://ebusiness.support.com:8001/pls/TEST/fnd_web.ping

http://ebusiness.support.com:8001/OA_HTML/US/ICXINDEX.htm

ftp /usr/java/j2sdk-1_3_1_11-linux-i586.rpm.bin from 200.65.1.86 into the /usr/java (make this directory if necessary)
chmod a+x j2sdk-1_3_1_11-linux-i586.rpm.bin
Unzips jdk-1.3.1_11.i586.rpm
rpm -ivh jdk-1.3.1_11.i586.rpm

SUCCESS! Page appears.