If you are using Autonomous Database on Oracle Cloud services you may need to import your on prime database’s data using some methods to cloud.  

Oracle Data Pump (AKA expdp, impdp) is one of the recommended way to move your existing schemas or data to migrate  Autonomous Database on cloud.

There are many useful parameters can be use during migration such as parallelism, encryption etc. Do not forget those parameters performance related with your server sources.

Yazının devamını oku »

If your primary has huge load or if there are huge gap on your standby, you may need to increase your apply rate on your standby database.
Do not forget your standby server’s CPU and Disk should be strong enough for this actions.

Here is the steps

Yazının devamını oku »

Hi friends… One of our 12.2 db we got below errors from alertlog:

ORA-00060: deadlock resolved; details in file /u01/app/oracle/diag/rdbms/db_name/DB_NAME/trace/DB_NAME_j001_10041.trc
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_56337″
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at “SYS.DBMS_SPACE”, line 2741
ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 716
ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 1164
ORA-06512: at “SYS.DBMS_HEAT_MAP”, line 228
ORA-06512: at “SYS.DBMS_SPACE”, line 2747

Yazının devamını oku »

You may hit this error on your standby database. I have 12c standalone database with dataguard setup.

We got ORA-01111, ORA-01110, ORA-01157 errors on standby database and apply has been stoped.

There are many reasons for a file being created as UNNAMED or MISSING in the standby database, including insufficient disk space on standby site (or) Improper parameter settings related to file management.

Yazının devamını oku »

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:

Yazının devamını oku »

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 »