OraFAQ Forum: Server Administration » creating of DB from 8i to 9i

Home » RDBMS Server » Server Administration » creating of DB from 8i to 9i - error message

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating of DB from 8i to 9i - error message [message #159870]

Wed, 22 February 2006 00:36

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Dear Experts,

I want to create a new database in 9i from my existing 8i datafiles. Let me explain how I did.
1. Created the DB instance using ORADIM
2. Copyied all the datafiles to the 9i server (after a proper shutdown in 8i).
3. Startup nomount
4. Created the controlfile using the datafiles.
5. It was asking for media recovery.
6. After giving the media recovery for all the datafiles and the database was altered.
7. Then I gave Alter Database Open, it was giving me error message ORA-1092:Oracle instance terminated, disconnection forced.

Can anyone help me regarding this. Did I miss any step?

Report message to a moderator

Re: creating of DB from 8i to 9i - error message [message #160515 is a reply to message #159870]

Mon, 27 February 2006 01:27

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

If you had a cold backup, why didn't you used Oracle 9i's database upgrade assistant?
Try performaing the steps againg using DBUA & update.

--Girish

Report message to a moderator

Re: creating of DB from 8i to 9i - error message [message #160597 is a reply to message #159870]

Mon, 27 February 2006 09:18

aciolac
Messages: 242
Registered: February 2006

Senior Member

There are a simple method - to make upgrade of database to the version 9i.

Report message to a moderator

Re: creating of DB from 8i to 9i - error message [message #160651 is a reply to message #160597]

Mon, 27 February 2006 22:03

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

aciolac wrote on Mon, 27 February 2006 20:48

There are a simple method - to make upgrade of database to the version 9i.

Is there anything really simpler than DBUA?? Can you name it?

Report message to a moderator

Re: creating of DB from 8i to 9i - error message [message #160682 is a reply to message #160651]

Tue, 28 February 2006 01:12

aciolac
Messages: 242
Registered: February 2006

Senior Member

I am not said that this is simpler than DBUA. I only said that upgrade of database is much more simpler than the method that author of this thread used to export his data from 8i database to 9i database. Methods, how will be performed upgrade are other question.

Report message to a moderator

Re: creating of DB from 8i to 9i - error message [message #160718 is a reply to message #160682]

Tue, 28 February 2006 03:22

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Oh! probably i misunderstood it.

Cheers Cool

Report message to a moderator

Previous Topic:	Database is not getting started automatically
Next Topic:	ORA-01031: insufficient privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 18:29:39 CDT 2025