RE: Requirement to run as user SYS

  • From: "Hollis, Les" <Les.Hollis@xxxxxx>
  • To: <MGogala@xxxxxxxxxxxxxxxxxxxx>, <barb.baker@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Dec 2004 10:58:41 -0600

Alter user sys account lock;

And hopefully you have an  orapwSID  file with entries in it which then
enables the unix user    oracle   to be able to log in as    '/ as
sysdba'  which puts you in the DB as   SYS  even though the account is

If you try to log in   as   sys while in sqlplus  you get=20

SQL> conn sys/password
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

From UNIX command line  you get

rydsup11:/home/oracle> sqlplus sys

SQL*Plus: Release - Production on Thu Dec 9 11:54:56 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter password:
ORA-28000: the account is locked

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - Production

SQL> show user

INTERESTING   no/yes????

So  you still get in as just use   '/ as sysdba'  =20

I do have   *.remote_login_passwordfile=3D'EXCLUSIVE'  in my initSID.ora
and I do have a orapwSID  in $ORACLE_HOME/dbs


Other related posts: