Monthly Archives: September 2008

Insufficient privileges for cloning

Problem:

When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:

You have insufficient privileges for the current operation. Please contact your System Administrator.

Solution:

Used URL:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.

In Metalink, searched for error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Checked document: Subject:  Troubleshooting Login (Doc ID:  Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”

In SQL*Plus, executed the following code:

select SESSION_COOKIE_DOMAIN from icx_parameters;

update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;

commit;

select SESSION_COOKIE_DOMAIN from icx_parameters;

Tested logon on ebusinesstest, working now.

Reference:

Subject:  Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID:  Note:177095.1)

TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Problem:

When running AutoConfig, it fails at 50% with the following error:

ERROR

ORA-12224: TNS:no listener

Solution:

Run the following, and then restart AutoConfig.

perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem

Reference:

Subject:  TNS Connectivity With Database Breaks After Running Autoconfig

Doc ID:  Note:377764.1

1020  unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

1021  . /u0/oracle/testappl/APPSTEST_ebusinesstest.env

1022  cd /u0/oracle/testora/iAS/appsoui/setup/

1023  perl OUIsetup.pl

1024  perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem

1025  cd /u0/oracle/testcomn/clone/bin/

1026  perl adcfgclone.pl appsTier

Version of OUI too low (Cloning)

Problem:

When rerunning adcfgclone.pl, the following error occurs:

ERROR: The version of the OUI found in /u0/oracle/testora/iAS/appsoui (2.1.0.17.0) is too low. Please make sure that you have applied the latest OUI patch required by Rapid Clone.

Restart adclone.pl after performing required corrections.

ERROR: Failed to execute adclone.pl

Solution:

Apply patch 5035661:

A. Applying the patch on the iAS $ORACLE_HOME:

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

1.Unzip the patch into the <iAS ORACLE_HOME> directory:

unzip -od <iAS ORACLE_HOME> p5035661_11i_<PLATFORM>.zip

ie: unzip -od /u01/oracle/prodora/iAS p5035661_11i_LINUX.zip

2.Source the Apps environment file :

On Unix/Linux, execute <APPL_TOP>/APPS<SID>_<hostname>.env

On Windows, execute <APPL_TOP>Envshell.cmd.

If the environment file is not available, please make sure the environment variable ‘APPL_TOP’ is set.

3.Change directory to the <iAS ORACLE_HOME>/appsoui/setup

4.Execute the perl script OUIsetup.pl:

perl OUIsetup.pl

NOTE:

In the case of a Multi-Node instance, the above process should be repeated on the <iAS ORACLE_HOME> of each Node.

unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

. /u0/oracle/testappl/APPSTEST_ebusinesstest.env

cd /u0/oracle/testora/iAS/appsoui/setup/

perl OUIsetup.pl

Error AC-50207 occurs while cloning

Problem:

When running adcfgclone.cfg on the Apps tier, it completes with the following error:

Running Rapid Clone with command:

perl adclone.pl java=../jre/1.3.1 mode=apply stage=/u0/oracle/testcomn/c lone/bin/.. component=appsTier method=CUSTOM appctxtg=/u0/oracle/testappl/admin/ TEST_ebusinesstest.xml  showProgress contextValidated=true

Beginning application tier Apply – Thu Sep 18 14:33:30 2008

Log file located at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTi er_09180233.log

–     50% completed

AC-50207: Fatal: Failed to execute one or more of the config tools during Contex t Value Management

Deactivating Context Value Management System.

Restored the Context file in :

/u0/oracle/testappl/admin/TEST_ebusinesstest.xml

Aborting the running of Context Value Management

Error occured before Context Value Management could be completed

|     50% completed       WARNING: AutoConfig completed with errors. Check log file at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233. log for details.

/u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233.log shows:

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution.  Errors are grouped by directory and phase.

The report format is:

<filename>  <phase>  <return code where appropriate>

[SETUP PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /u0/oracle/testcomn/admin/install/TEST_ebusinesstest

adgentopfile.sh         INSTE8_SETUP       1

AutoConfig is exiting with status 1

Solution:

Source the apps tier environment and run AutoConfig (/u0/oracle/testcomn/admin/scripts/TEST_ebusinesstest/adautocfg.sh)

Important 11i Files, Directories, Locations

This documentation lists important files, directories and locations.

Output for adadmin and adpatch:

$APPL_TOP/admin/<SID>/log

Output for concurrent requests:

$COMMON_TOP/admin/log/<CONTEXT_NAME>

$COMMON_TOP/admin/out/<CONTEXT_NAME>

Output files from installation:

Database logfile:

$ORACLE_HOME/appsutil/log/<CONTEXT_NAME>

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11060210.log

Appltop logfile:

$APPL_TOP/admin/<CONTEXT_NAME>/log

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running AutoConfig:

Database logfile:

<RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME> /<MMDDhhmm>/adconfig.log

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11160751adconfig.log

Appltop logfile:

<APPL_TOP>/admin/<CONTEXT_NAME>/log/<MMDDhhmm>

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running TUMS:

$COMMON_TOP/temp

Database context file:

<RDBMS ORACLE_HOME>/appsutil/<CONTEXT_NAME>.xml

e.g. C:oraclevasudb9.2.0appsutilVASU_localhost.xml

Application context file:

$APPL_TOP/admin/<CONTEXT_NAME>.xml

e.g. C:oraclevasuappladminVASU_localhost.xml

Concurrent manager log file:

$APPLCSF/$APPLLOG/SID_MMDD.mgr

JInitiator files:

$APPL_TOP/admin/appltop.cer

$APPL_TOP/admin/adsign.txt

$APPL_TOP/admin/adcert.txt

$HOME/identitydb.obj (/home/applmgr)

Launch Forms Logon:

http://<server>:<port>/dev60cgi/f60cgi

Launch Self Service Personal Home Page Mode (“Personal Home Page”):

http://<server>:<port>/OA_HTML/US/ICXINDEX.htm

Launch Self Service Personal Home Page Mode (“Framework only”):

http://<server>:<port>/oa_servlets/AppsLogin

Test your Webserver setup for Self Service Framework Applications:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

Running Oracle Configuration Manager

Download Oracle Configuration Manager from Metalink > Software Configuration Manager, and copy to the server.

ocm-Production-Linux-i386.zip

Note: source database tier environment file.

1. Unzip the Oracle Configuration Manager distribution file into the ORACLE_HOME directory as follows:

unzip -d $ORACLE_HOME ocm-Production-Linux-i386.zip

2. After the file has been unzipped, install and complete the configuration of Oracle Configuration Manager by entering the following command:

$ORACLE_HOME/ccr/bin/setupCCR -s  xxxxxxxx vasudev.seeram@emaildomain.com TT

where xxxxxxxx is your CSI number

3. To configure the database for configuration collection, run the following script:

$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s TEST -r sys -p syspassword

4. To configure an Oracle E-Business Suite, run the following script from the $ORACLE_HOME:

$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig -u apps -w appspassword -s TEST

5. To check status of Scheduler:

$ORACLE_HOME/ccr/bin/emCCR status

6. To start the Scheduler:

$ORACLE_HOME/ccr/bin/emCCR start

7. To manually collect data for the instance and upload it:

$ORACLE_HOME/ccr/bin/emCCR collect

Reference:

http://download.oracle.com/docs/cd/B19306_01/install.102/b28484/install.htm

Export Function Not Working

Steps to reconfigure exporting in Oracle Applications:

1. Set System Profile Options ‘Export: Mime type’ to ‘text/tab-separated-values’

2. Setup your browser and Windows Explorer with this new mime type (if using Internet Explorer) :

– start Windows Explorer
– choose menu Tools => Folder Options…
– click on ‘File Types’ tab
– click on ‘New’ button to add a new type: File Extension: tsv
– click on ‘Advanced’ button and complete with: Associated File Type:
‘Microsoft Office Excel Comma Separated File’ (select it from the list)
– enable ‘Automatic prompting for file downloads’ option from Internet
Explorer: menu Tools => Internet Options… Security tab => click on ‘Custom Level’ button => ‘Downloads’ section

Next, run the “Rebuild Help Search Index” concurrent program as follows:

1. Log into PROD
2. Choose the System Administrator responsibility
3. Navigate to Requests > Run
4. Choose “Single Request” and press “OK”
5. In the Name field choose the process “Rebuild Help Search Index”
6. A box with parameters will popup – leave the defaults and press “OK”
7. Press “Submit” to run the report
8. To view the progress of the process navigate to Requests > View and find all requests.

Unable to mount NFS share

Problem:

When mount -t nfs ebusinesstest:/u0/oracle/testdata /mnt/testdata/ executed, the following error is returned:

mount: mount to NFS server ‘ebusinesstest’ failed: RPC Error: Program not registered.

Solution:

Run:

service nfs restart

on source and target machines.

File server could not verify its initialization parameters

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

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