Database Administration (MOSC)

MOSC Banner

ORA-01031: insufficient privileges

edited Sep 13, 2011 5:14AM in Database Administration (MOSC) 4 commentsAnswered
when i am trying to connect oracle database using sys user getting insufficient privileges error. Then it was ask for the enter username, I tried username "sys as sysdba" then ask for the password i type anything it get connected successfully. I used wrong password then also it is allow to connect the database.

[oracle@localhost ~]$ sqlplus "sys/password@db002 as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 13 19:54:52 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01031: insufficient privileges

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center