[zhang@zhangshibo /]$ sqlplus /nolog sql*plus: release 11.2.0.1.0 production on wed oct 17 11:27:49 2012 copyright (c) 1982, 2009, oracle. all rights reserved. sql connect sys/orcl as sysdba; connected. sql select value$ from sys.props$ wh
[zhang@zhangshibo /]$ sqlplus /nolog
sql*plus: release 11.2.0.1.0 production on wed oct 17 11:27:49 2012
copyright (c) 1982, 2009, oracle. all rights reserved.
sql> connect sys/orcl as sysdba;
connected.
sql> select value$ from sys.props$ where name='global_db_name';
value$
--------------------------------------------------------------------------------
orcl.sdg.ac.cn
sql> show parameter service_names;
name type value
------------------------------------ ----------- ------------------------------
service_names string orcl
sql>
sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql> startup mount
oracle instance started.
total system global area 1720328192 bytes
fixed size 2214056 bytes
variable size 1174407000 bytes
database buffers 536870912 bytes
redo buffers 6836224 bytes
database mounted.
sql>
sql> select status from v$instance;
status
------------
mounted
sql>
sql> alter database open;
database altered.
sql>