You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

Oracle recommended using 3 control file for your database. We also need to duplicate our Control file due to do security issue.

In this post, I will try to explain how We can duplicate a control file when ASM is involved.

Read the rest of this entry »

You can download Oracle Database 19.3.0 on-prem for Linux now from the usual sources:

Read the rest of this entry »

I face with that error message on our 11.2.0.4 RAC database which is working on AIX Operating System.

I started to get ORA-00245: control file backup operation failed &RMAN-03009: failure of Control File and SPFILE Autobackup command on C1 channel xxx errors. I noticed that this error has appeared after I have been enabled block change tracking to can take Incremental backup on my system.

Read the rest of this entry »

You may hit ORA-01000 maximum open cursors exceeded in your daily life.

So what is a cursor? Why you are hitting this error? In this post let us see inside of this error.

Cursors in Oracle

A cursor is a temporary work area created in the system memory when a SQL statement is executed. It can hold more than one row but can process only one row at a time. A set of rows the cursor holds is called an active set. The cursor might be used for retrieving data on a row-by-row basis like a looping statement.

Read the rest of this entry »

One of Our database size almost 35T and We need to back up this system twice in a day. Because of the backup duration time(We are using 16 channel and full backup time almost 2,5 hours) That’s why We decided to pass the Cumulative Incremental backup strategy for this system.

We take Level 0(full) backup on weekend and We take Level 1 Cumulative Incremental backup during working days.

Read the rest of this entry »

I hit this issue while I was trying to rename table (or index) name on 11.2.0.4 database.

Symptoms is:

I use a simple command as following;

alter table [prev_tablename] rename to [last_tablename]

If We put into schema names to this command, We can deal with ORA-14047 error.

The error raises when I put the schema name in front of the last_tablename.

SQL> alter table hr.[prev_tablename] rename to hr.[last_tablename] >>>  Its give ORA-14047

Solution:

SQL> alter table hr.[prev_tablename] rename to [lasttable_name]

 

I faced with this error message on our 11g 2 Node  RAC database.

We have been enabled block change tracking to can take Inceremental backup. After this,  Instance 2 has been  reebot from our 2 node RAC system with ORA-00600: internal error code, arguments: [krccaub_2], [505], [40], [], [], [], [], [], [], [], [], [] error!

Read the rest of this entry »

I faced with that error on 11.2.0.1 two node RAC on AIX system with ASM. One of our instance reboot itself and database alert.log mention below errors:

 ORA-00600: internal error code, arguments: [kjbrref:pkey], [2630360], [481], [1113572], [0], [], [], [], [], [], [], []
 Incident details in: lms3_3211996_i4178879.trc
 Fri Feb 17 21:10:14 2019
 Trace dumping is performing id=[cdmp_20120217211014]
 Fri Feb 17 21:10:17 2019
 Sweep [inc][4178879]: completed
 Sweep [inc2][4178879]: completed

Read the rest of this entry »

We need to move one or more datafile from our tablespace to one location to another because of the disk space issue.

In this post, I try to explain how We can achieve this process with CP command of asmcmd utility via a demo

The database version is –> 11.2.0.4

The Operating System is –> Linux 6

Read the rest of this entry »

You may need to require to relink oracle binaries because of some number of our cases and also We may need to do it because of the solution given by Oracle support.

The following method will relink the Oracle executables.

Read the rest of this entry »