Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I am connecting to Oracle DB using sysdba:

sqlplus / as sysdba

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

I am interested to know if Oracle DB maintains some file or DB table where it stores the passwords.

share|improve this question
2  
SYSDBA isn't a username, it's a connection option. Normally, you connect to SQL*Plus using sqlplus user/password or sqlplus sys/sys_password as sysdba. If you're logged into the machine running Oracle, and the user you're logged in has suitable privileges on the machine (normally membership of a certain group), you can log in without a username and password, by writing sqlplus / as sysdba. This logs you in as the user SYS. – Luke Woodward Mar 27 at 14:58
Thanks a lot Luke – user2065083 Mar 27 at 15:09
1  
Just a friendly tip: if you're not sure you know what you're doing, connecting as SYS (which is analogous to a "root"-type account in a unix system) is a recipe for disaster. The best thing you can do is create a lower-privileged user, then login as that user. – Jeffrey Kemp Mar 28 at 5:39

migrated from stackoverflow.com Mar 27 at 18:56

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 2 down vote accepted

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.

share|improve this answer
Thanks Alex, I am new to SQL and still learning it so don't know that SYSDBA is a system privilege. I was just thinking that sysdba is a user so trying to find out what will be its password. I am able to connect using the command I gave in the question. Regarding my second question, can you please let me know where oracle stores the schema passwords? – user2065083 Mar 27 at 15:11
@user2065083 - they're 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). – Alex Poole Mar 27 at 19:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.