Home » RDBMS Server » Server Administration » ORA 01503 create controlfile failed
ORA 01503 create controlfile failed [message #362133] Mon, 01 December 2008 03:12 Go to next message
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?
Re: ORA 01503 create controlfile failed [message #362149 is a reply to message #362133] Mon, 01 December 2008 03:37 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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
Re: ORA 01503 create controlfile failed [message #362162 is a reply to message #362149] Mon, 01 December 2008 04:09 Go to previous messageGo to next message
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.
Re: ORA 01503 create controlfile failed [message #362172 is a reply to message #362162] Mon, 01 December 2008 04:36 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Your template's version is still stuck at 10.2.0.1.0. You need to change it in DBCA as per my post below.
A [message #362196 is a reply to message #362172] Mon, 01 December 2008 05:27 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Allright. I'll do that and post back here to let you know how it went.
Re: ORA 01503 create controlfile failed [message #362253 is a reply to message #362196] Mon, 01 December 2008 08:39 Go to previous message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Database created. It did work. Thank you.
Previous Topic: Undo Tablespace Full
Next Topic: Copy Schema
Goto Forum:
  


Current Time: Sun Dec 04 04:50:33 CST 2016

Total time taken to generate the page: 0.10537 seconds