oracle 切换ORACLE_SID

[oracle@db1 ~]$ export ORACLE_SID=ywkdb1

[oracle@db1 ~]$ echo $ORACLE_SID

ywkdb1

[oracle@db1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 14 15:18:18 2013

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

—————- ————

ywkdb1 OPEN

SQL>

—————————————————————

实例

一般默认情况下sid与你的数据库的名称是一样的！

如果是在Unix下可以执行如下命令：

ps -ef|grep ora_