如何启动与停止oracle实例

一、启动数据库实例

1.导入oracle_sid

export ORACLE_SID=test
2.启动oracle实例

[oracle@test ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 17 10:06:15 2014

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

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size            2228784 bytes

Variable Size          402656720 bytes

Database Buffers     1157627904 bytes

Redo Buffers           40898560 bytes

Database mounted.

Database opened.
二、停止数据库实例
1.切换用户

[root@test ~]# su - oracle

2.停止数据库实例

[oracle@test ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 19 14:59:09 2014

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

SQL> conn sys/oracle@test as sysdba

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.