This discussion is archived
3 Replies Latest reply: Aug 29, 2013 7:01 AM by Srini Chavali-Oracle RSS

Oracle Binary Files Overwritten

venkata_sudheer Newbie
Currently Being Moderated

Hi Team,

 

we have recently upgraded oracle database from 10.2.0.3 to 11.2.0.1 and from 11.2.0.1 to 11.2.0.2. I have created separate folder and then I installed 11.2.0.1 and then upgraded it to 11.2.0.1. as we all know that there is no patching from 11.2.0.2 onwards as it can be installed and upgraded. we used another folder for that.

 

I have taken cold backup while upgrading to 11.2.0.1. Now we have been asked to revert back to 10.2.0.3 as the tool is not supporting 11.2 version. when we tried to startup the database using cold backup, it was throwing error. when we checked the 11.2.0.1 Oracle_home/dbs and 10.2.0.3 o_h/dbs are pointing to same folder, also the o_h/bin is also pointing to same folder.

 

The sqlplus tool is pointing to 11.2.0.1 version, I'm guessing that during upgrade the 10g binary files were overwritten by 11.2.0.1 files. I have suggested the below points to my client

 

1) install 10.2.03 and start the database

2) move the backup to other server which has 10g binaries and restart the database.

 

please let me know do I have any other options?

 

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 28 16:56:18 2013

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area  534462464 bytes

Fixed Size                  2208496 bytes

Variable Size             163581200 bytes

Database Buffers          360710144 bytes

Redo Buffers                7962624 bytes

ORA-00201: control file version 11.1.0.0.0 incompatible with ORACLE version 10.2.0.3.0

 

Thanks and Regards

Venkata

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points