5-sql语句

Oracle数据库启动与用户管理

转载于 2018-03-07 15:00:00 发布 · 47 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/venicid/p/8522456.html

文章标签：

#数据库

本文介绍了Oracle数据库的启动过程及基本操作，包括通过SQL*Plus工具连接到Oracle实例、查看当前用户、启动数据库实例、以及解锁并使用特定的数据库用户（如SCOTT用户）。这些步骤对于日常管理和维护Oracle数据库至关重要。

[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>

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>