Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> logon as sysdba -- insufficient privileges ?!?!?

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

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 25 May 2004 14:36:43 -0500
Message-ID: <sr67b01jgqegi3r6ov5pmgbovoqf3fjrv4@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 Received on Tue May 25 2004 - 14:36:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US