Re: Oracle9R2

From: <fitzjarrell_at_cox.net>
Date: 14 Mar 2005 05:18:32 -0800
Message-ID: <1110806312.736478.15410@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 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 - 07:18:32 CST