controlfile creation

[Former Member]

Hi,

While creating a control file, I got the following error.

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01130: database file version 10.2.0.2.0 incompatible with ORACLE version 10.2.0.0.0

ORA-01110: data file 1:

'L:\BackupPR1-22Aug09\L\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

The version is same in source & target database.

Our Environment

SAP: 4.6C

Oracle: 10.2.0.2.0 x-64 bit

OS: windows 2003.

Can you please help me?

Thanks and Regards

Satya

[Former Member · Accepted solution]

have a look at [http://www.experts-exchange.com/Database/Oracle/Q_21907581.html]

[Former Member · Accepted solution]

Hi,

All the paths are exists as mentioned in control file.

"COMPATIBLE" parameter is same in both source and target database.

Manoj,

I am not able to check given url.

Thanks and Regards

Satya

[stefan_koehler · Accepted solution]

Hello Satya,

can you please perform the following steps and post the output.

--> Source database
shell> sqlplus / as sysdba
SQL> show parameter compatible
SQL> SELECT * FROM DBA_REGISTRY;

--> Target database
shell> sqlplus / as sysdba
SQL> startup nomount;
SQL> show parameter compatible

Regards

Stefan

[stefan_koehler]

Hello Satya,

is the oracle software the same on both (source and target)?

Also please check the parameter "COMPATIBLE" .. is it also the same on both database instances?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams028.htm#i1125496

Regards

Stefan

[markus_doehr2]

> ERROR at line 1:

> ORA-01503: CREATE CONTROLFILE failed

> ORA-01130: database file version 10.2.0.2.0 incompatible with ORACLE version 10.2.0.0.0

> ORA-01110: data file 1:

> 'L:\BackupPR1-22Aug09\L\ORACLE\TST\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Make sure all the paths for the (new) controlfiles are existing.

Markus