Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Starting Oracle from sqlplus on windows.

Starting Oracle from sqlplus on windows.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 19 Sep 2001 19:43:05 -0500
Message-ID: <ubsk6h6h8.fsf@verizon.net>


I've been trying to figure out how to use sqlplus instead of svrmgrl. I can't seem to figure out how to start sqlplus when the instance isn't running.

,----[ THE DOCUMENTATION SAYS. ]
| Preparing to Start an Instance
| You need to perform some preliminary steps before attempting to
| start an instance of your database .
|
| Start SQL*Plus without connecting to the database by entering:
| SQLPLUS
|
| Connect to Oracle as SYSDBA:
| CONNECT username/password AS sysdba
`----

So, I shut down the instance leaving the listener running. I then type sqlplus as the command line and I get the following. ,----
| > sqlplus
|
| SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 19 20:40:09 2001
|
| (c) Copyright 2000 Oracle Corporation. All rights reserved.
|
| Enter user-name:

`----

I then can't get any further.

How do I get a prompt that allows me to
"CONNECT username/password as SYSDBA" when the instance isn't running?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Wed Sep 19 2001 - 19:43:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US