第5步,还原GLOBAL_NAME:
[oracle@xty ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 15:45:09 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> update global_name set global_name='XTY';
1 row updated.
SQL> commit
2 ;
commit
*
ERROR at line 1:
ORA-01109: database not open
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 6 15:45:09 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> update global_name set global_name='XTY';
1 row updated.
SQL> commit
2 ;
commit
*
ERROR at line 1:
ORA-01109: database not open
虽然可以执行UPDATE,但是不能COMMIT。再试试能不能做DDL:
SQL> create table t1 ( a int);
Table created.
Table created.
成功了。
在另会一个会话中查看GLOBAL_NAME:
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
XTY
GLOBAL_NAME
--------------------------------------------------------------------------------
XTY
GLOBAL_NAME回来了。