Re: Oracle9R2

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 14 Mar 2005 21:18:51 +0100
Message-ID: <d14reb$u13$1@news3.zwoll1.ov.home.nl>

William F. O'Neill wrote:

> Hi Frank, the error message comes when I use the Oracle upgrade uitility to 
> upgrade MISC, which is an instance created in an older version of 
> Oracle(9.0.1.0) - error: Ora-01092 Oracle instance terminated. Disconnection 
> forced.  If I access OEM, and attempt to OPEN Misc, I get the error about 
> shared memory realm does not exist.
> Hope this clarifies my situation.
> Bill..
> 
> "Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message 
> news:d13gvl$858$1_at_news4.zwoll1.ov.home.nl...
> 

>>William F. O'Neill wrote:
>>
>>>Hi Daniel:
>>>These are the Services that are in 'Start' mode:
>>>OracleMTSRecoveryService
>>>OracleOrahome90Agent
>>>OracleOrahomeTNSListener
>>>OracleServiceConsol
>>>OracleServiceMisc
>>>
>>>I tested the Consol & Misc Services with Net Stop & Net Start. Misc is
>>>the one I'm having problems with, trying to upgrade it to 9.2.0.1.0.
>>>Consol works fine, and I can connect to to it. MISC - I cannot connect
>>>to it thru OEM or SQLPlus.
>>>
>>>Bill....
>>
>>What problems... Just the 'Shared memory realm does not exist'?
>>
>>Did you upgrade your consol instance, or just misc?
>>What about this (and please, cut/paste the results!)
>>Open command session (Start -> Run -> cmd)
>>c:\> set oracle_sid=consol
>>c:\> sqlplus /nolog
>>SQL> connect / as sysdba
>>SQL> startup
>>
>>--
>>Regards,
>>Frank van Bortel

Not quite what I requested for, but I get the picture... You have no 9.0.1 software anymore, but you do have a 9.0.1 instance left over.
You cannot start 9.0.1, using 9.2.0 software. You need to upgrade, either using the migration utility, or manually.

Please read the "manually migrating" part of the migration manual very carefully before starting.
 From memory:
- alter init.ora (check: DB_DOMAIN, DB_BLOCK_SIZE,

   JOB_QUEUE_PROCESSES=0, AQ_TM_PROCESSES=0,    USER_DUMP_DEST, BACKGROUND_DUMP_DEST, CORE_DUMP_DEST must be    set to an existing directory, OPTIMIZER_MODE=CHOOSE,    _SYSTEM_TRIG_ENABLED=FALSE, unset COMPATIBLE - startup migrate
- @?/rdbms/admin/u0900010.sql

Depending on the options installed, you may need to run other scripts.
See documentation, Metalink (e.g. notes 159657.1, 165296.1)

I'd go for the migration Utility once more

-- 
Regards,
Frank van Bortel

Received on Mon Mar 14 2005 - 14:18:51 CST