problem connecting to oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: problem connecting to oracle

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Question

    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

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    72
    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>

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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.

  5. #5
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    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

  6. #6
    Join Date
    Jan 2001
    Posts
    72
    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

  7. #7
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    This thread has some info on startup force:

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

  8. #8
    Join Date
    Jan 2001
    Posts
    72
    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?

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width