Re: Windows 2K script

"Celtic" <celtic_at_cyberintel.com> wrote in message news:<pan.2003.07.18.01.15.58.944112_at_cyberintel.com>...
> Hi,
>
> I am trying to run a script containing something along the lines of
> sqlplus "/as sysdba" as an at job run by the windows local system account.
> I have already assigned the local system to the ora_dba group but still
> get the error ora-01031: insufficient priviledges when I attempt to run
> the job. How can I do this without running the script as admin (we want to
> avoid having password changes effect the script - they would if it ran as
> administrator but not as system).
>
> Thanks,
>
> Celtic

C:\> set oracle_sid=mysid
C:\> sqlplus /nolog @<path>\myfile.sql

• myfile.sql --- connect / as sysdba -- do stuff here quit
• myfile.sql ---
  1. make sure that in the file sqlnet.ora in the Oracle_Home of interest, that the following parameter is set: (including an Oracle version is always a good idea)

SQLNET.AUTHENTICATION_SERVICES= (NTS) 2. don't run the script as LocalSystem. Run it as a local user that belongs to the local group "ORA_DBA". If that is too permissive, create a local group "ORA_%ORACLE_SID%_DBA" and grant that local group to the local user.

hth.

Pd Received on Fri Jul 18 2003 - 10:00:59 CDT