Hi,

Internal account longer exists in Oracle 9i. "Connect / as sysdba" will work
only when you have setup OS authentication.

If you are currently having the password file authentication setup, try the
following:

C:\> SET ORACLE_SID=SID_NAME
C:\> SQLPLUS /NOLOG
SQL> CONNECT SYS/PASSWORD AS SYSDBA


Note: You need to replace SID_NAME with the sid of your database and
PASSWORD with the SYS password.

Thanks n regards,

Sushil K Sharma
Sr. Systems Specialist
Tata Infotech Ltd.
NEPZ, INDIA

-----Original Message-----
From: Santhosh - Almoayyed Electronics
[mailto:[Email Address Removed] Monday, March 31, 2003 4:06 PM
To: LazyDBA.com Discussion
Subject: db connectivity


Hi ,
I have a problem with privileges in Oracle 9.2.0.1 installed on WIN XP.
I can't connect to oracle because running sqlplus I receive :
connect / as sysdba
error: ora-01031 insufficient privileges
Same message with connect internal
Any ideas
Thanks Santhosh



Oracle LazyDBA home page