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 […]
Articles Tagged: Database
Redolog in Oracle
As DBA we are aware that Oracle is a mixture of CRD files. Now we are going to have look at Redolog. Let’s have a technical definition of Redolog. The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as […]
Controlfile in Oracle Database
Today we are going to have look at the most important element of the Oracle Databases.Being Oracle DBA we must have good knowledge about Controlfile. It plays an important role in Oracle Database. If something happens wrong with it we are not able to start our database. Let’s have some important knowledge about Controlfile. Whenever we […]
Control file recovery
Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile. Instance terminates on startup with ORA-00600: internal […]
How To Rename ASM Diskgroup With RAC Database
Below are the steps for renaming an ASM diskgroup with database files present inside for a running database. EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST. The database present inside the diskgroup is TESTDB2 . 1. Check configuration of the database: srvctl config database -d TESTDB2 srvctl config database -d […]
Steps to Apply Database Patch From OEM Cloud Control
Being a Core DBA we have deep knowledge about patching.On the internet we have lots of knowledge is available about patching.This patching is different from the normal one. In this article, we are going to have look on steps which use to Apply Database Patch From OEM Cloud Control. With help of OEM cloud control, […]