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

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40b46319$0$31679$afc38c87_at_news.optusnet.com.au...
>
> "Aonio" <aoniopaleario_at_yahoo.it> wrote in message
> news:2hj4svFdf65oU1_at_uni-berlin.de...
> >
> > "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.
>
> Er, he's on Windows 2000 Server. It is likely he has Active Directory. In
> which case, he should go to the Active Directory User and Computers
> applett. No applett of the name you provide actually exists otherwise.
>
> > 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.
>
> Doesn't that rather assume he's in a mixed domain? How will any of that
help
> him if he's an active directory site?
>
> HJR
>
>

I was looking at
Note:204289.1

on Metalink. Received on Wed May 26 2004 - 04:36:24 CDT