Re: Oracle9R2

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 - 14:59:31 CST