5-sql语句

1

[oracle@ocp ~]$ . oraenv　　#
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
[oracle@ocp ~]$ 
[oracle@ocp ~]$ sqlplus / as sysdba　　　#

SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 7 14:12:32 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to an idle instance.

SQL> 
SQL> startup        #启动
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size            2229944 bytes
Variable Size          356518216 bytes
Database Buffers      159383552 bytes
Redo Buffers            3805184 bytes
Database mounted.
Database opened.
SQL> 
SQL> show user　　# show用户
USER is "SYS"
SQL> 
    

2

SQL> alter user scott identified by oracle account unlock;   #解锁scott用户

User altered.

SQL> 
SQL> conn scott/oracle   # scott用户连接oracle
Connected.
SQL> 
SQL> show user   #
USER is "SCOTT"
SQL> 

3

4

5

6