Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> logon as sysdba -- insufficient privileges ?!?!?
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 Received on Tue May 25 2004 - 14:36:43 CDT