Advertisements

Category Archives: Oracle Apps DBA

ERROR: OPatch failed because of Inventory problem

I was trying to apply EBS R12 patch on ORACLE_HOME(10.1.2) application node and got the below issue because of inventory issue.

ERROR:

opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Cannot open the file: /etc/oraInst.loc
Please use -invPtrLoc option and specify the correct file for OPatch to look for central inventory.

ERROR: OPatch failed because of Inventory problem.

CAUSE:

The cause of the error is due to inventory pointer file /etc/oraInst.loc not present in the default location
In Oracle Applications Release 12.x , if oraInst.loc is not present in the default location it will be present in the following locations

Database Tier :

<RDBMS $ORACLE_HOME>/oraInst.loc
<RDBMS $ORACLE_HOME>/admin/oui/$CONTEXT_NAME/oraInst.loc

Applications Tier :

$INST_TOP/admin/oraInst.loc
$IAS_ORACLE_HOME/oraInst.loc
Tools $ORACLE_HOME/oraInst.loc

SOLUTION:

Please check if the file oraInst.loc is present in ORACLE_HOME to which the patch is being applied

opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

Run the patch as below
cd patch directory
opatch apply -invPtrLoc $ORACLE_HOME(10.1.2)/oraInst.loc

 

Thank You !!

Advertisements

FRM-92050: Failed to connect to the Server: /forms/servlet:- 1

Facing below issue when attempt to log into forms EBS R12

ERROR:

FRM-92050: Failed to connect to the Server: /forms/servlet:- 1

Details…
Java Exception:
java.io.IOException: Negative content-length from http://hostname.domainname:port/forms/frmservlet?

FRM-92050

CAUSE:

Internet Explorer settings are not correct.

SOLUTION:

1)      Open Internet Explorer => Go to “Tools” => Click on “Internet Options” => Click on “Security” Tab

2)      Select “Internet” under => Set “Security level for this zone” to “Medium”.

3)      Select “Local intranet” under => Set “Security level for this zone” to “Medium-low” => Click on “Sites” for “Local intranet” => Click on    “Advanced” => Add the Instance URL. => Click on “Close” => Click on “Ok”.

4)     Retest the issue.

IE_SETTING

 

Thank You !!

 

 

ADCTRL – SKIPPING A WORKER

Sometimes we need to skip the worker via adctrl then we can use the below steps to do the same.

  • Run adctrl utility
  • We can only see option till 7 in the main menu. But there is an 8th option that is hidden.
  • Use option 8 to skip a failed worker. Enter 8 and the worker will be skipped.

AD Controller Menu
—————————————————

1.    Show worker status
2.    Tell worker to restart a failed job
3.    Tell worker to quit
4.    Tell manager that a worker failed its job
5.    Tell manager that a worker acknowledges quit
6.    Restart a worker on the current machine
7.    Exit

Enter your choice [1] : 8

 

Thank You !!

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

PROBLEM:

Encounter the following error when running autoconfig on the Application  Tier.

ERROR:

Updating s_tnsmode to ‘generateTNS’
UpdateContext exited with status: 0
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END
.end std out.

SOLUTION:

There is no information in the table FND_NODES for the database node. Which means that autoconfig has not executed on the Database Tier.
First need to run autoconfig on the database tier to populate the database node values in FND_NODES table then run autoconfig on Application Tier.

please execute the following steps:

1. Loging to as oracle user and perform the below steps
sqlplus apps/$apps
exec fnd_conc_clone.setup_clean

2. Run autoconfig.sh on db node.

3. Run autocnfig.sh on apps node.

Thank You !!

Recommended Browsers for Oracle E-Business Suite Release 12

Recommended Browsers for EBS R12 and any issues related to browsers, Please go through with below Oracle recommended document.

ORACLE DOCUMENT: Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

Thank You !!

Unable to authenticate session – EBS R12

EBS logon is failing with following error:

“Unable to Authenticate Session”

SOLUTION 1:

1. Clear the Browser cache.
2. Stop all Browser sessions.
3. Start a new Browser session and logon to the Instance.

Go to Tools >Internet Options > Click on delete browsing Cache (shown below)

ie_cache

SOLUTION 2:

Oracle E-Business Suite environment with IE8 and higher, When you are now logging out from your DEV Instance and want to login to the TEST- or PROD-Instance it happens “Unable to authenticate session”

Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging (shown below)

1)  Start -> Program Files
2)  Right click on the Internet Explorer icon and select Properties
3)  Add -nomerge to the end of the link in the Target field i.e.
“C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging
4)  Click the OK button to close the window
5)  This icon may then be copied to the desktop if desired.

ie_properties

Thank You !!

Could not reserve record (2 tries). Keep trying?

When attempting to reset User password (Security / User / Define form) in R12, the following error occurs.

ERROR:

“Could not reserve record (2 tries). Keep trying?”

CAUSE:

Seams that it was there a deadlock to a session.

SOLUTION:

1. The session that has a deadlock should be killed
Or
2. Bounce the application including database.

Thank You !!

How to compile forms in 11i

we have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i, But this is deprecated in R12 and we need to use frmcmp(Form Compiler)  to compile forms,menus,PL/SQL libraries.

1) Login to application server.

2) Go to the directory $AU_TOP/forms/US

3) Place “.fmb” file in binary mode

4) Execute the below “f60gen” command to generate “.fmx”.

f60gen module=<formname>.fmb userid=apps/<apps_passwd> output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EXAMPLE:

f60gen module=$AU_TOP/forms/US/APXSUMBA.fmb userid=apps/appspasswd output_file=$PROD_TOP/forms/US/APXSUMBA.fmx module_type=form  batch=no compile_all=special

Thank You !!

 

How to compile forms in R12

we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.

1) Login to application server.

2) Go to the directory $AU_TOP/forms/US

3) Place “.fmb” file in binary mode

4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EXAMPLE:

frmcmp_batch userid=apps/apps module=RCVRCERC.fmb output_file=$AU_TOP/forms/US/RCVRCERC.fmx module_type=form batch=no compile_all=special

Thank You !!

REP-0004: Warning: Unable to open user preference file

Symptoms:

All concurrent requests that run REPORTS are printing the following warning in the request log.

“REP-0004: Warning: Unable to open user preference file”
Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.

The possible causes of this error include the following:

CAUSE 1: The file was not found under the specified name in the specified location
CAUSE 2: You lacked the necessary privileges to open the file.

SOLUTION [ID 1120529.1] :

To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.

Example:

Copy of the file prefs.ora in the directory /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory  /home/applprod/
Thank You !!