Solaris 下的 oracle 的基本操作。
2024-08-29 13:46:10
供稿：網(wǎng)友
一、啟動、關(guān)閉數(shù)據(jù)庫
1、啟動數(shù)據(jù)庫監(jiān)聽
su - Oracle---切換oracle用戶(假如使用su oracle ，則啟動時不運行.PRofile用戶環(huán)境配置文件)
$ lsnrctl start－－－啟動監(jiān)聽
2、啟動數(shù)據(jù)庫
$ sqlplus "/ as sysdba"－－－用sys用戶登陸sqlplus
SQL*Plus: Release 9.2.0.5.0 - ProdUCtion on Thu Oct 9 15:06:11 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup－－－啟動數(shù)據(jù)庫
ORACLE instance started.
Total System Global Area 538412728 bytes
Fixed Size 743096 bytes
Variable Size 268435456 bytes
Database Buffers 268435456 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
SQL> exit－－－退出sqlplus
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
或者
$dbstart
3、查看數(shù)據(jù)庫進(jìn)程
$ ps -efgrep ora_－－－查看oracle進(jìn)程
oracle 688322 1 0 15:06:20 - 0:00 ora_smon_bxmis
oracle 696534 704704 0 15:06:35 pts/4 0:00 grep ora_
oracle 729224 1 0 15:06:20 - 0:00 ora_dbw0_bxmis
oracle 745618 1 0 15:06:20 - 0:00 ora_reco_bxmis
oracle 770216 1 0 15:06:20 - 0:00 ora_ckpt_bxmis
oracle 778394 1 0 15:06:20 - 0:00 ora_pmon_bxmis
oracle 843876 1 0 15:06:20 - 0:00 ora_qmn0_bxmis
oracle 901342 1 0 15:06:20 - 0:00 ora_lgwr_bxmis
oracle 925704 1 0 15:06:20 - 0:00 ora_cjq0_bxmis
$ ps -efgrep lsnr－－－查看oracle監(jiān)聽進(jìn)程
4、關(guān)閉數(shù)據(jù)庫
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:07:04 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
SQL> shutdown immediate－－－關(guān)閉數(shù)據(jù)庫
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
或者
$dbshut
5、停止數(shù)據(jù)庫監(jiān)聽
$ lsnrctl stop－－－停止監(jiān)聽
