RE: Oracle on Windoze

From: Stevens, Ed <ED.STEVENS_at_NMM.NISSAN-USA.COM>
Date: Fri, 1 Oct 2004 13:04:17 -0500
Message-ID: <D95631492847D511A32E00B0D0D02E8E08B5F702@nmmset01.nmm.nna>

Apparently, regardless of what you've been told, this was *not* the account used to install Oracle. Or else someone has messed with it. You need to be a member of the local group ORA_DBA. Also, you need to have the environment variable or registry string value ORACLE_SID set to the value of the sid to which you want to connect, but lacking that will throw a different error.

Ed Stevens

-----Original Message-----

From: sol beach [mailto:sol.beach_at_gmail.com] Sent: Friday, October 01, 2004 11:40 AM
To: oracle-l_at_freelists.org
Subject: Oracle on Windoze

I'm a *nix command line type DBA who has next to no experience directly supporting
Oracle on Windoze.
I get logged onto the DB server system as "administrator" & this account supposedly
was used to install Oracle.
However when I open up a command window & invoke SQL*PLUS and then / as sysdba
The error message reports I have insufficient privileges.

How do I get into this DB as "SYS"?
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 13:16:12 CDT