Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Kentucky
    Posts
    12

    Post Unanswered: Oracle Shutdown Question

    Hi I have installed oracle 8i in laptop.Now I tried to shutdown through
    ISQL or Server Manager. I getting error below
    SQL> shutdown normal
    ORA-01031: insufficient privileges

    I looked at parameter file and change "Remote Login" = shared

    but Still I am getting same error.

    Every time I tried to shutdown As "system"

    thanks
    ashok

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Try:

    svrmgrl>connect internal
    svrmgrl>shutdown immediate

    That should work. SYSTEM is not allowed to shutdown db, only INTERNAL could do that.

    Hope that helps,

    clio_usa
    OCP - DBA

    .
    .
    .

Posting Permissions

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