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

Barbaros Özhan · Accepted Answer · 2018-04-24T16:48:41.517

3

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.

edited Apr 24 '18 at 16:48

answered Apr 24 '18 at 16:42

Barbaros Özhan

59,113
10
31
55

while connecting with sysdba with password why its prompting for username and password – Bodhi Apr 24 '18 at 16:44
check my screenshot above – Bodhi Apr 24 '18 at 16:46
@coffemug Did you start your listener or start up DB? – Barbaros Özhan Apr 24 '18 at 16:47
its running and i have two instance , do i need to make specific about the sid while connecting to sqlplus – Bodhi Apr 24 '18 at 16:51
1

Yes, you need to set your SID such as `C:\Users\...> set ORACLE_SID=SID1` before connecting. OR SID1 may be replaced with the second one namely SID2. – Barbaros Özhan Apr 24 '18 at 17:07
@coffemug we already do not need to express username(sys) or that's password(Oracle already trusts the current OS) or dbname(it's already defined in tnsnames.ora in this filesystem), we only need to express which instance should be chosen. – Barbaros Özhan Apr 24 '18 at 17:53
what about the `set oracle_sid `, does it required to connect to the database – Bodhi Apr 24 '18 at 18:10
@coffemug yes, that's required even if the DB is of single instance. – Barbaros Özhan Apr 24 '18 at 18:28

score 1 · Answer 2 · answered Apr 26 '18 at 16:15

1

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.

answered Apr 26 '18 at 16:15

I was missing the (NTS) – Worthy7 Apr 11 '19 at 08:26

score 0 · Answer 3 · answered May 19 '22 at 11:10

0

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)

answered May 19 '22 at 11:10

PasanJ

1
2

this environment is on Oracle Linux Server release 7.9 NAME="Oracle Linux Server" VERSION="7.9" – PasanJ May 19 '22 at 11:11

Can't login as sysdba in oracle sqlplus

3 Answers3