OraFAQ Forum: Server Administration » ORA 01503 create controlfile failed

Home » RDBMS Server » Server Administration » ORA 01503 create controlfile failed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA 01503 create controlfile failed [message #362133]

Mon, 01 December 2008 03:12

abdulaziz
Messages: 102
Registered: May 2008
Location: Douala

Senior Member

Hello,

I saw a similar thread here but a solution wasn't given. Well here's my situation:

This morning I was to create a new database on our server. I used the dbca and a template that was created for a previous database. Midway of the database creation, I got the following error :

ORA 01503 Create controlfile failed. 
ORA 01130-database file version 10.2.0.2.0 incompatible with version 10.2.0.1.0
ORA 01110 Datafile 1 E:\oracle\oradata\meta4prod\system01.DBF

Here are the facts:

The original version of the first database was 10.2.0.1. That database was set as a template. Later on, it was upgraded to 10.2.0.3(I did the upgrade using the help of this forum), but the template remained.

Today when I was asked to create a new database, I used the dbca and the the first database, as a template. I think the problem comes from that, as that template may still be in lower version. So at some point I got the errors I described earlier.

Any tips for correcting them and going on with the creattion of my new database?

Report message to a moderator

Re: ORA 01503 create controlfile failed [message #362149 is a reply to message #362133]

Mon, 01 December 2008 03:37

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

You need to set the COMPATIBLE parameter to 10.2.0.2.0:

On the "memory configuration page", select
"all initialization parameters" and change COMPATIBLE to 10.2.0.2.0. When done you can proceed with the DB creation.

Best of luck!

Frank

Report message to a moderator

Re: ORA 01503 create controlfile failed [message #362162 is a reply to message #362149]

Mon, 01 December 2008 04:09

abdulaziz
Messages: 102
Registered: May 2008
Location: Douala

Senior Member

Thanks for the tip Frank, but I have a worry: When I enter

sqlplus /nolog

in the prompt, the banner shows me that my database version is 10.2.0.3. It's the same when I enter

select * from v$version

. So how comes that the ora 01130 mentions a version lower than the 10.2.0.3? Should I proceed as you suggested or rather set COMPATIBLE to 10.2.0.3?

Thanks in advance.

Report message to a moderator