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

    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
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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
    Posts
    47
    I read in Oracle document that if I configure connect string with this option:
    SERVER=DEDICATED
    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
    Posts
    61

    Connect from SQLPLUS as SYSDBA

    Hi,

    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
    Posts
    47
    I have tried and get this error:

    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
  •