Gather Schema Statistics

This concurrent program gathers the specified schema level statistics This program also creates histograms on the columns seeded in the FND_HISTOGRAM_COLS table For a detailed description of the procedure used by this concurrent program, see information on the GATHER_SCHEMA_STATS procedure Parameters Schema Name Schema for which statistics are to be gathered. Specify ALL for all …

Gather Schema Statistics Read More »

Oracle EBS 12.2.8 Step by Step Installation – Part 2

Oracle EBS 12.2.8 Step by Step Installation – Part 1 oracle ebs r12 multi node installation on linux The Multimode Installations the database and application services are different nodes or servers Before Running Rapidwiiz : The should be an X display working to support the GUI installation Verify the Sufficient space is available in the …

Oracle EBS 12.2.8 Step by Step Installation – Part 2 Read More »

Oracle EBS 12.2.8 Step by Step Installation – Part 1

In this article Oracle EBS (E-Business Suite 12.2.8) Fresh installation in Linux server and next few posts, I will give step by step installation of R12.2 System Requirements: Operating system: Linux X86-64 – OEL 7Memory:  8GBDB Storage  : 450GBApplication Storage: 450 GB Here I have installed multi-node installation the database and application service are distributed across …

Oracle EBS 12.2.8 Step by Step Installation – Part 1 Read More »

Creating a Custom Application in Oracle E-Business Suite Release 12.1.3 and 12.2

Custom applications are required if you are creating new forms, reports, and so on. Requirements and Defaults: The procedure described in this document should be performed on the run file system when there is no active patching cycle.Custom data and index tablespaces default to APPS_TS_TX_DATA and APPS_TS_TX_IDX respectively. First down the Application services, then after …

Creating a Custom Application in Oracle E-Business Suite Release 12.1.3 and 12.2 Read More »

RMAN Backup Status

RMAN Historical backup details: select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time, to_char(END_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time, elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Running status of the RMAN Backup : SQL> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND (SOFAR/TOTALWORK*100, 2) “% COMPLETE” FROM V$SESSION_LONGOPS WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND TOTALWORK! …

RMAN Backup Status Read More »

Useful sql scripts for Daily activities

Full Database Size: SELECT ROUND (SUM (used.bytes) / 1024 / 1024 / 1024) || ‘ GB’“Database Size”,ROUND (SUM (used.bytes) / 1024 / 1024 / 1024)ROUND (free.p / 1024 / 1024 / 1024)|| ‘ GB’ “Used space”,ROUND (free.p / 1024 / 1024 / 1024) || ‘ GB’ “Free space”FROM (SELECT bytes FROM v$datafile UNION ALLSELECT bytes …

Useful sql scripts for Daily activities Read More »

BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); END;

The below sessions are crucial and run for very long time. Upon verifying the live sessions in the instance, it can be seen those have run for months: Those are internal concurrent program api calls used by the GSM for internal process communication to check the status of the different GSM component statuses. They should …

BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); END; Read More »

To Acess A Custom PDF File In R12.2 EBS 

Source the application[applmgr@preprdapp TESTPROD]$ . EBSapps.env E-Business Suite Environment Information RUN File System : /preapp/TESTPROD/fs1/EBSapps/applPATCH File System : /preapp/TESTPROD/fs2/EBSapps/applNon-Editioned File System : /preapp/TESTPROD/fs_ne DB Host: preproddb.xxx.com Service/SID: TESTPROD E-Business Suite Environment Setting Enter [R/r] for sourcing Run File System Environment file, or Enter [P/p] for sourcing Patch File System Environment file, or Enter anything else …

To Acess A Custom PDF File In R12.2 EBS  Read More »

Cloning Error – DB server -WARNING: RC-40201: Unable to connect to Database

perl adcfgclone.pl dbTier Problem Summary Cloning Error – DB server -WARNING: RC-40201: Unable to connect to Database Problem Description ——————-ADX Database Utility Finished————— conn is nullWARNING: RC-40201: Unable to connect to Database TESTPROD. StackTrace:java.lang.Exception: Cannot connect to database using DBUtilat oracle.apps.ad.clone.ApplyDatabase.checkDBConnection(ApplyDatabase.java:3363)at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:569)at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:502)at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:393)at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:116)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at java.lang.reflect.Constructor.newInstance(Unknown Source)at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)at …

Cloning Error – DB server -WARNING: RC-40201: Unable to connect to Database Read More »

Application Cloning – got Error WARNING: Could not find all the required OS utilities in the $PATH.

[applmgr@ebs-app bin]$ perl adcfgclone.pl appsTier dualfs Copyright (c) 2002, 2015 Oracle CorporationRedwood Shores, California, USA Oracle E-Business Suite Rapid Clone Version 12.2 adcfgclone Version 120.63.12020000.65 Enter the APPS password : Enter the Weblogic AdminServer password : Do you want to add a node (yes/no) [no] : sh: /tmp/adchkutl_27514.out: Permission deniedsh: /tmp/adchkutl_27514.res: Permission denied WARNING: Could …

Application Cloning – got Error WARNING: Could not find all the required OS utilities in the $PATH. Read More »