Can't login as sysdba in oracle sqlplus

oracle plsql sqlplus sysdba
Bodhi picture Bodhi · Apr 24, 2018 · Viewed 14.6k times · Source

'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

Answer

Barbaros Özhan picture Barbaros Özhan · Apr 24, 2018

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.

Related questions

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More
ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect to my database. ORA-12154: TNS:could not resolve the connect identifier specified. I am able to use SQLPLUS from the …

Read More
How do you execute SQL from within a bash script?

I have some SQL scripts that I'm trying to automate. In the past I have used SQL*Plus, and called the sqlplus binary manually, from a bash script. However, I'm trying to figure out if there's a way to connect …

Read More