patternMinor
SYSDBA password in Oracle DB
Viewed 0 times
sysdbaoraclepassword
Problem
I am connecting to Oracle DB with:
What is the default password for the sysdba user? I tried in net and found out the default password is
Does Oracle DB maintain some file or DB table where it stores the passwords?
sqlplus / as sysdbaWhat 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.