Re: Connect as SYSDBA in ORACLE 7.3 (NT)

From: <tjmxyz_at_my-deja.com>
Date: Mon, 04 Oct 1999 09:48:03 GMT
Message-ID: <7t9t4h$mqv$1@nnrp1.deja.com>

I think you don't have remote password file setup. You want to connect with "connect / as sysdba". Not directly as SYS.
The explanation for this is in the Help which i'm too lazy to look up.

But try this:
SET ORACLE_SID=YOURSIDNAME
svrmg30
svrmg30> connect / as sysdba

In article <37eae8ad.105276068_at_news.mindspring.com>, cream_ale_at_zdnetmail.com (Otto VanPlumb) wrote:
> I just installed ORACLE7.3 on a Windows NT Server and when I attempt
> to connect as SYSDBA using the SYS account I get an error (1031) that
> says I have insuficient privilieges. The SYSDBA privilege is set in
> the Security Manger for the SYS user. I am able to connect as SYSOPER
> using the sys account however. For this reason I am unable to shut
> the database down for backup. Any thoughts?
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 04:48:03 CDT