Hi David:
Thank you for your assistance. Both instances show services in 'start' mode
in Settings/Services, when I turn the computer on. I can connect to CONSOL
fine. CONSOL is the instance I created when I installed Release 2. My
problem is trying to upgrade MISC, which is an old instance under 9.0.1.0
When attempting to upgrade, using the Oracle Upgrade utility, I get the
error: Ora-01092 - Oracle instance terminated. Disconnection forced. Hope
this clarifies my problem.
Bill...
<fitzjarrell_at_cox.net> wrote in message
news:1110806582.429279.290740_at_o13g2000cwo.googlegroups.com...
>
> William F. O'Neill wrote:
>> I cannot use SQLPlus either, because of this error message. Any
> other
>> suggestions?
>>
>> <bdbafh_at_gmail.com> wrote in message
>> news:1110756204.007058.220220_at_z14g2000cwz.googlegroups.com...
>> > SQL> startup
>> >
>
> William F. O'Neill wrote:
>> I cannot use SQLPlus either, because of this error message. Any
> other
>> suggestions?
>>
>> <bdb..._at_gmail.com> wrote in message
>> news:1110756204.007058.220220_at_z14g2000cwz.googlegroups.com...
>> > SQL> startup
>> >
>
> YOu most certainly CAN use SQL*Plus:
>
> start->run->cmd.exe
>
>>From this point type the following (the c:\> prompt should be used as
> an example only):
>
> c:\> set ORACLE_SID=<your database name here>
>
> c:\> sqlplus /nolog
>
> you should see something similar to:
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Sun Mar 13 18:27:51 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL>
>
> At THAT point type:
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> startup
>
> And see what transpires. You should see something similar to:
>
> ORACLE instance started.
>
> Total System Global Area 246139296 bytes
> Fixed Size 731552 bytes
> Variable Size 201326592 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 10526720 bytes
> Database mounted.
> Database opened.
> SQL>
>
> It's apparent you have not set the service to autostart the instance at
> boot; use ORADIM to do this:
>
> c:\> oradim -startup -sid=<your database name here>
> -starttype=srvc,inst -pfile=<your parameter file, and path, here>
>
> This SHOULD set the service to start the instance as well at boot.
>
>
>
> David Fitzjarrell
>
Received on Mon Mar 14 2005 - 13:38:46 CST
