Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connect database use sysdba

ANNECAug 27 2018 — edited Aug 30 2018

I am using Oracle 12c on windows.

A question about connect to a database using sys as dba.

If I use below  from command line on the local computer that has the database:

sqlplus sys/password@myoracleDB as sysdba, I found no matter what password I put there, it connects the database successfully.

Does this mean it uses the authentication of OS, my sql.net does say nts for authentication.

It seems above sqlplus command is equivalent to  :  sqlplus / as sysdba.

But I thought if I explicitly use the user name sys and password it will use the password file instead of OS.

Apparently it does not.

Then what is the sqlplus command to use password file to authenticate for sys user on local server in this case?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2018
Added on Aug 27 2018
11 comments
25,082 views