LL

From: <fitzjarrell_at_cox.net>
Date: 13 Mar 2005 16:41:06 -0800
Message-ID: <1110760866.229683.26650@f14g2000cwb.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
> >

YOu most certainly CAN use SQL*Plus:

start->run->cmd.exe

>From here typs (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 Sun Mar 13 2005 - 18:41:06 CST