What's SQL*Plus?
It's a client for oracle database. It's used to excute sql commond,generate basic report. After 8i, you can start and stop db instantce from SQL*Plus.
HOWTO: SS Instance
sqlplus/nolog ->connect sys/password as sysdba -> startup [mount, nomount](start instance,database mount, database open) -> shutdown [immediate,transactional,abort]
Notice: a. Sys account must login as sysdba! So you can not use isqlplus with sys account.
b. Set sqlblankline on.
c. Sql language is not sensitive to case of charactor. But Recommoned that Sql commond should be Upper case.
d. subsititution varible is recommoned to use. "SELECT * FROM test where ID=&tt" .
e. "L" view cached sql commonds "/" excute "DEL" delete cached comoonds "A" append to cached commond "Save" save commond in file. "@" excute saved commond in file.
Tips: Auto Archive Mode Startup:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Current log sequence 27
SQL> show parameter log_archive_start
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 3204448256 bytes
Fixed Size 1304912 bytes
Variable Size 651957936 bytes
Database Buffers 2550136832 bytes
Redo Buffers 1048576 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27
SQL>