2

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.

|improve this question

migrated from stackoverflow.com Mar 27 '13 at 18:56

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

  • 3
    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 '13 at 14:58
  • Possible duplicate of dba.stackexchange.com/questions/34734/… and dba.stackexchange.com/questions/36350/… – Yasir Arsanukaev Mar 27 '13 at 23:16
  • 2
    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 '13 at 5:39
7

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).

|improve this answer
2

Oracle stores password for SYS and internal user's password in PWD###.ora file, where ### is your DB service Name/SID. I found a nice tutorial on orapwd utility to change password for SYS:

Lost Oracle SYS and SYSTEM password?

|improve this answer
0

I had the same issue and then I realized that I was trying to login as root. I installed the database as "oracle" user but then I opened the other terminal which was root by default. so login as "oracle" or whatever user you used to login and it should work.

|improve this answer

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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