BEGIN DBMS_AUDIT_MGMT.init_cleanup( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, default_cleanup_interval => 12 /* hours */); END; / ERROR at line 1: ORA-46267: Insufficient space in 'SYSAUX' tablespace, cannot complete operation ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line…
Read MoreError ======= Errors IN EBS POST INSTALL:RW 50015 : HTTP SERVER NOT RESPONDING 19/09/22 22:21:26 Start process ————————— /u01/oracle/VIS/inst/apps/VIS_ebs/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd /u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot…
Read MoreUnknown fonts while installing oracle database Cause ===== Missing dejavu-lgc-sans-fonts or dejavu rpm Solution ======== Install dejavu-lgc-sans-fonts and then invoke the OUI. The below rpm’s helps the OUI to be…
Read MoreError ===== BEGIN * ERROR at line 1: ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_STATS”,…
Read MoreCOL TABLESPACE_NAME FOR A30 COL FILE_NAME FOR A70 COL SIZE_GB FOR 99999 COL USED_GB FOR 99999 COL FREE_GB FOR 99999 COL %_Used FOR A15 SELECT Substr(df.tablespace_name,1,25) “Tablespace_Name”, Substr(df.file_name,1,70) “File_Name”, Round(df.bytes/1024/1024/1024,2)…
Read MoreApex Location ============= /PROD/PROD2020/apex Linux version ============= [oracle@ip-172-31-25-66 ~]$ cat /etc/system-release Amazon Linux 2 cd /PROD/PROD2020/apex @apex_rest_config.sql --password Pass#123 Unlock Accounts =============== ALTER USER APEX_LISTENER IDENTIFIED BY Pass#123 ACCOUNT UNLOCK;…
Read MoreFIND ACL PRIVILEGES ==================== set pages 1000 lines 1000 col acl for a50 col principal for a20 col privilege for a20 col is_grant for a20 col invert for a20 col…
Read Morecol owner FOR a20 col segment_name FOR a40 SELECT S.owner “Owner”, Nvl(S.segment_name, ‘TABLE TOTAL SIZE’) “Segment_name”, Round(SUM(S.bytes) / 1024 / 1024 / 1024, 1) “Segment_size_GB” FROM dba_segments S WHERE S.segment_name…
Read More