Privilage Analysis Basic 12cR2
Oracle 12c introduced the DBMS_PRIVILEGE_CAPTURE package, which allows you to track the privileges being used, making it much simpler to perform privilege analysis, which in turn allows you to revoke…
Read MoreHow to resolve the "The file could not be uploaded because file size is too large Issue" in OEM 12c
How to resolve the “The file could not be uploaded because file size is too large Issue” in OEM 12c Step 1: Copy the patch to the staging area. Ex:…
Read MoreRebuild the DATAPUMP utility in Internal Error situations
Rebuild the DATAPUMP utility in Internal Error situations Step1 : Run the Catproc.sql in affected database: SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql Step 2: Compile the invalid objects, if any SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql Step 3:…
Read MoreHow To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) for ASM
How To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) 1) This example was performed on an OEL 6.3 configuration: [grid@asmlnx2 ~]$ uname -a Linux asmlnx2 2.6.39-200.24.1.el6uek.x86_64 #1 SMP Sat…
Read MoreHow to find out the active sql details
column sid format 9999 column username format a12 column sql_text form a64 select a.sid,a.serial#,a.username,c.executions,status, b.sql_text from v$session a ,v$sqltext b ,v$sqlarea c where a.username is not null and status=’ACTIVE’ –and…
Read MoreScriprt For Finding Unusable Index :
This scripts using finding unusable index. SET VERIFY OFF LINESIZE 200 COLUMN owner FORMAT A30 COLUMN index_name FORMAT A30 COLUMN table_owner FORMAT A30 COLUMN table_name FORMAT A30 SELECT owner, …
Read MoreQuery showing unsuccessful logins for local users in E-Business Suite
set pagesize 1000 set linesize 200 select u.user_name, ful.user_id, to_char(attempt_time,’DD-MON-RRRR HH24:MI:SS’) attempt_time from fnd_unsuccessful_logins ful, fnd_user u where ful.user_id = u.user_id (+) order by attempt_time;
Read MoreAfter Clone Concurrent Managers not coming up
When cloned my DEV instance last time, I have an issue with concurrent manager not coming up using Finally decided to stop the concurrent manager using $ADMIN_SCRIPTS_HOME . adcmctl.sh stop…
Read MoreApex front end issue
ISSUE: After installing apex front end is not opening SOLUTION: This is because dispatchers parameter hasn’t set. STEPS: SQL> select value from v$parameter where name = ‘dispatchers’; VALUE ——————————————————————————– SQL>…
Read More