I have a question regarding starting oracle database with in correct sys password.
I have provided incorrect password for sys user and I am still able to start database and execute statements. So wondering whether I have missed something while installation or this is how it is?
Any insight into this is highly appreciable, Below is the result of start database.
sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 15 16:50:39 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys/d as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 285215104 bytes
Database Buffers 130023424 bytes
Redo Buffers 6094848 bytes
Database mounted.
Best Answer
When your OS user is from a DBA group, you can connect
AS SYSDBA
with OS authentication:You can then use
CONNECT / AS SYSDBA
or evenCONNECT FOO/ANYTHING AS SYSDBA
, the DB will ignore the user/password.