Oracle-L: RE: upgrading 8.1.6.0. to 8.1.7 using DBCA fails ?!

From: Odland, Brad <Brad.Odland_at_qtiworld.com>
Date: Thu, 15 May 2003 06:11:38 -0800
Message-ID: <F001.00599825.20030515061138@fatcity.com>

Sounds like the upgrade install of 8.1.7 messed up Net8...server manager is failing to make a connection to the database service because of munged Net8.

Troubleshoot your sqlnet.ora, tnsnames.ora files first.

If you invoke svrmgr23 or plus80 from the command prompt you will probably get the same error.

One of the things I learned working with Oracle on microcrap platforms is that any tool that automates a upgrade or installs fails. There are too many patches in 8.1.7 to trust any migration tool or upgrade procedure off a CD.

You are probably learning the hard way that install into a separate home export - import is the way to go rather than a migration/upgrade.

Brad O.

-----Original Message-----
Sent: Thursday, May 15, 2003 3:47 AM
To: Multiple recipients of list ORACLE-L

Guys,

I am trying to upgrade 8.1.6.0. to 8.1.7. on Win2K server. i did this with the help of MIGRATION GUIDE only.

after installing 8.1.6. , i installed 8.1.7. in the same ORACLE_HOME.

then i used DBCA to do the upgradation.
all goes fine.when the DBCA
runs ORACLE_HOME\assistants\dbma\startup_restrict.sql

it ends up in

TNS-Error : Protocol adapter error.

the startup_restrict.sql internally
invokes ORACLE_HOME\assistants\dbma\ORACLE_SIDconint.sql

this script ORACLE_SIDconint.sql has a single line in it.

CONNECT INTERNAL. i hope this is where it fails.
why is it so ? since DBCA has all the control , i do not know how to proceed further ?

any clues ?

thanx and regards,
Jp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Prem Khanna J
INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------