Re: upgrading 8.1.6.0. to 8.1.7 using DBCA fails ?!

Very simple. DO NOT use the assistant to upgrade. Here is a line from my .profile
that is very helpfull:

alias svrmgrl="sqlplus \"/ as sysdba\""

Include that in your profile, log out, log in and type "svrmgrl".

Then, you do what the instructions tell you to do. No gooey stuff.

On 2003.05.15 04:46 Prem Khanna J wrote:
> 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).
>

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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).