ORA-01503: CREATE CONTROLFILE failed

i am working on a change request to increase the db_files parameter.
current setting :

 
db_files = 200
maxdatafiles = 200
version = 11.1.0.7.0

maxdatafiles is the hardlimit and db_files is the softlimit per oracle.
so i backup the control to trace , shutdown the DB and edit the init.ora parameter.

 
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 8017100800 bytes
Fixed Size                  2161072 bytes
Variable Size            4227860048 bytes
Database Buffers         3758096384 bytes
Redo Buffers               28983296 bytes

but when i create the controlfile getting the error below.

 
SQL> @createnewctl.sql
CREATE CONTROLFILE reuse DATABASE "PDTT" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
 ORA-01565: error in identifying file '/dbPDTT/db04/oradata/PDTT/system01.dbf'  <-- this file exist.
 ORA-27048: skgfifi: file header information is invalid

SQL> shutdown immediate;

what we did is.
shutdown the DB again and started without recreating the controlfile the only change is on init.ora.

 
SQL> startup mount;
ORACLE instance started.

Total System Global Area 8017100800 bytes
Fixed Size                  2161072 bytes
Variable Size            4227860048 bytes
Database Buffers         3758096384 bytes
Redo Buffers               28983296 bytes
Database mounted.
SQL> alter database open;

Database altered.

now, i tried adding new tablespace with one datafile.
on the alert log.

 
CREATE TABLESPACE users01 DATAFILE '/dbPDTT/db04/oradata/PDTT/users01_01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL AUTOALLOCATE
Expanded controlfile section 4 from 200 to 400 records
Requested to grow by 200 records; added 6 blocks of records
Completed: CREATE TABLESPACE users01 DATAFILE '/dbPDTT/db04/oradata/PDTT/users01_01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Oracle automatically adjusted the maxdatafiles parameter.

Thanks!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s