环境说明:Oracle实例1的SID为orcl1,实例2的SID为orcl2;
使用Oracle用户登陆:
-
启动监听:
[oracle@dbserver01 ~]$ lsnrctl start
-
修改当前SID为需要启动的实例SID,如orcl1:
[oracle@dbserver01 ~]$ export ORACLE_SID=orcl1 //切换实例
-
使用数据库管理员登陆后启动:
[oracle@dbserver01 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 09:00:54 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2220200 bytes
Variable Size 2332036952 bytes
Database Buffers 1929379840 bytes
Redo Buffers 12144640 bytes
Database mounted.
Database opened.
SQL> exit -
修改当前SID为orcl2,以同样的方法启动数据库。当然关闭方法也相同。