ora-01031 with Windows AT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ora-01031 with Windows AT

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    I have a couple of .bat setup which connects as Internal to shutdown the database and startup in Windows 2000, they work fine if I run them manually but if put in AT they fails with ORA-01031 insufficient privileges. I havent worked much with Windows so I cant think other things than probably enviroment variable settings. Also in AT it works if I use other users so basically this only happens with Internal

    Does anyone know what may be the problem? The user is already a ora_dba group user


  2. #2
    Join Date
    Jan 2002
    Posts
    148

  3. #3
    I expirienced the exact same problem using server manager in oracle 8.1.6 enterprise server on windows 2000. It also affects DBA studio as well. I am interested in this as well as I have not been able to figure out why internal/oracle loses privledges.
    Chester Ney
    CODY Computer Services
    System DBA

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    jr

    my problem only happens with internal

  5. #5
    For some reason internal/oracle works fine for awhile for startup/shutdown via svrmgrl or DBA Studio. It seems like when you assign the dba priveledge to another user it demotes internal/oracle. I could be wrong but this is what I've expirienced.
    Chester Ney
    CODY Computer Services
    System DBA

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ok, I used now the GUI scheduler and it works because I specify in GUI what user will run this job whereas in MS-DOS AT I did not. What is puzzles me is this is inconsistent, in MS-DOS user system runs the job with no problems while internal fails but in GUI both works. May be internal is a powerful user I guess

    cheers

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    this may be help some peeps with same problem, I changed again internal's password and AT started to work with no problems... both GUI and command-line based strange but true

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