HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SYSDBA password in Oracle DB

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sysdbaoraclepassword

Problem

I am connecting to Oracle DB with:

sqlplus / as sysdba


What is the default password for the sysdba user? I tried in net and found out the default password is change_on_install but it is not working for me.

Does Oracle DB maintain some file or DB table where it stores the passwords?

Solution

SYSDBA is not a user, it is a system privilege. When you connect as / you are connecting to the SYS user. You don't need a password when you connect as you are - as long as it's a local connection from an OS account in the DBA group.

You haven't said what happens when you try to connect, or why you think you need a password; possibly that is that failing (in which case giving the error message would be helpful) and giving you a SQL*Plus login prompt, maybe indicating you aren't in that group.

Passwords are stored within the DB, the exact location depends on version; but they're stored hashed (of course) so you're not going to be able to get the actual passwords in plaintext (without a lot of time and effort anyway).

Context

StackExchange Database Administrators Q#38701, answer score: 8

Revisions (0)

No revisions yet.