[zhang@zhangshibo /]$ sqlplus
本文来源gao!%daima.com搞$代*!码网1
/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>
转载请注明原文链接：oracle sqlplus 命令实例
