Oracle connection mode, CREATE database user, forget database password, user lock

One, Oracle six ways to connect

In ①myeclipse

Open Myeclipse,window----Show view----Other---Input DB click DB Browser

Select Right-click New. The following page appears to fill in the relevant information:

The Ojdbc6.jar package needs to be introduced here

To test:

②: Web Connection

first you need to open Oracledbconsole Service

Enter the following address in the Web page:

Https://localhost.localdomain:1158/em/console/logon/logon

③ Dynamic Soft Code generator

④pl/sql Developer

Connect as follows: Enter the password

⑤sql Developer

Open Establish connection: fill in the relevant information

⑥ SQLPLUS

Second, create database users. You can log in with the user S2223

Third, forget the password solution

Iv. Locking the user

The key syntax is as follows:

---lock on S2223

Alter user S2223 account lock

---unlock the S2223

Alter user S2223 account unlock

Oracle connection mode, CREATE database user, forget database password, user lock