Home » RDBMS Server » Server Administration » creating of DB from 8i to 9i - error message
creating of DB from 8i to 9i - error message [message #159870] Wed, 22 February 2006 00:36 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:21:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.