連接數據庫
C:>SQLPLUS /NOLOG

SQL>CONN / AS SYSDBA

1.Oracle 關(guān)閉
SQL>SHUTDOWN (ABORT|IMMEDIATE|NORMAL)

2.Oracle 啟動(dòng)
SQL>STARTUP (REMOUNT|MOUNT|OPENT)

3.SQL> HELP SHOW

SHOW
----

Shows the value of a SQL*Plus system variable, or the
current SQL*Plus environment.

SHO[W] option

where option represents one of the following terms or clauses:
     system_variable
     ALL
     BTI[TLE]
     ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER
        | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
     LNO
     PARAMETERS [parameter_name]
     PNO
     REL[EASE]
     REPF[OOTER]
     REPH[EADER]
     SGA
     SPOO[L]
     SQLCODE
     TT[ITLE]
     USER

SHOW SPOOL is not available in iSQL*Plus

4.TNSPING
TNS連接問(wèn)題檢測
TNSNAME.ORA


5.執行SQL Script
SQL>@C:\RUN.SQL


6.查看執行結果（開(kāi)啟/關(guān)閉）
SQL>SET ECHO ON(OFF)

7.常用配置
SQL>SET LINESIZE 1000
SQL>ECHO ON
SQL>SET TIMING ON
SQL>SPOOL C:\TEST.LOG
SQL>SELECT * FROM XXXXX
SQL>SPOOL OFF

8.授權
建立連接 GRANT CREATE SESSION TO USERNAME
移除連接 REVOKE CREATE SESSION TO USERNAME
其他授權
GRANT SELECT,INSERT,DELETE,UPDATE ON SCOTT.EMP TO USERNAME
確認更改
SQL>COMMIT

9.更改密碼
Alter user username identified by password

10.察看Datafile
SQL>SELECT * FROM V$DATAFILE

11察看結構
SQL>DESC V$DATAFILE

12,察看DB File
SQL>SELECT * FROM V$DBFILE

13.察看Tablespace
SQL>SELECT * FROM V$TABLESPACE

14.察看SGA大小
SQL> SHOW PARAMETER SGA

15.更改 SGA大小，
SQL>ALTER SYSTEM SET SHARED_POOL_SIZE=..M

16.察看CONTROLFILE
SQL> SELECT * FROM V$CONTROLFILE

17察看REDO LOG
SQL> SELECT * FROM V$CONTROLFILE

18.察看所有的用戶(hù)
SQL> SELECT USERNAME FROM DBA_USERS

19.在Offline狀態(tài)下搬遷數據庫文件
關(guān)閉數據庫
SQL>SHUTDOWN IMMEDIATE
搬遷數據文件
連接數據庫
SQL>CONN / AS SYSDBA
SQL>STARTUP MOUNT
SQL>Alter database rename file ‘e:\.......’ to ‘c:\.......’
SQL>ALTER DATABASE OPEN
SQL>SHUTDOWN
刪除舊的數據文件

20.更改ONLINE REDO LOG
SQL>ALTER SYSTEM SWITCH LOGFILE;

================================================================================================================
檢查數據庫連通
C:\DOCUMENTS AND SETTINGS\YINGLINHAI> TNSPING

數據庫偵聽(tīng)
C:\DOCUMENTS AND SETTINGS\YINGLINHAI> lsnrctl

查看SID
SQL> SELECT * FROM V$INSTANCE;
SQL> SELECT * FROM V$DATABASE;

SQL> / 執行上個(gè)操作命令
SQL> EDIT讀取命令緩存區

查看語(yǔ)言配置
SQL> show parameters nls
SQL> select * from V$NLS_PARAMETERS

查看啟動(dòng)參數文件
SQL> show parameters spfile;

查看數據塊配置大小
SQL> show parameters db;

查看ORACLE版本
SQL> SELECT * FROM V$VERSION

顯示所有組建版本
SQL> select * from product_component_version;

配置輸出日志
SQL> spool c:\testora.log
SQL> spool off

切換歸檔日志
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
SQL> ALTER SYSTEM SWITCH LOGFILE;

查看數據庫對象結構
SQL> desc v$dbfile

查看Datafile
SQL>SELECT * FROM V$DBFILE;
SQL>SELECT * FROM V$DATAFILE;

查看所有的用戶(hù)
SQL> SELECT USERNAME FROM DBA_USERS

查看控制文件
SQL> select * from v$controlfile;

設置輸出的行寬
SQL> set linesize 20000

查看REDOLOG文件
SQL> SELECT * FROM V$LOGFILE;

查看表空間
SQL> SELECT * FROM V$tablespace;

手動(dòng)刪除歸檔日志后，同步CATALOG
SQL>CROSSCHECK ARCHIVELOG ALL
SQL>CHANGE ARCHIVELOG ALL CROSSCHECK