problem connecting to oracle

[mybear]

I tried logging onto my database through sqlplus and got the following error
ORA-01092: Oracle instance terminated. Disconnecttion forced

I tried to connect as internal through SQLPLUS and received the below error message:

ORA-24327: need explicit attach before authenticating a user

I therefore went to the dos prompt to connect to server manager to get it started but it did not. Below is what I did:

PL/SQL Release 8.1.5.0.0 - Production

SVRMGR> connect internal/oracle
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> shutdown
ORA-03114: not connected to ORACLE
SVRMGR> startup
ORA-01031: insufficient privileges
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> connect internal
Connected.
SVRMGR> shutdown
ORA-03114: not connected to ORACLE
SVRMGR> connect internal
Connected.
SVRMGR> select * from v$database;
select * from v$database
*
ORA-03114: not connected to ORACLE
SVRMGR>
SVRMGR> startup
ORA-01031: insufficient privileges
SVRMGR> connect internal
Password:
Connected.
SVRMGR>
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> connect internal/oracle
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first


NOTE:
I'm running small databases on this machine.
O/S= WINDOWS 98
ORACLE VERSION=8.1.5.0.0. Enterprise edition

[Oracledba8]

Probably the Reason is you are Not Connected as Sysdba.

Try This on Server manager

Connect Internal/Oracle as SYSDBA

Then You can Try to StartUp or Shutdown.

Hope it Works.
Thanks

[mybear]

I tried it but it did not work. Below is what I did:

C:\>set ORACLE_SID=ORCL

C:\>svrmgrl

Oracle Server Manager Release 3.1.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8i Personal Edition Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SVRMGR> connect internal/oracle as SYSDBA
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> shutdown
ORA-03114: not connected to ORACLE
SVRMGR> connect internal/oracle as SYSDBA
ORA-12547: TNS:lost contact
SVRMGR>

[Halo]

I have encountered this before and this is what I did (and it worked)
1. set ORACLE_SID=whatever
2. connect internal
3. shutdown normal, and then
4. startup
-
Try it out.

[GARYM]

I ran into this also. My steps were as follows:

At the command prompt set oracle_sid = mysid
start svrmgr30 (I'm running 8.0.5)
connect internal
startup force

After completion of startup I did a shutdown immdiate and performed a backup.



Gary

[mybear]

Thanks guy's. Gary's method worked.
Gary do you have any Idea what went wrong so that I can prevent that from happening again?

Can you explain what the startup force does? I have not seen that before in any doc's.

Thanks

[GARYM]

This thread has some info on startup force:

http://www.dbasupport.com/forums/sho...?threadid=8719

[mybear]

Hi guys,
I exited out of server manager, shut down the database, and tried to start it up again through sqlplus.
This time this is the error message that I received:
ORA 01092: ORACLE instance terminated. Disconnection forced

I also tried connecting as internal to sqlplus and I received this message:
ORA-24327: need explicit attach before authenticating a user.

So I went to svrmgrl and did what gary suggested again and it worked:
set ORACLE_SID=orcl
svrmgrl
SVRMGRL>connect internal
connected
SVRMGR>startup force
and it worked.

My question is what is causing this problem. This is the first time, that I am having this problem in a year.
I never had to go into server manager in order get into SQLPLUS but now it seems that without connecting into svrmgrl, I will not be able to connect to SQLPLUS
Can anybody tell me what's going on here?

[sambavan]

What happens when you issue shutdown force is as the thread on GARYM's posting explains, by SHUTDOWN ABORT and then performs a startup.

To be on the safer side, try doing the following,

set ORACLE_SID
svrmgrl
connect internal
shutdown immediate
startup

This wouldn't require any recovery, when you start, other wise you have to perform some recovery to bring back things in sync.

To connect through the sqlplus, try
set ORACLE_SID=
sqlplus connect / AS SYSDBA


Sam

Sam