Search code examples
oracleplsqlsqlplussysdba

Can't login as sysdba in oracle sqlplus

'hello

I am trying to login locally installed oracle 11g database from my windows machine using 

system / as sysdba

Its asking for username and password , but In my knowledge its using default windows account and will login without any prompt . why its prompting here and the current account is indeed a memeber of oradba group .

2) I tried to connect using

conn /as sysdba

its logging inside sqlplus without any prompt

Whats happening in both cases , can someone give me a quick heads up ?

thanks

Update 1

enter image description here

Solution

  • connecting by $ sqlplus / as sysdba or SQL> conn / as sysdba mean connecting to the SYS schema implicitly.

    That's the most privileged schema of Oracle, and because of this the Operating System of the machine where Oracle installed, trusts and accepts the main administration schema and no needs a password and a username.