OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Upgrade of DB (Oracle, 9.2.0.1.0, Windows 2003/R2)

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

Upgrade of DB [message #585101]

Wed, 22 May 2013 03:08

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi,

Sorry for troubling you guys again. I have installed Oracle 9i and created the 9i database using DB Assist in 9i.

The files are created in this path:
E:\oracle\oradata\devl\ (in this devl folder all the database files are there).

I even copyied my previous version (8.1.7) of transaction datafiles into this folder.

Now I am using the DB Upgrade option after chosing the SID and oracle home as e:\oracle\ora92 when I press next it says

There are no release "9.2.0" database components in dtabase "devl" in the "e:\oracle\ora92" Oracle home that can be upgraded to Oracle Release "9.2". Select another db to upgrade.

I have only one db devl. What went wrong can anyone assist in this please? The db devl is already opened.

Report message to a moderator

Re: Upgrade of DB [message #585102 is a reply to message #585101]

Wed, 22 May 2013 03:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must not move your file to upgrade.
The database files must be in their original path during upgrade.
You may move them afterwards.

Regards
Michel

Report message to a moderator

Re: Upgrade of DB [message #585106 is a reply to message #585102]

Wed, 22 May 2013 03:49

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Dear Mr.Michel,

So you say that I should copy the files in e:\oracle\ora92\oradata directory. In fact when I created the db using db assist it created in e:\oracle\oradata\devl.

If I want to move to e:\oracle\ora92\oradata folder what need to do kindly help.

I know you should change the path in init parameter file and anyother place the path to be changed.

Report message to a moderator

Re: Upgrade of DB [message #585115 is a reply to message #585106]

Wed, 22 May 2013 04:55

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

So you say that I should copy the files in e:\oracle\ora92\oradata directory.

No, I said the opposite, you must leave them where they are.

Regards
Michel

Report message to a moderator

Re: Upgrade of DB [message #585196 is a reply to message #585115]

Wed, 22 May 2013 22:22

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Dear Mr.Michel,

When I created the DB (DEVL) using DB Assist the DB files where created in e:\oracle\oradata\devl folder. After all the DB files

were created I copied my old transaction datafiles into this folder

Volume in drive E is New Volume
Volume Serial Number is 0416-3418

Directory of E:\oracle\oradata\DEVL

05/23/2013 11:17 AM <DIR> .
05/23/2013 11:17 AM <DIR> ..
05/22/2013 02:07 PM <DIR> archive
05/23/2013 10:53 AM 1,871,872 CONTROL01.CTL
05/23/2013 10:53 AM 1,871,872 CONTROL02.CTL
05/23/2013 10:53 AM 1,871,872 CONTROL03.CTL
05/22/2013 03:47 PM 20,975,616 DRSYS01.DBF
05/22/2013 03:47 PM 152,702,976 EXAMPLE01.DBF
05/22/2013 03:47 PM 26,218,496 INDX01.DBF
05/22/2013 03:47 PM 20,975,616 ODM01.DBF
05/22/2013 03:47 PM 104,858,112 REDO01.LOG
05/22/2013 03:47 PM 104,858,112 REDO02.LOG
05/22/2013 03:47 PM 104,858,112 REDO03.LOG
05/23/2013 10:53 AM 448,434,176 SYSTEM01.DBF
05/22/2013 02:12 PM 97,521,664 TEMP01.DBF
05/22/2013 03:47 PM 10,489,856 TOOLS01.DBF
05/22/2013 03:47 PM 209,719,296 UNDOTBS01.DBF
05/22/2013 03:47 PM 26,218,496 USERS01.DBF
05/22/2013 03:47 PM 39,981,056 XDB01.DBF
23 File(s) 22,599,501,312 bytes
3 Dir(s) 74,829,045,760 bytes free

After the above files were created using DB Assist. I copied the following dbf's from old version 8i into this folder.

Volume in drive E is New Volume
Volume Serial Number is 0416-3418

Directory of E:\oracle\oradata\DEVL

05/23/2013 11:17 AM <DIR> .
05/23/2013 11:17 AM <DIR> ..
05/22/2013 01:23 PM 7,266,306,048 MPSU01.DBF
05/22/2013 01:23 PM 4,120,578,048 MPSU_I01.DBF
05/22/2013 01:23 PM 3,608,578,048 MSSU01.DBF
05/22/2013 01:23 PM 2,060,290,048 MSSU_I01.DBF
05/22/2013 01:23 PM 3,121,743,872 CSSU01.DBF
05/22/2013 01:23 PM 1,048,578,048 CSSU_I01.DBF

Now I am trying the DB Upgrade I am getting the error message which I told you yesterday. I hope now you would have got the full picture what I have done. Please kindly assist me.

Report message to a moderator

Re: Upgrade of DB [message #585198 is a reply to message #585196]

Wed, 22 May 2013 22:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If you can't open the 8i DB, no upgrade is possible.
Why are you upgrading from one obsolete version to a different obsolete version.
You do NOT need any V9 DB to exist prior to upgrading the V8 DB.
You only require the V9 software to exist.

Report message to a moderator

Re: Upgrade of DB [message #585199 is a reply to message #585198]

Wed, 22 May 2013 22:53

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi Blackswan,

I know both are obsolete version but I was instructed to do this first then to 10g/11g.

Let me explain you. I already installed Oracle 9i OEM in my server. After installing it I created the DB after creating the DB I copied my 8i dbfs along with 9i dbfs created.

Now I am doing the DB upgrade but cannot since getting the error msg. Any other way can you explain and help plesae.

Report message to a moderator

Re: Upgrade of DB [message #585200 is a reply to message #585199]

Wed, 22 May 2013 22:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If you can't open the 8i DB, no upgrade is possible.
You do NOT need any V9 DB to exist prior to upgrading the V8 DB.
You only require the V9 software to exist.
The system must have Oracle Inventory that know V8 software exists & where it resides.

Report message to a moderator

Re: Upgrade of DB [message #585201 is a reply to message #585200]

Wed, 22 May 2013 23:18

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi,

So you say I should install the 8i software also in this 9i and up the 8i DB first and then to 9i grade. Is it correct?

If yes then I should delete the 9i db which I have created and then bring up the 8i from the backup and then upgrade to 9i using upgrade assist.

Report message to a moderator

Re: Upgrade of DB [message #585202 is a reply to message #585201]

Wed, 22 May 2013 23:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> I should delete the 9i db which I have created and then bring up the 8i from the backup and then upgrade to 9i using upgrade assist.
YES!

Report message to a moderator

Re: Upgrade of DB [message #585910 is a reply to message #585202]

Thu, 30 May 2013 21:33

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi BlackSwan,

As you suggested I did the installation of 8i uploaded the DB and the installed the 9i in the same server and choose the DB Upgrade option to convert to 9i. It was going smooth but suddenly I got the following message

90 MB of free disk space is not available at "E:\ORACLE\oradata\DEVL" to create the "ODMA_RBS" tablespace for rollback undo mode during upgrade. Provide the required free space on the disk.

I have 70GB of free space in my E: drive. My old RBS has got 1GB of free space.

Report message to a moderator

Re: Upgrade of DB [message #585912 is a reply to message #585910]

Thu, 30 May 2013 21:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle is too dumb to lie.
I believe Oracle better reports reality than you.
What clues exist with alert_SID.log file?
I have no advice on what to do next other than below.
Consider to open your checkbook & submit Service Request to Oracle Support.

Report message to a moderator

Re: Upgrade of DB - attached Trace file [message #586151 is a reply to message #585101]

Tue, 04 June 2013 02:46

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Mr.Michel,

Sorry to trouble you again. I have attached the trace file but I am not able to trace out where the mistakes is in order to have smooth DB upgrade using DB Assist.

Please kindly help.

Attachment: trace.log
(Size: 14.78KB, Downloaded 1943 times)

Report message to a moderator

Re: Upgrade of DB - attached Trace file [message #586201 is a reply to message #586151]

Tue, 04 June 2013 08:01

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

The log file shows you do not have 90mb of free space on that filesystem. If you think it does, prove it to us.

Report message to a moderator

Previous Topic:	dba_audit_mgmt cleanup jobs dataguard
Next Topic:	SGA SIZE (Increase shared pool)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 19:06:06 CST 2025