Month: June 2022

RMAN Backup Status

Leave a Comment / RMAN Backup status, Uncategorized / By

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

Leave a Comment / Useful Scripts / By

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;

Leave a Comment / FND_CP_GSM_IPC.GET_Message / By

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 

Leave a Comment / To Access Pdf file / By

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

Leave a Comment / Unable to connect to database / By

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.

Leave a Comment / OS utilities in the $PATH / By

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

How to Change Applications Passwords Using Applications Schema Password Change Utility

Leave a Comment / Apps Password Change / By

Applications Passwords Using Applications Schema Password Change Utility fndcpass apps password r12 What are the steps to change the APPS, APPLSYS, and APPS_NE password using FNDCPASS for E-Business Suite (EBS) 12.2? Whenever using FNDCPASS or AFPASSWD to change the APPS, APPLSYS, and APPS_NE password, one must also perform the following actions: Important:1.These steps must be …

How to Change Applications Passwords Using Applications Schema Password Change Utility Read More »

Create User & Assign Responsibility

Leave a Comment / CreateUser / By

Steps to create the user in Oracle Application: Log in to Oracle Application either as sysadmin or you should have sysadmin responsibility. Navigate to Sysadminstrator – > Security-> User-> Define This will open a formGive the Details of the user you want to create Details of User: Username: HRMSADMINPassword : Note: You have to enter …

Create User & Assign Responsibility Read More »