ORA-00245 (Snapshot Control File Configuration)

Beginning with 11.2.0.2, for any form of database control file backup operations, Oracle no longer acquires the controlfile enqueue lock. This change requires snapshot control file accessibility to all instances in a RAC database, in contrast to a single-instance database, to successfully complete a manual or auto control file backup operation. When the snapshot control file […]

Read More

ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

You may get this error while creating a tablespace in your environment. SQL> create tablespace test extent management local datafile size 40 G uniform size 256 K; create tablespace test extent management local datafile size 40 G uniform size 256 K * ERROR at line 1: ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 […]

Read More

Undo Segment is in Needs Recovery

Whenever we face any DBA interviews we have to go through some intersting topics interviewers ask. Undo Management is the most important part of DBA’s job responsibilities. This article will help you out to solve the issue when “Undo Segment is in Needs Recovery or Undo Segments are corrupted”    The database is shutdown and can’t […]

Read More

ORA-65179 PDB in Oracle 12c

While dropping the PDB, we receive the error like cannot keep datafiles for a pluggable database that is not unplugged. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB18C2 READ WRITE NO SQL> alter pluggable database PDB18C2 close; Pluggable database altered. SQL> drop pluggable database PDB18C2; […]

Read More

vipca error in Oracle RAC

Today we are going to learn about the error occurs in the Oracle RAC environment. Vipca is not opening new configuration window and is giving error [root@node2 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])] To resolve this issue Perform two steps [root@node2 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node2 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect [root@node2  […]

Read More

ORA-27300: OS system dependent operation

In this article, we are going to have a look at ” ORA-27300″. In this article, we are going to learn how to solve this error. Let’s have fun with ORA-27300 During the creation of a new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: […]

Read More

ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION

This is the post for the error “ORA-29702”. ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION Cause: An unexpected error occurred while performing a CGS operation.   Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors. ##################################################### ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##################################################### […]

Read More

RMAN-08137 on Primary Database although Archive Destination

This article is about RMAN-08137. We are going to learn how do we can solve this issue. Let’s have look at the steps to solve this issue. RMAN does not delete ArchiveLogs on Primary Database when the State of the Archive Destination to the Standby Database is set to ‘defer’. When trying to delete ArchiveLogs, this Error is […]

Read More

MONITORING ALERT LOG

Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup […]

Read More

ORA-01450: maximum key length (3215) exceeded

Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error. While we rebuild the index we face the problem. 06:19:09 [SYS][TEST]>> ALTER index TEST.IDX_NEW rebuild online; ALTER index […]

Read More