Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot access in database as 'sys' user

shipon_97Nov 29 2008 — edited Nov 30 2008
Friends ,

I m using oracle database (v10.2.0.1.0) . I cannot access in oracle as 'sys' password . I create a new password file like following way :

orapwd file=/orafs/app/oracle/10.2.0/db_1/dbs/oraPWDMILSTEST password=sys_000 entries=5

And when I try to access ,

---------------------------------------------------------------------------------------------------------------
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 29 12:51:28 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/sys_000 as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> exit

----------------------------------------------------------------------------------------------------------------

Here I mention that , I already change sqlnet.ora file, so that any user cannot access into the database as 'sysdba' user .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2008
Added on Nov 29 2008
11 comments
1,191 views