Re: Two Versions of Oracle / Common Database Access

hi karsten,

thanks for your reply.

Karsten Farell <kfarrell_at_medimpact.com> wrote in message news:<sjLi9.1189$%C1.32123946_at_newssvr13.news.prodigy.com>...
> I don't know if I'm interpreting your post correctly. If all you want to
> do is to use the 9.2.0 software to access the 9.0.1 database, I think
> you just have to change ORACLE_HOME.

this is exactly what i wish to do. however, just resetting the ORACLE_HOME variable (and all the others, for that matter) to the 9.2.0 version does not allow me to access my 9.0.1 databases. there must be something else i'm not doing. please note that all i have done was to install the 9.2.0 software, and that's it. i haven't done any kind of database creation under the 9.2.0 version whatsoever. i simply want to use the 9.2.0 to access the databases in 9.0.1 and eventually i will uninstall the 9.0.1.

> If you want to clone your database,
> so you have the same db running under each version, you can copy the db
> files.
>
> We're still running 8.1.7 here, so I don't know if the database
> structure changed between 9.0.1 and 9.2.0. However, I used to do
> something like this all the time with 8.1.x databases (to test data
> warehouse stuff). To quickly clone a database, all we did was copy the
> datafiles, logfiles, controlfiles, etc to the new host (or in your case,
> the new directory hierarchy).

perhaps you can tell me where the these files are located? if my database is called 'mydb', am i wrong to assume that these files are located under /opt/oracle/admin/mydb/? i have not found any version-dependent files under /opt/oracle/product/9.0.1/!

>
> You should be aware of one glitch with the above technique, however.
> Since the files are an exact duplicate of the original, you won't be
> able to use RMAN to manage backup/recovery of both databases (since the
> database ID - dbid - would be identical and RMAN doesn't like that).
>
> B. Kloppt wrote:
> > i started with version 9.0.1 and created a few databases that i now
> > want to use with the 9.2.0.
> > instead of using exp and imp to export the data out of the old and
> > import into the new, i would assume there would be an easier way.
> > since the database files seem to reside in their respective
> > directories under /opt/oracle/admin/, i don't see how they could be
> > version dependent.
> > how would i go about using the databases i created under 9.0.1 with
> > 9.2.0?

cheers! Received on Sun Sep 22 2002 - 07:07:22 CDT