Re: logon as sysdba -- insufficient privileges ?!?!?

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:sr67b01jgqegi3r6ov5pmgbovoqf3fjrv4_at_4ax.com...
> Platform: Oracle 8.1.7 SE on Win2k Server
>
> Here's a new one on me. Creating a new db on a new box. Old hat,
> ought to be a piece of cake. Except this is our first server built to
> use Windows Terminal Services instead of PC-Anywhere.
>
> The install ran fine (after adjusting for the P-4 bug) and after
> referencing the work-arounds listed in MetaLink Bulletin 77627.1 I
> was able to get a listener up and running.
>
> So now I've got a listener, time to create a db. ORADIM seemed to
> work ok, gave me a db service -- OracleServiceNLCP -- and a password
> file. Next I tried to test my connection before running a 'create
> database' script. As almost expected with Terminal Services, it
> failed with a ORA-12560: TNS:protocol adapter error
>
>
>
> So, again suspecting Terminal Services as a culprit, I went back to
> the machine room and sat down at the server console to try again.
> This time I got:
>
> C:\>set oracle_sid=nlcp
>
> C:\>sqlplus /nolog
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 25 14:12:57 2004
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL> connect / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
>
> SQL>
>
> Yes, the server has a local group called ORA_DBA, and my domain
> network account is a member of that group. Here's the oradim command
> I used to create the service and the password file:
>
> d:\oracle\ora81\bin\oradim -NEW -SID NLCP -INTPWD nlcp -startmode AUTO
> -pfile e:\oradmin\nlcp\initnlcp.ora

If You are member of a domain try this:
Login to the Domain Controller as administrator and go the the user and group

administration application.

Add the member server (the machine name where Oracle runs) to the Built in group

"Pre windows 2000 compatible access" servers in the Domain controller, then the

usage of this API will be successfull.

By, Aonio Received on Wed May 26 2004 - 04:06:38 CDT