Elementary Introduction to Oracle 11g Release 2 Some basic operation about login after new installation _oracle

Oracle 11g is the latest database software launched, Oracle 11g has more than 400 functions, after 15 million hours of testing, development work volume reached 36,000 people/month, equivalent to 1000 employees for continuous research and development 3 years. Oracle 11g delivers high performance, scalability, availability, and security, and makes it easier to run on a grid of low-cost servers and storage devices, and Oracle 11g has unique features relative to previous versions

The first thing to note is that you can select a desktop class or server class at installation time. Desktop class is relatively simple, no configuration, at the time of installation prompts you to enter the password, is the SYS user's password, and the server class, you can configure everything, including a few sysdba password.

Open SQL Plus when you want to log in as a build with a desktop class installation

User name: SYS as SYSDBA.

Note here that if you do not enter as SYSDBA, the system prompts you that the SYS user must log in as SYSDBA, if you enter as SYSDBA, because SYSDBA must be capitalized!

The password is the password you fill in when you install it.

What if you forget the password?

At this point, turn off SQL Plus, open the cmd command prompt, and then enter:

Set ORACLE_SID=ORCL
Sqlplus/as SYSDBA

This will enable you to log in as a sysdba. You can then modify the password for all users:

Alter user username identified by password;

You can also unlock the user:

Alter user username account unlock;

Also, viewing dba_user can only be done under the DBA's capacity:

Copy Code code as follows:

SELECT * from Dba_users;

This will be able to successfully log in!

All right, here's what this article is all about, and I want to help you learn some basic things about login after the Oracle 11g Release 2 new Installation.