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 !!!!

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

                     Copyright (c) 2002 Oracle Corporation

                       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

                     Copyright (c) 2002 Oracle Corporation

                        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 !!