Oracle start/Close scott unlock Login
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