Current position:  Home > Default > Error While Control File Creation

Error While Control File Creation

Time:October 11
Advertisement
Hi Experts,
i'm trying to create control file but i'm getting following error.
SQL> CREATE CONTROLFILE
  2     SET DATABASE venk
  3     LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\venk\redo01_01.log',
  4                      'C:\oracle\product\10.2.0\oradata\venk\redo01_02.log'),
  5             GROUP 2 ('C:\oracle\product\10.2.0\oradata\venk\redo02_01.log',
  6                      'C:\oracle\product\10.2.0\oradata\venk\redo02_02.log'),
  7             GROUP 3 ('C:\oracle\product\10.2.0\oradata\venk\redo03_01.log',
  8                      'C:\oracle\product\10.2.0\oradata\venk\redo03_02.log')
  9     RESETLOGS
10     DATAFILE 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf' SIZE 3M,
11              'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs' SIZE 5M,
12              'C:\oracle\product\10.2.0\oradata\venk\users01.dbs' SIZE 5M,
13              'C:\oracle\product\10.2.0\oradata\venkemp01.dbs' SIZE 5M
14     MAXLOGFILES 50
15     MAXLOGMEMBERS 3
16     MAXLOGHISTORY 400
17     MAXDATAFILES 200
18     MAXINSTANCES 6
19     ARCHIVELOG;
CREATE CONTROLFILE
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 384 (blocks), but should match header 60160
ORA-01110: data file 1: 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf'
SQL>I'm search in google.
ORA-01163:
SIZE clause indicates string (blocks), but should match header string
Cause:      The size specified in bytes in the SIZE clause of the CREATE CONTROLFILE statement does not equate to the number of blocks recorded in the header.
Action:      Specify the correct filename and size ( in bytes ).But i don't know how to check the SIZE of header .. Pls Help
Advertisement
Thanks for your help.
@phaeus .. i really don't know enough or not ..i'm just learning in my own system.
@mseberg Now getting below error.
SQL> CREATE CONTROLFILE
  2     SET DATABASE venk
  3     LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\venk\redo01_01.log',
  4                      'C:\oracle\product\10.2.0\oradata\venk\redo01_02.log'),
  5             GROUP 2 ('C:\oracle\product\10.2.0\oradata\venk\redo02_01.log',
  6                      'C:\oracle\product\10.2.0\oradata\venk\redo02_02.log'),
  7             GROUP 3 ('C:\oracle\product\10.2.0\oradata\venk\redo03_01.log',
  8                      'C:\oracle\product\10.2.0\oradata\venk\redo03_02.log')
  9     RESETLOGS
10     DATAFILE 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf',
11              'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs',
12              'C:\oracle\product\10.2.0\oradata\venk\users01.dbs',
13              'C:\oracle\product\10.2.0\oradata\venkemp01.dbs'
14     MAXLOGFILES 50
15     MAXLOGMEMBERS 3
16     MAXLOGHISTORY 400
17     MAXDATAFILES 200
18     MAXINSTANCES 6
19     ARCHIVELOG;
CREATE CONTROLFILE
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>@orafad     Thanks for your link :) .i'm referring this link
http://docs.oracle.com/cd/E11882_01/server.112/e25494/control003.htm
any way pls help to resolve this issue . So that in future if this kind of issue came i can solve my self.

RC-50004: Fatal: Error occurred in ApplyDatabase:Control file creation fail

2015-10-11

Hi, During the clone of R12.1 instance, while running the post clone on the DB tier, i am getting the following error RC-50004: Fatal: Error occurred in ApplyDatabase:Control file creation failed. when i looked into the log file, i can find this Crea

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai

2015-10-11

Hi guys, I am cloning and EBS 12.1.3 from one server to another, and when Configuring the target system database server with ''perl adcfgclone.pl dbTier'', I am getting the following error: RC-50004: Fatal: Error occurred in ApplyDatabase: Control fi

Error encountered in Rapid clone (control file creation failed)

2015-10-11

hi all, i have 2- node ERP server running EBS 11.5.10 with database 9.2.0.5 and OS HP UX 11.11 while running perl adcfgclone.pl dbTier i encountered the following error Verifying correctness of adcrdbclone.sql RC-00115: Not able to read temp001.dbf R

RC-50004: Fatal: Error occurred in ApplyDatabase:  Control file creation failed  Cannot execute configure of database using RapidClone

