Oracle RDBMS 8.1.7 [message #56592] |
Thu, 10 April 2003 05:49 |
Suraj
Messages: 38 Registered: April 2002
|
Member |
|
|
Hi all,
Can anyone tell me the details of the requirements for Upgrading from Oracle 8.1.7 to 9i?
Would appreciate highlight of known issues with the upgrade and possibly other cost implication.
Regards,
Suraj
|
|
|
Re: Oracle RDBMS 8.1.7 [message #56646 is a reply to message #56592] |
Mon, 14 April 2003 11:22 |
zahra
Messages: 7 Registered: February 2002
|
Junior Member |
|
|
There is one upgrade exam required. Oracle books are pretty good...but the STS test gives excellent sample questions.
GOod luck.
|
|
|
Re: Oracle RDBMS 8.1.7 [message #56649 is a reply to message #56592] |
Mon, 14 April 2003 12:18 |
Sanjay
Messages: 236 Registered: July 2000
|
Senior Member |
|
|
I though Suraj was talking about upgrading Oracle DB from 8.1.7 to 9.2.0 ...
I just did a test upgrade from Oracle 81740 to 92030, AIX 4.3.3.
Couple of things to remember:
1. You need tons of space just to install Oracle binaries (5 GB+) as it has 4 (yes 4) CD's for EE.
2. At least 150MB in system.
3. Apart from that, pretty much followed the instruction. No errors encountered.
4. I installed base 9.2.0.1.0 and patched with 3.0 (making it 9.2.0.3.0). Anyhow, I needed Oracle Universal Installer 2.2.0.18 be installed in order to be able to install patch 3.0. The base Oracle install uses OUI 2.2.0.12.
Go to Metalink and get 'Note:159657.1'
==
$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.3.0 - Production on Mon Apr 14 13:59:37 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL>
|
|
|