Re: Made stupid mistake, how can I recover?

From: Paul <paulsnewsgroups_at_hotmail.com>
Date: Thu, 21 Apr 2005 14:53:19 +0100
Message-ID: <3bbf61pbf44hl18g5g6qkr2rhoj68nda5q@4ax.com>

Frank van Bortel <fvanbortel_at_netscape.net> wrote:

>open a command session (also known as a "DOS-box").
>set your oracle environment: set oracle_sid=orcl

Did this - set oracle_sid=Paulie

>Of course, orcl might be different from your environment; adapt
>accordingly.
>sqlplus "/ as sysdba"

Did this, it worked.

>you should now have 'connected to an idle instance'

No, what I got was

G:\Documents and Settings\Paul>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Apr 21 14:42:41 2005

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL>

I could then connect as scott/tiger.

>startup

And I got this

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first SQL>

However, if I try and get to the db using the SQLPlus from the Oracle programmes group, it fails with the 12560 Error.

Also, if I close down the dos-box and restart it, I am obliged to reset the oracle_sid for it to start working again.

I can access the db using the Oracle Entreprise Manager Console Standalone, but I cannot just fire up a session of SQLPlus using the "GUI" version - I have to set oracle_sid=Paulie from inside a dos-box and then run SQLPlus from there!

Basically, what I want to know is how to have the db start automatically when I boot the machine and have SQLPlus (Gui version) run automatically when I boot?

Thanks for your help so far.

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, As a courtesy to those who spend 
time analyzing and attempting to help, please 
do not top post.

Received on Thu Apr 21 2005 - 08:53:19 CDT