Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003

    Unanswered: Can I shutdown and startup database through SQLPlus ?

    Hi all,
    I use my PC (run on MS Windows 98) to connect to Oracle database on Unixware server through SQL Plus 8.0. Can I shutdown and startup database through SQLPlus on client ?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    no, for V8.0 you must use SVRMGRL
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    I read in Oracle document that if I configure connect string with this option:
    I can use shutdown and startup command. I have tried but wasn't successful.
    And one more question: how can I connect 'AS SYSSBA' or 'AS SYSOPER' from SQLPlus on client ?

  4. #4
    Join Date
    Jul 2004

    Connect from SQLPLUS as SYSDBA


    You can connect to Oracle from SQLPlus as SYSDBA by:
    - Run SQLPlus
    - Enter sys/password@servicename as sysdba into User Name
    - Skip Password and Host String
    Click OK

    Good success,
    Thi Nguyen

  5. #5
    Join Date
    Dec 2003
    I have tried and get this error:

    ORA-01031: insufficient privileges

    I think user SYS already has SYSDBA privilege. How can I solve that? What is the difference between connecting 'sys/<syspass>@<connectString' with 'sys/<syspass>@<connectString> as sysdba' ?
    Last edited by fire2fire; 07-21-04 at 03:30.

Posting Permissions

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