Go语言视频零基础入门到精通

luowei010101

[root@localhost ~]# su – oracle        //切换至oracle用户

[oracle@localhost ~]$ sqlplus /nolog        //进入sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 4 11:59:21 2012

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

SQL> conn /as sysdba;        //以dba登录

Connected to an idle instance.

SQL> startup;                //启动oracle实例

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1218292 bytes

Variable Size 71305484 bytes

Database Buffers 88080384 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

SQL> select * from testtb1;    //查询表

ID NAME

---------- ----------

0 wilson

1 luowei

SQL> !                            //切到系统命令状态下

[oracle@localhost ~]$ exit    //退出系统命令状态

exit

SQL> !ps -ef|grep oracle        //使用系统命令查看oracle的进程

SQL> shutdown immediate;        //关闭oracle实例

Database closed.

Database dismounted.

ORACLE instance shut down.