| Upgrade 8i to 10g [message #191678] |
Thu, 07 September 2006 13:34  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I've read multiple threads here that indicate an upgrade from 8i to 10g is soooooooo easy. However, I'm encountering a few issues I find vague in the upgrade documentation:
I'm upgrading on a Win2003 Server (from 8.1.7.4.1 to 10.2)
A) oratab - This appears to be a Unix utility, however it appears to be explicitly assumed. Do I need to make modifications to ORACLE_HOME, etc through another utility? When I install the 10g software, I review the registry the 8i ORACLE_HOME is defined within several keys and the 10g ORACLE_HOME location is in a single key. Do I need to add the ORACLE_HOME path to my environment variables manually? What steps do I need to take to ensure that before I execute 'Startup Upgrade', my software is pointing in the correct location? This is what I find confusing:
22. Update the oratab entry, to set the new ORACLE_HOME and disable automatic
startup:
<SID>:<new ORACLE_HOME>:N
Update the environment variables like ORACLE_HOME and PATH
$ . oraenv
Make sure the following environment variables point to the new
Release directories:
- ORACLE_HOME
- PATH
- ORA_NLS33
- ORACLE_BASE
- LD_LIBRARY_PATH
- ORACLE_PATH
Where/how do these get modified?
B) The documentation indicate that if archiving is enabled, set LOG_ARCHIVE_START = true
However, when I run the upgrade utility, this parameter is designated as obsolete.
C) When I run these from a DOS prompt, I'm not receiving the answer I expect:
4. Ensure ORACLE_SID is set to instance you want to upgrade.
Echo $ORACLE_SID
Echo $ORACLE_HOME
I would assume Echo $ORACLE_SID would return the oracle_sid, but rather it returns:
$ORACLE_SID
D) Also, when I attempted to upgrade using the dbua, I ran into all kinds of issues with connecting to the instance I wanted to upgrade, is there a set of steps that I need to execute prior to launching the dbua? I try to run it as part of the 10g software install, but I get tns errors (yes, DB is running), init.ora parameter issues (do these need to change prior to running dbua?)
E) At what point do I drop the 8i listener and create the new 10g listener?
F) It's my understanding that internal is obsolete. If that's the case, then why do the instructions for oradim read:
And create the new Oracle Database 10g service at a command prompt using the
ORADIM command of the new Oracle Database release:
C:\> ORADIM -NEW -SID SID -INTPWD PASSWORD -MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
Should it be -SYSPWD instead of -INTPWD?
Thanks.
[Updated on: Thu, 07 September 2006 13:36] Report message to a moderator |
|
|
|
|
|
| Re: Upgrade 8i to 10g [message #191684 is a reply to message #191681] |
Thu, 07 September 2006 13:59  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
What about this? I couldn't find specific reference to it in the documentation. I'm reading the same document you linked, however I'm also working with another document that seems to have some errors in it.
E) At what point do I drop the 8i listener and create the new 10g listener?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
