The Log files locations in Oracle EBS Release 12.1.3 and Oracle EBS R 12.2.4 are given below: 1.Instance startup and configuration Log files are located for INST_TOP in Oracle Release…
Read MoreIf you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following 1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name> 3. To ensure…
Read MoreIn the proces of upgrading from R12.1.3 to R12.2.4. I encountered an issue with autoconfig on database side Below is the excert from error log afdbprf.sh started at Mon May…
Read MoreCause: The ORA-609 error is thrown when a client connection of any kind failed to complete or aborted the connectionprocess before the server process was completely spawned.Beginning with 10gR2, a…
Read MoreSELECT blocks as BLOCKS_USED, empty_blocks FROM dba_tablesWHERE table_name=TNAME;SELECT chain_cnt AS CHAINED_BLOCKSFROM dba_tablesWHERE table_name=TNAME;SELECT COUNT(*) AS EXTENT_COUNTFROM dba_extentsWHERE segment_name=TNAME;
Read MoreSELECT A.*, Round(A.NUMBER_of_LOGS*B.AVG#/1024/1024) Daily_Avg_Mb FROM ( SELECT To_Char(First_Time,’YYYY-MM-DD’) DAY, Count(1) NUMBER_OF_LOGS, Min(RECID) MIN_RECID, Max(RECID) MAX_RECID FROM v$log_history GROUP BY To_Char(First_Time,’YYYY-MM-DD’) ORDER BY 1 DESC ) A, ( SELECT Avg(BYTES) AVG#,…
Read Moreselect os_username “O/S User”, /*Operating system username used.*/ username “User”, /*Oracle username of the account used.*/ terminal “Terminal”, …
Read MoreSELECT DECODE(referenced_type, ‘NON-EXISTENT’, ‘…..’, referenced_type) Type , referenced_owner,referenced_name Object, name referenced_by, owner, type, ‘ Referenced Link: ‘ || DECODE(referenced_link_name, null, ‘none’, referenced_link_name) r_link FROM dba_dependencies WHERE owner = upper(‘&schema’) ORDER…
Read MoreWe can accomplish this by creating a trigger. Please note that you disable this trigger after you done with your activity. Else it will fill up user dump destination, Script…
Read More1. Verify that the following System Requirements are available The Shared Pool has at least 96 MB of free space. The Java Pool has at least…
Read More