Introduction to some basic login operations after Oracle 11g Release 2 is installed, oracle11g

Introduction to some basic login operations after Oracle 11g Release 2 is installed, oracle11g

Oracle 11g is the latest database software released. Oracle 11g has more than 400 features. After 15 million hours of testing, the development workload reaches 36 thousand people/month, it is equivalent to three consecutive years of R & D by 1000 employees. Oracle 11g provides high performance, scalability, availability, and security, and is more convenient to run on a grid consisting of low-cost servers and storage devices. Compared with previous versions, oracle 11g has distinctive features

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:

Copy codeThe Code is as follows:
Select * from dba_users;

In this way, you can log on smoothly!

Well, the above content is all described in this article. I hope you can learn about some basic logon operations after Oracle 11g Release 2 is installed.