Can't login as sysdba in oracle sqlplus

Question

'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

Answer 1

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.

Answer 2

On windows for / AS SYSDBA you need

• the user to be part of the dba group, check using NET USERS YOUR_NAME_HERE
• sqlnet.ora contains the line SQLNET.AUTHENTICATION_SERVICES = (NTS)
• the dos session is started "AS ADMINISTRATOR"

The last one catches me out all the time.

Answer 3

I tried using the same creating sqlnet.ora in the below file location as follows, and it worked. hope this helps!

file location: /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin

vi sqlnet.ora

NAMES.DIRECTORY_PATH=(ezconnect)

Answer 4

Enter Usaername : sys / as sysdba

Enter Password : sys

You will be connected