DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: cannot shutdown database sqlplus

  1. #1
    Join Date
    Aug 2003
    Posts
    5

    cannot shutdown database sqlplus

    The database is running. I run in sqlplus :

    > connect system/manager
    > shutdown normal

    Get message -
    Ora-01031 Insufficient privileges

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    system doesnt have priveleges to shutdown a database as the message tells you, log in as a user with sysdba privelges
    (sqlplus "/ as sysdba") or go find a real dba

  3. #3
    Join Date
    Aug 2003
    Posts
    5
    connecting as sysdba gives the same error !

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    then obviously you havent connected as sysdba (and I dont mean sys)

  5. #5
    Join Date
    Jan 2001
    Posts
    230
    Which O.S.?
    If it is Windows NT or 2000, username (O.S. login) has to be as part of ORA_DBA group.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not if you have a password file, then you can log in with any username listed in that file

  7. #7
    Join Date
    Aug 2003
    Posts
    5
    The database is running on the local machine.
    I want to shutdown the database using sqlplus

    OS - windows 98
    Oracle 8i personal edition
    init.ora : remote_login_passwordfile = exclusive

    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges

    I also tried
    SQL> connect sys/change_on_install
    Connected.
    SQL> shutdown normal
    ORA-01031: insufficient privileges

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    i said sys wont work!

    do

    sqlplus internal

  9. #9
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Goto command prompt.

    then type

    C:\>svrmgrl

    Oracle Server Manager Release 3.1.5.0.0 - Production

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

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

    SVRMGR> connect internal
    Connected.
    SVRMGR>shutdown normal;

    This will shutdown the database properly.

    Paresh

  10. #10
    Join Date
    Aug 2003
    Posts
    5
    Connecting as "internal" worked
    thanks davey

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