環境為clusterware +oracle 11.2.0.1.0

列出配置的所有資料庫

[oracle@localhost ~]$ srvctl config database

ORCL

顯示資料庫的配置

[oracle@localhost ~]$ srvctl config database -d orcl

資料庫唯一名稱: ORCL

資料庫名: ORCL

Oracle 主目錄: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle 使用者: grid

Spfile: +DATA/ORCL/spfileORCL.ora

域:

啟動選項: open

停止選項: immediate

資料庫角色: PRIMARY

管理策略: AUTOMATIC

磁碟組: DATA,FRA

服務:

顯示 ASM 例項的配置

[oracle@localhost ~]$ srvctl config asm

ASM 主目錄: /u01/app/grid/product/11.2.0/grid

ASM 監聽程式: LISTENER

Spfile: +DATA/asm/asmparameterfile/registry.253.803427691

ASM 磁碟組搜尋字串:

檢視監聽狀態

[oracle@localhost ~]$ srvctl status listener

監聽程式 LISTENER 已啟用

監聽程式 LISTENER 正在節點上執行: localhost

檢視資料庫狀態

[oracle@localhost ~]$ srvctl status database -d orcl

資料庫正在執行。

資料庫例項的啟動和關閉

[oracle@localhost ~]$ ps -ef|grep ora_

oracle 3741 1 0 22:27 ? 00:00:00 ora_pmon_ORCL

oracle 3743 1 0 22:27 ? 00:00:00 ora_vktm_ORCL

oracle 3747 1 0 22:27 ? 00:00:00 ora_gen0_ORCL

oracle 3749 1 0 22:27 ? 00:00:00 ora_diag_ORCL

oracle 3751 1 0 22:27 ? 00:00:00 ora_dbrm_ORCL

oracle 3753 1 0 22:27 ? 00:00:00 ora_psp0_ORCL

oracle 3755 1 0 22:27 ? 00:00:00 ora_dia0_ORCL

oracle 3757 1 0 22:27 ? 00:00:00 ora_mman_ORCL

oracle 3759 1 0 22:27 ? 00:00:00 ora_dbw0_ORCL

oracle 3761 1 0 22:27 ? 00:00:00 ora_lgwr_ORCL

oracle 3763 1 0 22:27 ? 00:00:00 ora_ckpt_ORCL

oracle 3765 1 0 22:27 ? 00:00:00 ora_smon_ORCL

oracle 3767 1 0 22:27 ? 00:00:00 ora_reco_ORCL

oracle 3769 1 0 22:27 ? 00:00:00 ora_rbal_ORCL

oracle 3771 1 0 22:27 ? 00:00:00 ora_asmb_ORCL

oracle 3773 1 0 22:27 ? 00:00:00 ora_mmon_ORCL

oracle 3775 1 0 22:27 ? 00:00:00 ora_mmnl_ORCL

oracle 3777 1 0 22:27 ? 00:00:00 ora_d000_ORCL

oracle 3781 1 0 22:27 ? 00:00:00 ora_s000_ORCL

oracle 3783 1 0 22:27 ? 00:00:00 ora_mark_ORCL

oracle 3847 1 0 22:28 ? 00:00:00 ora_qmnc_ORCL

oracle 3868 1 0 22:28 ? 00:00:00 ora_cjq0_ORCL

oracle 3872 1 0 22:28 ? 00:00:00 ora_q000_ORCL

oracle 3874 1 0 22:28 ? 00:00:00 ora_q001_ORCL

oracle 3876 1 0 22:28 ? 00:00:00 ora_vkrm_ORCL

oracle 3937 1 0 22:33 ? 00:00:00 ora_smco_ORCL

oracle 4119 1 0 22:43 ? 00:00:00 ora_w000_ORCL

oracle 4282 1 0 22:48 ? 00:00:00 ora_o000_ORCL

oracle 4386 1 0 22:52 ? 00:00:00 ora_j000_ORCL

oracle 4388 1 0 22:52 ? 00:00:00 ora_j001_ORCL

oracle 4390 4008 0 22:52 pts/1 00:00:00 grep ora_

[oracle@localhost ~]$ srvctl stop database -d orcl

[oracle@localhost ~]$ ps -ef|grep ora_

oracle 4425 4008 0 22:53 pts/1 00:00:00 grep ora_

[oracle@localhost ~]$ srvctl start database -d ORCL

[oracle@localhost ~]$ ps -ef|grep ora_

oracle 4673 1 0 22:54 ? 00:00:00 ora_pmon_ORCL

oracle 4675 1 0 22:54 ? 00:00:00 ora_vktm_ORCL

oracle 4679 1 0 22:54 ? 00:00:00 ora_gen0_ORCL

oracle 4681 1 0 22:54 ? 00:00:00 ora_diag_ORCL

oracle 4683 1 0 22:54 ? 00:00:00 ora_dbrm_ORCL

oracle 4685 1 0 22:54 ? 00:00:00 ora_psp0_ORCL

oracle 4687 1 0 22:54 ? 00:00:00 ora_dia0_ORCL

oracle 4689 1 0 22:54 ? 00:00:00 ora_mman_ORCL

oracle 4691 1 0 22:54 ? 00:00:00 ora_dbw0_ORCL

oracle 4693 1 0 22:54 ? 00:00:00 ora_lgwr_ORCL

oracle 4695 1 0 22:54 ? 00:00:00 ora_ckpt_ORCL

oracle 4697 1 0 22:54 ? 00:00:00 ora_smon_ORCL

oracle 4699 1 0 22:54 ? 00:00:00 ora_reco_ORCL

oracle 4701 1 0 22:54 ? 00:00:00 ora_rbal_ORCL

oracle 4703 1 0 22:54 ? 00:00:00 ora_asmb_ORCL

oracle 4705 1 1 22:54 ? 00:00:00 ora_mmon_ORCL

oracle 4707 1 0 22:54 ? 00:00:00 ora_mmnl_ORCL

oracle 4711 1 0 22:54 ? 00:00:00 ora_d000_ORCL

oracle 4713 1 0 22:54 ? 00:00:00 ora_s000_ORCL

oracle 4715 1 0 22:54 ? 00:00:00 ora_mark_ORCL

oracle 4766 1 0 22:54 ? 00:00:00 ora_o000_ORCL

oracle 4770 1 0 22:54 ? 00:00:00 ora_o001_ORCL

oracle 4774 1 0 22:54 ? 00:00:00 ora_qmnc_ORCL

oracle 4792 1 3 22:54 ? 00:00:00 ora_cjq0_ORCL

oracle 4794 1 0 22:54 ? 00:00:00 ora_vkrm_ORCL

oracle 4796 1 12 22:54 ? 00:00:00 ora_j000_ORCL

oracle 4798 1 0 22:54 ? 00:00:00 ora_j001_ORCL

oracle 4800 4008 0 22:54 pts/1 00:00:00 grep ora_

透過 srvctl來管理單例項11g資料庫

相關文章