Well that is one way of migrating a database that I had never considered :).
If you have already created a 8.1.7 instance with empty datafiles etc I think the easiest way is to export the full database from 8.1.6 and import it into the 8.1.7 instance.
Otherwise start it up with Oracle_Home set to 8.1.7 and run the upgrade scripts. Check the documentation out but they will be something like U000816.sql etc. Really you need to follow the documentation and take 1 approach to upgrading rather than a mix & match approach
John
-----Original Message-----
From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 13:20
To: Multiple recipients of list ORACLE-L
Subject: ora 24314 service handle not initialized
Hello all,
I was working with an 8.1.6 DB and I needed to migrate to 8.1.7. As I
was newbie (And i keep on being that) I copied all the files related
with the DB (control, dbf..). I created a new DB with the same name and
path as the 81.6 one and replaced its files with the one I saved
previously.
Maybe it´s a madness solution...
My problem now is that I get the 'ora 24314 service handle not
initialized' error. I have read something in metalink, note 122183.1,
just the point in which it sais 'If the ORACLE_HOME points to the 8.1.7
software yet the database
was created with 8.1.6 or 8.1.5, then this error can occur' is my
problem.
I don´t know how could I resolve it. Could somebody orient me? Or if you
think it´s impossible to recover, please, tell me?
A lot of thanks
**********************************************************************
This email and any attachments may be confidential and the subject of
legal professional privilege. Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**********************************************************************
