Oracle Apps DBA Blog

Wednesday, 13 December 2017

500 Internal Server Error Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the

Issue :

Login page gives error after bringing up apps service.
In Firefox, the EBS page https://ebsxxxxx.domain.com/OA_HTML/AppsLogin shows generic error
500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

Cause:

One of the oacore services was not coming (or) it takes more time to come up (or) it there is a intermittent on oacore service.

Yesterday issue was caused due to recent change in production applsyspub password and we havent updated the applsyspub password after application clone.

Fix:

1) Bring down the application services in cloned instance completely

2) change APPLSYSPUB's password in cloned instance

    1. Modify $CONTEXT_FILE (on each node) and put the new password in s_gwyuid_pass.
    2. $ FNDCPASS APPS/apps_PWD 0 Y SYSTEM/[system_pwd] ORACLE APPLSYSPUB New_PWD

        If it works, the Lxxxxxx.log shall say
        Working...
        Password is changed successfully for user APPLSYSPUB.
        AFPASSWD completed successfully. (PROGNAME=FNDCPASS)

    3. Run autoconfig.sh on apps node.

3) Bring up the application services and the issue is fixed now.:)

Monday, 27 November 2017

ORA-27101: shared memory realm does not exist

Error:

Oracle docs note this about ORA-27101:

ORA-27101: shared memory realm does not exist

Cause:

Unable to locate shared memory realm

Action:

Verify that the realm is accessible

Solution:

In Windows may be to start the Windows services.

[or]

To resolve this issue with ORA-27101, you should be sure that ORACLE_HOME and ORACLE_SID are correct, and ORACLE_HOME should not have trailing slash.

For checking on trailing trash:
$ echo $ORACLE_HOME
$ /app/oracle/11204/ << Incorrect

$ echo $ORACLE_HOME
$ /app/oracle/11204 << Correct

For ORACLE_SID:
$ echo $ORACLE_SID
$ ora817

$ ps -ef | grep smon
ora_smon_ORA817
(Here, ORACLE_SID setting has been altered from ora11204 to ORA11204.)

Basically, to resolve ORA-27101, Once ORACLE_HOME and ORACLE_SID are correct, and then attempt to start SQL*Plus.

Hope the fix helps you !!!!

Thursday, 23 November 2017

Oracle Forms objects did not generate successfully : ar forms/US ARXRWRCT.fmx and ARXRWMAI.fmx

Issue:-

while applying patch 23201078, we have found below Oracle Forms objects did not generate successfully in Non-Prod instance.

ar forms/US ARXRWRCT.fmx

ar forms/US ARXRWMAI.fmx

Cause:-

Issue was caused due to below error, which we found in worker log. Oracle suggest to apply R12.AR.B: Patch 18370021 to fix the issue.

FRM-30064: Unable to parse statement select distinct c.cust_account_id ,

arp_etax_util.get_taxpayer_masked_value(party.jgzz_fiscal_code) jgzz_fiscal_code,

substrb(party.party_name,1,50) party_name,

c.account_number,

arp_etax_util.get_taxpayer_masked_value(party.tax_reference) tax_reference ,

party.party_number,

party.party_id,

party.person_first_name,

party.person_last_name ,

c.account_name account_description

from hz_cust_accounts c,

hz_parties party

where c.party_id = party.party_id

order by party.jgzz_fiscal_code.

ORA-01791: not a SELECTed expression

Record Group RGW_FIND_TAXPAYER_ID

Form: ARXRWRCT

FRM-30085: Unable to adjust form for output.

Solution:-

To apply a Pre-requisites Patch 18370021: R12.AR.B

Note id : Several Patches Cause Forms ARXRWRCT.fmb and ARXRWMAI.fmb to Fail Generating with Following Error: "ORA-01791: not a SELECTed expression" (Doc ID 1931760.1)

Unable to locate 'linkxlC' utility in path

Issue:-

bash-3.2$ perl adcfgclone.pl appsTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.8

Enter the APPS password :

no linkxlC in /u01/oracle/DEV/apps/apps_st/comn/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin /usr/bin/X11 /sbin .

Checking for make... found - /usr/bin/make

Checking for ld... found - /usr/bin/ld

Checking for linkxlC...

Unable to locate 'linkxlC' utility in path

Checking for ar... found - /usr/bin/ar

Unable to locate all utilities with system path.

PATH = /u01/oracle/DEV/apps/apps_st/comn/clone/bin/../jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.

WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above

Solution:-

bash-3.2$ export PATH=/usr/vacpp/bin:$PATH

You have mail in /usr/spool/mail/oracle

bash-3.2$ perl adcfgclone.pl appsTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Running:

/u01/oracle/DEV/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oracle/DEV/apps/apps_st/comn/clone/jlib/java:/u01/oracle/DEV/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/oracle/DEV/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/oracle/DEV/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_15925276.lst -stage /u01/oracle/DEV/apps/apps_st/comn/clone 2> /tmp/adcfgclone_15925276.err; echo $? > /tmp/adcfgclone_15925276.res

Log file located at /u01/oracle/DEV/apps/apps_st/comn/clone/bin/CloneContext_0910112347.log

Hope your issue is fixed !!

Wednesday, 25 October 2017

opatch apply fails with “Error in checking for identical patches for composite patch” error

ERROR:

Attempting to install a composite patch fails with the following message

[Nov 22, 2014 11:36:08 AM] OUI-67073:UtilSession failed: Error in checking for identical patches for composite patch. This means a constituent to be applied has an earlier creation date than a constituent installed in the Oracle Home. This patch is improperly packaged and will not be applied.
[Nov 22, 2014 11:36:08 AM] Finishing UtilSession at Sat Nov 22 11:36:08 EST 2014
[Nov 22, 2014 11:36:08 AM] Log file location: /apps/opt/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-11-22_11-35-53AM_1.log
[Nov 22, 2014 11:36:08 AM]
[Nov 22, 2014 11:36:08 AM] StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:725)
[Nov 22, 2014 11:36:08 AM] StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[Nov 22, 2014 11:36:08 AM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Nov 22, 2014 11:36:08 AM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Nov 22, 2014 11:36:08 AM] StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Nov 22, 2014 11:36:08 AM] StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Nov 22, 2014 11:36:08 AM] StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
[Nov 22, 2014 11:36:08 AM] StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)
[Nov 22, 2014 11:36:08 AM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)

CAUSE:

The failure is because the downloaded patch is not for the platform on which it is being installed. For example, if the OS platform is Linux x86-64 and the downloaded patch is for Solaris SPARC, patching fails with the reported error rather than suggesting that the OS platform and the platform of the patch do not match.

SOLUTION:

Download the patch for the correct platform and install it by executing the following command

opatch apply

RMAN-05001: auxiliary filename /xxx/xxx/xx.dbf conflicts with a file used by the target database tips

Question: I am trying to clone a database using RMAN and I get the following RMAN-05001 error:
RMAN-05001: auxiliary filename /xxx/xxx/xx.dbf conflicts with a file used by the target tips.

Solution :

set dbfile convert and logfile concert parameter in init.ora and startup database in nomount and execute the rman script.