Default passwords of Oracle 11g?

Question

I installed Oracle 11g. I did not change the passwords for SYSTEM and SYS. However, now I have found that the default passwords do not work. Please, help.

Answer 1

You can connect to the database without specifying a password. Once you do this, you can use reset passwords. I assume that you have installed the database on your computer; if not, you first need to connect to the machine on which the database is running.

• Make sure your user account is a member of the dba group. How you do this depends on which OS you are running.

• Type sqlplus / as sysdba in the command prompt / shell / terminal window, if necessary. This should enter the database as SYS.

• After logging in, you can enter

   alter user SYS identified by "newpassword"; 

  to reset the password SYS and similarly for SYSTEM.

(Note: I have not tried anything from Oracle 12c, I assume that they have not changed the situation with Oracle 11g.)

Answer 2

Log in as oracle login user id (where oracle is installed).

• Add ORACLE_HOME = <Oracle installation Directory> to the environment variable

• Open command prompt

• Change directory to %ORACLE_HOME%\bin

• enter sqlplus /nolog

• SQL> connect /as sysdba

• SQL> alter user SYS identified by "newpassword";

One more check, while installing the oracle and setting up the database assistant, if you are setting up any database, then you could provide a password and check the same password for all other accounts. If so, try with the password that you have as configured in the database configuration assistant.

Hope this works for you.

Answer 3

After installation in windows Following the instructions starting with Run SQL Command Prompt (Command Prompt)

then ... v. SQL> connect / as sysdba

Connected [SQL response request]

VI. SQL> change user SYS identified by "newpassword";

User changed. [SQL response request]

Thank. This minimized the headache.

Answer 4

actually during installation process.it will prompt you to enter a password. At the last stage of installation, a window appears with the cloning of the database files. After copying, there will be an option ... how to manage passwords .. We have to set our password .. and the username will be the default ..