well this is a kind of backwards test as you can't log into sys directly normally

C:\Documents and Settings\>sqlplus sys/oracle@xe

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 27 23:00:40 2006

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

ERROR:
ORA-28000: the account is locked

So you can lock the sys account, however you cant stop sysdba so when someome connects as sysdba it will work (it has to)


C:\Documents and Settings\>sqlplus sys/oracle@xe as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 27 23:01:34 2006

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


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>

even though it says you are connected to sys you arent really in as sys, you are in as sysdba

as shown here


C:\Documents and Settings\>sqlplus hr/hr@xe as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 27 23:02:43 2006

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


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> show user
USER is "SYS"
SQL>