Category Archives: 11i - Page 6

Version of OUI too low (Cloning)

Posted by on September 21, 2008 No comments

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

Posted by on September 20, 2008 No comments

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

Posted by on September 19, 2008 No comments

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

Export Function Not Working

Posted by on September 19, 2008 No comments

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

Posted by on September 19, 2008 No comments

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

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

Configuring NFS to copy files

Posted by on September 18, 2008 No comments

Configuring NFS to copy database files from PROD to TEST (Cloning)

Problem:

Need to configure NFS to copy files from PROD to TEST.

Solution:

On ebusinesstest (TEST) server, use the NFS tool to create the /etc/exports file with the following data:

/u0/oracle/testdata      *(rw,sync)

On ebusiness (PROD) server, log on as the root user and mount the exported directory:

mkdir /mnt/tempdata

mount -t nfs ebusinesstest:/u0/oracle/testdata /mnt/testdata/

oraInst.loc points to an Inventory that does not exist (Cloning)

Posted by on September 17, 2008 No comments

Problem:

/etc/oraInst.loc points to an Inventory that does not exist:

mkdir : No such file or directory at ./adclone.pl line 1274

ERROR: Failed to execute ./adclone.pl

Solution:

As root user, ran /tmp/orainstRoot.sh.

Reran clone again, but it failed.

The root directory had completely filled up because the backup was restored to /oracle and not /u0/oracle. Removed /oracle, then reran /tmp/orainstRoot.sh and tried script again.

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