环境为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_
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/438414/viewspace-753446/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/438414/viewspace-753446/