Posts Tagged ‘Oracle EBS’

Decoded INST_TOP Oracle R12 INSTANCE_HOME

June 13th, 2020, posted in Oracle
Share

 

Features on this R12 INST_TOP

-All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top

  • All configuration files have been moved to INST_TOP
    like
    DBc file
    All the http related config files
    appsweb.cfg
    All the start or stop scripts
    all the OC4J related config files

-we can now share the Apps and technology stack among multiple nodes and even instances (Dev,Test, Production) as all the log and config are located in this top.We will have INST_TOP for each context.

-Configuration and log files are co-located

-Easier collection of instance state
-Minimize disk usage and maximize performance

Filesystem look

/inst/apps/ ($INST_TOP)
/admin
/scripts ($ADMIN_SCRIPTS_HOME) All the start and stop are here
/appl ($APPL_CONFIG_HOME) All the apps env are here
/fnd/12.0.0/secure ($FND_SECURE) dbc file lis located here
/certs
/logs ($LOG_HOME) all the logs are located
/ora ($ORA_CONFIG_HOME)
/10.1.2
/10.1.3 ($ORACLE_CONFIG_HOME) all the techstack(oacore,forms) related config files
/pids
/portal
/rgf

Some more changes to variable

OA_HTML =$COMMON_TOP/webapps/oacore/html
JAVA_TOP=$COMMON_TOP/java/classes
AF_JLIB=$COMMON_TOP/java/lib
JAVA_BASE=$COMMON_TOP/java/

Advantage  of INST_TOP

-Clear distinction between the shared file system and the file system unique to an instance
-Ability to share code (Apps, technology stack) among multiple  nodes and even instances (Development ,Test, Production)
-Enables split ownership of applications and technology stack file systems
-Improves code safety by making shared file system read-only while not patching
-Configuration and log files are co-located
-Easier collection of instance state
-Ability to use network or local storage for various file system portions
-Minimize disk usage and maximize performance

R12.2 Changes

-R12.2 contains the Fusion Middleware 11g tech-stack. The logfile and configuration files is located in that Oracle Home

Concurrent Manager log/out files have been moved in Non editioned File system

Where to Put INST_TOP in shared file system

It is recommended to put INST_TOP on local filesystem  in shared APPL_TOP filesystem  architecture. This is because of the Apache mutex problem.Apache performance is highly sensitive to mutex file access latency, and at higher loads is also sensitive to I/Os per second. In case you have INST_TOP on shared filesystem, it is suggested to point these context variable to local file-system

s_lock_pid_dir
s_pids_dir
s_web_pid_file

 

 

Conclusion

Hope you like the post on R12 INST_TOP, all the advantages and R12.2 changes.  Please do provide the feedback.

 

 

Share

Query To Find Legal Entity Organization Company Code

February 3rd, 2020, posted in Oracle Queries
Share
SELECT
xep.legal_entity_id "Legal Entity ID",
xep.name "Legal Entity",
hr_outl.name "Organization Name",
hr_outl.organization_id "Organization ID",
hr_loc.location_id "Location ID",
hr_loc.country "Country Code",
hr_loc.location_code "Location Code",
glev.flex_segment_value "Company Code"
FROM
xle_entity_profiles xep,
xle_registrations reg,
--
hr_operating_units hou,
-- hr_all_organization_units hr_ou,
hr_all_organization_units_tl hr_outl,
hr_locations_all hr_loc,
--
gl_legal_entities_bsvs glev
WHERE
1=1
AND xep.transacting_entity_flag = 'Y'
AND xep.legal_entity_id = reg.source_id
AND reg.source_table = 'XLE_ENTITY_PROFILES'
AND reg.identifying_flag = 'Y'
AND xep.legal_entity_id = hou.default_legal_context_id
AND reg.location_id = hr_loc.location_id
AND xep.legal_entity_id = glev.legal_entity_id
--
-- AND hr_ou.organization_id = hou.business_group_id
AND hr_outl.organization_id = hou.organization_id
ORDER BY hr_outl.name


Share

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported

September 2nd, 2018, posted in Oracle, Solaris
Share

[orastg@eboso bin]$ perl adcfgclone.pl dbconfig /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml

                      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 Rapid Clone with command:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

Running:

perl /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl java=/clone/oracle/product/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/clone/oracle/product/11.2.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml showProgress contextValidated=false

APPS Password :

 Beginning dbconfig Apply – Fri May 17 01:37:14 2013

 /clone/oracle/product/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/clone/oracle/product/11.2.0/oui -classpath /clone/oracle/product/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/java:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/share.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyDatabase -e /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml -stage /clone/oracle/product/11.2.0/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /clone/oracle/product/11.2.0/appsutil/log/CLONE_ebso/ApplyDatabase_05170137.log

  |      0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again…

 ERROR while running Apply…

 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl

  Please check logfile.

[orastg@ebso bin]$


Summary 
During the post cloning steps at the dbTier of an E-Business Suite R12.1.3 i get the error:

RC-20200 Fatal: Could Not Find Unzip. At This Time Only Native UnZip 5.X is Supported

I check my unzip version:
$ unzip -version 
$ which uzip 
And i found out that i have Unzip version 6 !!

But at the source system i do have the version UnZip 5.52

Workaround: 
Copy from the source system the unzip version 5.52 and put it under target system:
/usr/bin/unzip 
/system_base_directory/db/tech_st/11.2.0/bin/unzip 

MyOracle Support offers a solution with a patch:
RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported [ID 1410514.1] 

Tip: 
After solving the issue with unzip and running again the dbTier post cloning steps you might get the error:

[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:
          

  [INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/install/PRODAR_ebsdbprd
      adcrdb.sh               INSTE8


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

The problem now is that the file:
/u01/saudi_arabia_ar/db/tech_st/11.2.0/appsutil/template/adcrdb.sh is Deleted from the first failed clone process.

Workaround:
Copy again all the template directory from the source system and put it to the “target” system.
Run again $ perl adcfgclone.pl dbTier

Share

Oracle EBS Query To Check FND Languages Installed in Oracle

June 26th, 2018, posted in Oracle Queries
Share

 

clear columns
set lines 180
set pages 50
col LANGUAGE_CODE for a15
col NLS_LANGUAGE for a20
col ISO_LANGUAGE for a15
col INSTALLED_FLAG for a15
SELECT LANGUAGE_CODE,NLS_LANGUAGE, ISO_LANGUAGE,INSTALLED_FLAG 
FROM APPS.FND_LANGUAGES 
WHERE INSTALLED_FLAG IN ('B','I');
Share

APP-PAY-06153 System Error Procedure INITFORMS at Step 1

February 18th, 2018, posted in Oracle
Share

Problem : 


APP-PAY-06153: System Error : Procedure INIT_FORMS at Step 1

Cause: The procedure INIT_FORMS has created an error at Step 1.

Action : Contact your system administrator quoting the procedure INIT_FORMS and Step 1.

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS


Solution :

Navigate : System Administrator->Profile->System

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Click find

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Assign Site: FA: Vision Operations

Save and close

Navigate:->Human Resource->Work Structure->Organization

APP-PAY-06153,System Error,Procedure INIT_FORMS at Step 1,Step 1,Oracle Appps Error,APP-PAY Error,APP PAY 06153,Oracle Administrator,Oracle Apps,Oracle Application,Oracle EBS,Oracle Apps DBA,Oracle DBA,the procedure INIT_FORMS

Form is opened

Share