Re: ORA-01031, Windows 2000, Ora9.2

Mike Jay <mikejay_at_mitre.org> wrote in message news:<3E557DE8.8CFA40E1_at_mitre.org>...
> Hi guys,
>
> The instance I am trying to connect to using both OS or remote password
> authentication fails with a ORA-01031 error.
>
> I have looked in the archives, but my question may be a bit eclectic.
>
> The local user is a member of the ORA_DBA group on windows, but not the
> local Administrator user.
>
> The local user is a member of the:
> Active Directory Domain Administrators group
> Local Administrators group
> ORA_DBA group
>
> I have tried with OS (remote password none in initialization file) or
> with the ORAPWD file (remote password both shared and exclusive in
> initialization file) and failed to connect.
>
> The ORADIM utility was used to make the OracleServiceMySID service.
>
> I cannot use dbassist as the database is for a 3rd-party product using
> scripts to create the database.
>
> Most important, the computer has been "locked down" with security
> templates doing who knows what to the Windows 2000 security policies.
> The two other systems allow me to install and support the 3rd-party
> application, but the "locked down" one fails.
>
> My failed attempts to connect include two approaches
>
> 1) sqlplus /nolog
> SQL> connect / as sysdba
>
> 2) sqlplus "/ as sysdba"
>
> I have looked throughout the Windows-specific Oracle administrators
> guide and the registry entries, oracle.key file, and user group
> membership look correct.
>
> What Windows 2000 Server and Oracle9i conflict could result from
> tweaking Local Machine Policies?
>
> Are any known gotchas typical? Templates mean scripts used to affect
> security policies on the Windows 2000 Server.
>
> Thanks,
> mikejay

the ORA_DBA group needs to be a *LOCAL* group, NOT a *DOMAIN* group. The sw has to be installed using the *local* administrator.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 21 2003 - 07:06:39 CST