2015-10-11

dear associates, linux version: red hat enterprise  linux 4.0. EBS version: 12.1.1 RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed Cannot execute configure of database using RapidClone RW-50010: Error: - script has retu

RC-50004: Fatal: Error occurred in ApplyDatabase:  Control file creation failed

2015-10-11

There's anyone ever get error like this? [[email protected] bin]$ ./adcfgclone.pl dbTier perl: warning: Setting locale failed. perl: warning: Please check that your locale settings:   LANGUAGE = (unset),   LC_ALL = (unset),   LC_CTYPE = "UTF-8",   LANG

Control file creation failed while installing ---------R12 release 3

2015-10-11

While installing R12 release 3 I am getting following error at the time of Step 2 0f 5 RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed Cannot execute configure of database using RapidClone following is summery of my ser

Perl adcfgclone.pl dbTier  fails on control file creation

2015-10-11

Hi Guys, Platform is : Linux 5 DB: 11.1.0.7 R12.1.1 I have a temp file that had been removed at the OS level.. on the source And I want to updated the control file regarding this so that it does not record this file any more. I am using rapid clone (

Error creating CONTROL FILE

2015-10-11

I have a problem while installing 9iAS R2 on RH LInux 8. When database configuration assistant starts during the installation of 9iAS infrastructure, it gives an error "Error creating CONTROL FILE" followed by many other errors. Please help me o

XML log: Error during temp file creation for LOB Objects

-0001-11-30

Hi All, I got this exception in the concurrent log file: [122010_100220171][][EXCEPTION] !!Error during temp file creation for LOB Objects [122010_100220172][][EXCEPTION] java.io.FileNotFoundException: null/xdo-dt-lob-1292864540169.tmp (No such file

Error in control file

2015-10-11

I think I originally posted this in the wrong area: When starting up my database, I get: ORA-00205: error in identifying controlfile, check alert log for more info The Alert log shows: ORA-00204: error in reading (block 1, # blocks 1) of controlfile

Strange Corrupt Block Error in Control File not in CONTROL_FILES

-0001-11-30

When in RMAN connected to the TARGET and CATALOG I issue a RESYNC CATALOG I get this error: RMAN> RESYNC CATALOG; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ========

Control file creation not needed!!!!!?????

2015-10-11

for changing the max datafiles in the control file... it is said that there is no need to create the control file instead we can create a tracefile of the control file and change the details and start the database with that perticular text file... so

SQL Loader tool for control file creation

-0001-11-30

We are planning to use SQL*Loader to move a lot of data from mainframe to Oracle 10g database. We will write the data in flat files and use SQL*Loader to load these files into tha database. There are more than 100 tables with lot of columns in each.

Rapid install gettin error when create control file

2015-10-11

hai all , i faced problem when im install fresh ebs R12 my environment : sun sparc 64 bit solaris 11 this occur when i try to install fresh R12 using rapidwiz , the error say ORA-00821: Specified value of sga_target 1024M is too small, needs to be at

12c Create Control File for Entire CDB (CDB-root + PDBs)

-0001-11-30

Hi, In 12c, I understand that there is a single redo log and a single control file for an entire CDB. My question is what datafiles should I use to create control file for the entire CDB. According to Managing Control Files, I suppose I should use al

AUDIT CREATE CONTROL FILE

-0001-11-30

Hai how to set audit for CREATE CONTROL FILE? 17:45:07 SQL> AUDIT CREATE CONTROL FILE; AUDIT CREATE CONTROL FILE ERROR at line 1: ORA-00969: missing ON keyword Whats the problem above statement?Hello; That sounds like an issue outside of Oracle ( OS?

Snapshot control file

2015-10-11

Hi, I am interested in time of snapshot control file creation. I have read that snapshot control file is created before the backup take the place. I have tried to take the simple rman>backup database command, but I have seen that snapshot control fil

ORA-00245: control file backup failed; target is likely on a local file sys

-0001-11-30

Hello, our RAC (Linux, 11.2.0.3.0) is rather new and we are still on gaining experiences with that system... When starting the backup with RMAN we are getting the following error: Starting Control File and SPFILE Autobackup at 04-JUL-12 RMAN-00571: =

Error in identifying control file

2015-10-11

I have successfully moved or cloned a database, but having problem with the controfile creation. Each time I run the create control file script and start the database, I get "ORA-00205: error in identifying control file". When I do "sho par