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 […]
Category: ORA-ERRORS
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 […]
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 […]
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; […]
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 […]
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: […]
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 ##################################################### […]
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 […]
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 […]
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 […]