Default passwords of Oracle 11g?

Question

I installed Oracle 11g. I didn't change the passwords for SYSTEM and SYS. However now I find that the default passwords do not work. Please help.

Answer 1

It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.

1. Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.

2. Enter sqlplus / as sysdba in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.

3. Once you're logged in, you can then enter

   alter user SYS identified by "newpassword";
   

   to reset the SYS password, and similarly for SYSTEM.

See also here.

(Note: I haven't tried any of this on Oracle 11g; I'm assuming they haven't changed things since Oracle 10g.)

Answer 2

Login into the machine as oracle login user id( where oracle is installed)..

i. Add "ORACLE_HOME = <Oracle installation Directory" in Environment variable
ii. Open a command prompt
iii. Change the directory to %ORACLE_HOME%\bin
iv. type the command "sqlplus /nolog "
v. SQL> connect /as sysdba
vi. SQL> alter user SYS identified by  "newpassword";

One more check, while oracle installation and database confiuration assistant setup, if you configure any database then you might have given password and checked the same password for all other accounts.. If so, then you try with the password which you have given in your database configuration assistant setup.

Hope this will work for you..