instances

来源：互联网发布：apache for mac 编辑：程序博客网时间：2024/05/20 05:59

两个oracle实例: beta和zeta
#export ORACLE_SID=beta
#sqlplus / as sysdba
SQL> startup
SQL> select * from hr.simple1; -- 在zeta的hr中有simple1，beta上没有。
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> shutdown immediate;
SQL> exit
#sqlplus / as sysdba
Connected to an idle instance.
SQL> startup pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initzeta.ora'
SQL> select * from hr.simple1;
        ID NAME
---------- --------------------
         1 Amy
         2 Mary
         3 Cindy

打开另一个终端,
#export ORACLE_SID=zeta
#sqlplus / as sysdba
Connected to an idle instance. -- 居然显示连接一个空实例
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode
-- 不能打开实例了，因为controlfile已经被前面的操作打开了
SQL> quit
#export ORACLE_SID=beta
#sqlplus / as sysdba
SQL> show parameter db_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      zeta
SQL> select * from hr.simple1;
        ID NAME
---------- --------------------
         1 Amy
         2 Mary
         3 Cindy
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> show parameter db_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      beta
SQL> exit
#export ORACLE_SID=zeta
#sqlplus / as sysdba
-- 居然没有显示连接一个空实例
SQL> show parameter db_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      zeta
SQL> select * from hr.simple1;
select * from hr.simple1
                 *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.
SQL> select * from hr.simple1;

        ID NAME
---------- --------------------
         1 Amy
         2 Mary
         3 Cindy