oracle system locked,Oracle System account is locked....can't unlock it.. — oracle-tech

jignesh kankrecha wrote:

if you run that query

SELECT * FROM V$PWFILE_USERS;

tel you that sys has sysdba and sysoper or notNO!

It tells which user has Sysdba and/or Sysoper role.

See below,

SQL> select * from V$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

PL/SQL Release 11.1.0.6.0 - Production

CORE 11.1.0.6.0 Production

TNS for Linux: Version 11.1.0.6.0 - Production

NLSRTL Version 11.1.0.6.0 - Production

SQL> select * from V$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

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

SYS TRUE TRUE FALSE

SQL> create user kankrecha identified by abc;

User created.

SQL> grant sysdba to kankrecha;

Grant succeeded.

SQL> select * from V$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

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

SYS TRUE TRUE FALSE

KANKRECHA TRUE FALSE FALSE

SQL> grant sysoper to kankrecha;

Grant succeeded.

SQL> select * from V$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

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

SYS TRUE TRUE FALSE

KANKRECHA TRUE TRUE FALSE

SQL> revoke sysdba, sysoper from kankrecha;

Revoke succeeded.

SQL> select * from V$pwfile_users;

USERNAME SYSDB SYSOP SYSAS

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

SYS TRUE TRUE FALSEHTH

Aman....