您好,欢迎访问一九零五行业门户网

oracle sqlplus 命令实例

[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>
其它类似信息

推荐信息