Thanks Frank. We'll see what happens!
Bill...
"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:d14reb$u13$1_at_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 - 15:54:42 CST
