[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
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>
查看更多关于oraclesqlplus命令实例的详细内容...