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).
SYSDBA
isn't a username, it's a connection option. Normally, you connect to SQL*Plus usingsqlplus user/password
orsqlplus 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 writingsqlplus / as sysdba
. This logs you in as the userSYS
. – Luke Woodward Mar 27 '13 at 14:58