Oracle 11g Release 2 Basic login operations after new installation, oracle11g

Oracle 11g Release 2 Basic login operations after new installation, oracle11g

First, you can select either desktop or server. The desktop class is relatively simple and requires no configuration. During installation, you are prompted to enter the password of the SYS user. For the server class, you can configure everything, including several sysdba passwords.

Enable SQL plus when you want to log on with the identity generated by desktop installation,

Username: SYS as SYSDBA.

Note that if you do not enter as SYSDBA, the system will prompt you That the SYS user must Log On as SYSDBA. If you enter as sysdba, it will not work because SYSDBA must be capitalized!

The password is the password you entered during installation.

What if you forget the password?

In this case, close SQL plus, open the cmd command prompt, and enter:

Set ORACLE_SID = orcl

Sqlplus/as SYSDBA

In this way, you can log on with SYSDBA. Then you can change the passwords of all users:

Alter user Username identified by password;

You can also unlock the user:

Alter user Username account unlock;

In addition, operations such as viewing dba_user can only be performed under the dba identity:

Select * from dba_users;

In this way, you can log on smoothly!