Hi All,

I'm pretty confused about the way my oracle sys user is behaving (8.1.7
w2k). When I want to connect as normal user, I need to provide one password
and when I need to connect as sysdba I need to provide another password. Why
like this? I thought sys user is only one for both normal and sysdba modes.
When you login as sysdba, user would get extra privileges. Pl see the
session output below.

============================================================
SQL>conn sys/its123
Connected.

SQL>conn sys/its123 as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

SQL>conn sys/change_on_install
ERROR:
ORA-01017: invalid username/password; logon denied

SQL>conn sys/change_on_install as sysdba
Connected.

SQL>

============================================================

I know I'm missing something. Pl clarify

Regards,
Santhosh.
Oracle LazyDBA home page