Re: Urgrent - Moving instances across machines - Help

I'm guessing so maybe someone can confirm this. You untarred control files from your Solaris running 7.3.2.1 but your new database is 7.3.3. The control files you copied from the Solaris have recorded the database version as 7.3.2.1 and thus are not the same. Query, why not just Export the entire database from the Solaris and then Import it into the new version? Is it extremely large?  

Krishnan Ranganathan wrote:
>
> Hi
>
> I have to move an oracle instance across machines. Following are the steps
> I have done.
> 1. I created a database instance on sun-solaris. The datafiles were placed
> in a directory /export/02/data. The oracle version installed on the sun is
> 7.3.2.1.
> 2. I took a tar backup of the data directory and moved it to a another
> server ( HP-UX )
> 3. I exploded the tar file under /export/02 on the new server. I copied the
> respective
> init(ORACLE_SID).ora and the config(ORACLE_SID).ora from the sun box to
> HP-UX
> box under the $ORACLE_HOME/dbs directory.
> 4. I set the env variable ORACLE_SID to the same instance id as the solaris
> one.
> 5. On starting the instance using the svrmgrl ( The oracle instance on the
> HP-UX ) is
> 7.3.3, i got the error :
> ora-00205 - Error in identifying the control file.The control file
> names are there and the file permisions are OK. I do not understand this ?
> 6. I commented those control files which were not being identified and
> restarted the instance. Now i get the error message :
> ora - 00201 : Control file version incompatible with oracle version.
>
> I have 3 control files , 2 of them came with the error, unable to identify
  Received on Wed Oct 01 1997 - 00:00:00 CDT