In this post I will explain How to Delete&Purge Audit Trail Table.

Auditing is the monitoring and collection of some user database actions and record these data in some tables. Auditing is always enabled. Oracle Database generates audit records during or after the execution phase of the audited SQL statements. But AUD$ table will growth and will impact the performance of database.

The AUD$ table is used for the database auditing purpose (CREATE SESSION, LOGON, LOGOFF, SELECT, INSERT, DELETE) when AUDIT_TRAIL is set to either DB or DB_EXTENDED value. From 11g forwards AUDIT_TRAIL is activated by default and it is set to DB.

Yazının devamını oku »

I faced with that error during export process on Oracle 12c RAC database

Complete error message is:

ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(‘INDEX_NAME_HERE’,’SCHEMA_NAME_HERE’,’TEXTINDEXMETHODS’,’CTXSYS’,12.01.00.02.00,newblock,0) ORA-20000: Oracle Text error: DRG-10502: index SCHEMA_NAME_HERE”.”INDEX_NAME_HERE does not exist ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 274 ORA-06512: at line 1 ORA-06512: at “SYS.DBMS_METADATA”, line 9524

Yazının devamını oku »

I face with that error message on AIX 7.1 which is hosting our Oracle 18c database.

While i try to open any documents by using vi editor, it gives below error but the actual operation is not affected

$ vi initprod.ora
History file has no read permission. [Hit return to continue]

Yazının devamını oku »

Introduction

As you know Adobe ended support for Flash at the end of 2020.

However, late last year Adobe announced that they had actually implemented a ‘kill switch’ that would cause existing installs of Flash to simply stop working entirely on 12th of Jan 2021.

As of today (22th Jan 2021) anyone trying to use Oracle Enterprise Manager (aka OEM) will see the following icon:

So How to fix it

Yazının devamını oku »

I hit this error message during taking rman hot backup on one of my databases.

Complete Error message is:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 21/12/2020 10:30:41
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 5487325853476 bytes disk space from 37418520 limit

Actullay error is already say what wrongs. Its related to usage or limit of FRA area.

Here is the solution steps:

Yazının devamını oku »

I face with that error on 19c version on Windows operating system. Alertlog has below error messages:

ORA-27300: OS system dependent operation:write failed with status: 5
ORA-27301: OS failure message: Access is denied.
ORA-27302: failure occurred at: sskgmsmr_11

After investigate issue I have found below explanations

Yazının devamını oku »

If you have RAC system you need to verify your information is correct on configuration files.

To can see it run below command as oracle user

[oracle@Node1~]$ emca -config dbcontrol db -repos create -cluster

As you can see we need to change it

Yazının devamını oku »

I faced with that issue on while I recreated repo on 11.2.0.4 RAC system.

My step is:

[oracle@node1~]$ emca -config dbcontrol db -repos create -cluster <<<<< Enter the related information

After related steps done the login to the database Console works fine. The Target is shown as UP but the ‘host cpu’ section in the shows:

The host cpu chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

– The ‘Active Sessions’ section shows

The Active Sessions chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

Even I try drop and recreate repos but still hitting same issue
emca -deconfig dbcontrol db -repos create -cluster  <<< for drop
emca -deconfig dbcontrol db -repos drop -cluster    <<< for recreate
Yazının devamını oku »

I face with this error on Oracle19c database. My user has sysdba and also dba grant with create any trigger privilege.

Complete message is:

conn myuser/mypass@DB_SID

SQL> create or replace trigger xxxx
begin
null;
end;
create or replace trigger xxxx
*
ERROR at line 1:
ORA-01031: insufficient privileges

Yazının devamını oku »

I faced with that error during 19c standalone installation on linux.

In Grid Installation step I get below error:

INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: Configuring HA resource failed.
INFO: [Nov 17, 2020 12:05:21 PM] PRCR-1079 : Failed to start resource ora.asm
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: PRCR-1079 : Failed to start resource ora.asm
INFO: [Nov 17, 2020 12:05:21 PM] CRS-2674: Start of 'ora.LISTENER.lsnr' on 'veridatait' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-2674: Start of 'ora.LISTENER.lsnr' on 'nodename' failed
INFO: [Nov 17, 2020 12:05:21 PM] CRS-5017: The resource action "ora.asm start" encountered the following error:
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-5017: The resource action "ora.asm start" encountered the following error:
INFO: [Nov 17, 2020 12:05:21 PM] ORA-00845: MEMORY_TARGET not supported on this system
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: ORA-00845: MEMORY_TARGET not supported on this system
INFO: [Nov 17, 2020 12:05:21 PM] . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/nodename/crs/trace/ohasd_oraagent_oracle.trc".
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/nodename/crs/trace/ohasd_oraagent_oracle.trc".
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line:
INFO: [Nov 17, 2020 12:05:21 PM] CRS-2674: Start of 'ora.asm' on 'veridatait' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-2674: Start of 'ora.asm' on 'nodename' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line:
INFO: [Nov 17, 2020 12:05:21 PM] Completed Plugin named: asmca
Yazının devamını oku »