Oracle starts/disables scott to unlock login, oraclescott

Oracle starts/disables scott to unlock login, oraclescott

After the oracle database is successfully installed, the following problems occur for the first time,

 

Here, we only provide three methods:

L SQL * plus

L OEM Console

L Windows Console

 

1. Take the windows console as an Example

A. Run the cmd command as an administrator.

B. Enter "sqlplus/nolog"

C. Enter "conn/as sysdba"

C. Enter "startup"

 

2. Take SQL * plus as an Example

A. Prepare

First, use SQL * plus to connect to oracle

"Sqlplus/nolog" starts SQL * plus without connecting to the database

"Connect/as sysdba" connects to oracle as A DBA

B. Start

"Startup"

 

3. The OEM console is quite troublesome. I will not describe it here

 

 

How to unlock scott account after installing Oracle Database

After installing the Oracle 10 Gb database, I forgot to unlock the scott account. In this case, you can go to the SQL plus tool (START | all programs | <Oracle-Home> | Application Development | SQL Plus), or unlock the scott account through command lines on the console.

In the first caseSystem Account + password set during self-installation,LoginSQL Plus,

Then run the"Alter user scott account unlock;To unlock.

After the solution is complete, run the following command to view the information :"Select username, account_status from dba_users;",

We can see that the scott account has been unlocked, but the status is still"Expired"(Password expired.

It doesn't matter. Enter the command"Alter user scott identified by tiger;", And a new password is assigned to it.

ExitScott/tigerLog on.

In the second case, use the Windows Console (Program | run, Enter cmd to open ). Enter sqlplus/nolog in the command line, press enter, and an SQL> command prompt appears. Then, enter the command in the following order:

SQL> conn/as sysdba
SQL> alter user scott account unlock;
SQL> disconnect
SQL> conn scott/tiger @ oral;
The system prompts that the password has expired. enter a new password. Then, enter the new password and press enter to confirm the new password for the scott account. Open SQL Plus and log on to the scott account.

 

PL/SQL Logon