Home » RDBMS Server » Server Administration » Upgrade 8i to 10g
Upgrade 8i to 10g [message #191678] Thu, 07 September 2006 13:34 Go to next message
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 #191681 is a reply to message #191678] Thu, 07 September 2006 13:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I'm upgrading on a Win2003 Server

If this is true,
you are confused and probably reading a WRONG documentation.
Or i completely misread your posting.

>>A) oratab .... all the rest
>>C) When I run ... all the rest


these are to do with UNIX/LINUX.
If you are in windows, you no need to do those.
There is NO oratab entires for windows.

>>B) The documentation indicate that if archiving is enabled, set LOG_ARCHIVE_START = true

The correct documentation clearly says, the said parameter is deprecated
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm
Re: Upgrade 8i to 10g [message #191684 is a reply to message #191681] Thu, 07 September 2006 13:59 Go to previous messageGo to next message
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?
Re: Upgrade 8i to 10g [message #191692 is a reply to message #191684] Thu, 07 September 2006 15:25 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Obviously, after you upgrade.
First upgrade the database.
You can worry about the listener etc later.
Previous Topic: Create DATABASE without being OS Administrator
Next Topic: Rebuilding Indexes
Goto Forum:
  


Current Time: Wed Dec 07 06:41:48 CST 2016

Total time taken to generate the page: 0.10109 seconds