Home » RDBMS Server » Server Administration » Upgrade of DB (Oracle, 9.2.0.1.0, Windows 2003/R2)
Upgrade of DB [message #585101] Wed, 22 May 2013 03:08 Go to next message
kumarvk
Messages: 210
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.

Re: Upgrade of DB [message #585102 is a reply to message #585101] Wed, 22 May 2013 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Upgrade of DB [message #585106 is a reply to message #585102] Wed, 22 May 2013 03:49 Go to previous messageGo to next message
kumarvk
Messages: 210
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.
Re: Upgrade of DB [message #585115 is a reply to message #585106] Wed, 22 May 2013 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Upgrade of DB [message #585196 is a reply to message #585115] Wed, 22 May 2013 22:22 Go to previous messageGo to next message
kumarvk
Messages: 210
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.

Re: Upgrade of DB [message #585198 is a reply to message #585196] Wed, 22 May 2013 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
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.
Re: Upgrade of DB [message #585199 is a reply to message #585198] Wed, 22 May 2013 22:53 Go to previous messageGo to next message
kumarvk
Messages: 210
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.
Re: Upgrade of DB [message #585200 is a reply to message #585199] Wed, 22 May 2013 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
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.
Re: Upgrade of DB [message #585201 is a reply to message #585200] Wed, 22 May 2013 23:18 Go to previous messageGo to next message
kumarvk
Messages: 210
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.
Re: Upgrade of DB [message #585202 is a reply to message #585201] Wed, 22 May 2013 23:22 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
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!
Re: Upgrade of DB [message #585910 is a reply to message #585202] Thu, 30 May 2013 21:33 Go to previous messageGo to next message
kumarvk
Messages: 210
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.
Re: Upgrade of DB [message #585912 is a reply to message #585910] Thu, 30 May 2013 21:40 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
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.
Re: Upgrade of DB - attached Trace file [message #586151 is a reply to message #585101] Tue, 04 June 2013 02:46 Go to previous messageGo to next message
kumarvk
Messages: 210
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 27 times)
Re: Upgrade of DB - attached Trace file [message #586201 is a reply to message #586151] Tue, 04 June 2013 08:01 Go to previous message
joy_division
Messages: 4454
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.
Previous Topic: dba_audit_mgmt cleanup jobs dataguard
Next Topic: SGA SIZE (Increase shared pool)
Goto Forum:
  


Current Time: Sun Apr 20 04:49:21 CDT 2014

Total time taken to generate the page: 0.08071 seconds