Actually,
It is the process of IMP/EXp with FULL=Y from 8.1.6 to 9.2 that IS NOT
supported. How ever Oracle have said that they will support the resulting
database even if the process to get there is not supported with some
conditions of course ie there is no data corruption during the imp/exp.
Ryan Froman
Database Administrator
Support and Development Services
Information Technology Division
HBOS Australia
Level 7 148 Adelaide Tce
Telephone: (08) 9449 8608
|---------+--------------------------------------------------------->
| | "Justin Cave (DDBC) " |
| | <oracledba-ezmlmshield-x61216539.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 04/03/2005 04:54 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: RE: 8i to 9i database upgrade |
>-----------------------------------------------------------------------------------------------|
Yes, direct upgrades (i.e. running the Database Upgrade Assistant) are
not supported. I'm reasonably confident that if you attempted to run
the DBUA against an 8.1.5 database, it would error out, but I haven't
tested that.
Indirect upgrades via export and import, on the other hand, are
supported practically forever. The 9i Import utility, for example,
according to the Oracle Utilities manual, will happily read dump files
created by the export utility from an Oracle 5.1.22 database. I doubt
anyone on this list has an Oracle 5 database lying around any more.
Justin Cave =20
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Netz Randy N
[mailto:oracledba-ezmlmshield-x99027482.[Email address protected]
Sent: Thursday, March 03, 2005 3:26 PM
To: LazyDBA Discussion
Subject: RE: 8i to 9i database upgrade
By NOT SUPPORTED, don't they actually mean that it CANNOT BE DONE? My
understanding is that the upgrade process of the database is not
possible from a 816 to 920. It just cannot be done that way.
Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)
-----Original Message-----
From: Ryan
[mailto:oracledba-ezmlmshield-x13372426.[Email address protected]
Sent: Tuesday, March 01, 2005 10:53 PM
To: LazyDBA Discussion
Subject: RE: 8i to 9i database upgrade
Justin,
Note:159657.1 (metalink)
Upgrade path for Oracle 8i:
If your old release version is 8.1.5 or 8.1.6, then direct upgrade to
Oracle 9.2
is NOT supported. You must first upgrade this version to 8.1.7. After
the
upgrade to 8.1.7 or your version IS 8.1.7, you can directly upgrade your
database to Oracle 9.2. However, if your target release is 9.0.1,
direct upgrade from 8.1.5 and 8.1.6 is supported.
Does this mean that it is the process that is not supporte dor what, and
if
it is the process that is not supported how can they then support
theresult
?
R
|---------+--------------------------------------------------------->
| | "Justin Cave (DDBC) " |
| | <oracledba-ezmlmshield-x53321294.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 02/03/2005 11:57 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
----------------------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: RE: 8i to 9i database upgrade
|
>-----------------------------------------------------------------------
----------------------------------------|
I'm not sure where you read the particular comment about supported
upgrades, but I'm pretty confident that it refers to using the Database
Upgrade Assistant. Going from 8.1.6 to 9.2.0 via export and import is
certainly supported.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
_______________________________________________________________________________
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure by law.
Any claim to privilege is not waived or lost by reason of mistaken transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data corruption,
delay, interruption, unauthorised access or unauthorised amendment.
_______________________________________________________________________________
Oracle LazyDBA home page