David:
I did what you suggested below using MISC, rather than CONSOL. I set the
ORACLE_SID=MISC, brought up SQLPLUS, connected, and then did 'startup.' I
got to Database Mounted, and then the error Ora-01092: Oracle Instance
Terminated. Disconnection Forced.
By the way, I can follow directions, if they're not confusing. I said right
up front that I'm not a DBA. I've been a programmer(Powerbuilder) for the
past ten years.
Do you have any further suggestions???
<fitzjarrell_at_cox.net> wrote in message
news:1110833971.945537.101130_at_l41g2000cwc.googlegroups.com...
>
> William F. O'Neill wrote:
>> 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
>> >
>
> My advice still stands, and the only change you need make to it is
> replacing Consol with Misc. I would have hoped you could understand
> that; apparently examples must be explicitly coded for you.
>
>
> David Fitzjarrell
>
Received on Mon Mar 14 2005 - 16:09:30 CST
