admin 管理员组

文章数量: 887031


2023年12月23日发(作者:jdk8环境变量)

[oracle@rac1 database]$ cat /u01/app/oracle/cfgtoollogs/dbca/orcl/ying database filesDBCA_PROGRESS : 1%DBCA_PROGRESS : 3%DBCA_PROGRESS : 9%DBCA_PROGRESS : 15%DBCA_PROGRESS : 21%DBCA_PROGRESS : 27%DBCA_PROGRESS : 30%Creating and starting Oracle instanceDBCA_PROGRESS : 32%DBCA_PROGRESS : 36%DBCA_PROGRESS : 40%ORA-12714: invalid national character set specifiedDBCA_PROGRESS : 44%DBCA_PROGRESS : 45%DBCA_PROGRESS : 48%DBCA_PROGRESS : 50%Creating cluster database viewsDBCA_PROGRESS : 52%DBCA_PROGRESS : 70%Completing Database CreationDBCA_PROGRESS : 73%DBCA_PROGRESS : 76%DBCA_PROGRESS : 85%DBCA_PROGRESS : 94%DBCA_PROGRESS : 100%Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/se Information:Global Database Name:orclSystem Identifier(SID) Prefix:orcl三、查看 grid 集群状态

[grid@rac1 bin]$ su - gridPassword:

[grid@rac1 ~]$ crs_stat -tName Type Target State Host

------------------------------------------------------------ ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

OFFLINE OFFLINE

ONLINE ONLINE rac1

4j ONLINE ONLINE rac1

ONLINE ONLINE rac1

####################################################################################### ONLINE ONLINE rac1 ##

数据库服务####################################################################################### application ONLINE ONLINE rac1

application ONLINE ONLINE rac1

application OFFLINE OFFLINE

application ONLINE ONLINE rac1

ONLINE ONLINE rac1

application ONLINE ONLINE rac2

application ONLINE ONLINE rac2

application OFFLINE OFFLINE

application ONLINE ONLINE rac2

ONLINE ONLINE rac2

ONLINE ONLINE rac1

四、关闭和启动 grid 集群1、关闭 grid 集群关闭 grid 集群之前先关闭数据库服务,然后关闭 grid 集群。(1)关闭数据库查看 grid 集群的状态:

[grid@rac2 ~]$ crs_stat -tName Type Target State Host

------------------------------------------------------------ ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac2

OFFLINE OFFLINE

ONLINE ONLINE rac1

4j ONLINE ONLINE rac2

ONLINE ONLINE rac1

####################################################################################### ONLINE ONLINE rac1 ##

数据库服务####################################################################################### application ONLINE ONLINE rac1

application ONLINE ONLINE rac1

application OFFLINE OFFLINE

application ONLINE ONLINE rac1

ONLINE ONLINE rac1

application ONLINE ONLINE rac2

application ONLINE ONLINE rac2

application OFFLINE OFFLINE

application ONLINE ONLINE rac2

ONLINE ONLINE rac2

ONLINE ONLINE rac1

关闭数据库服务:[grid@rac2 ~]$ srvctl stop database -d orcl查看 grid 集群的状态:[grid@rac2 ~]$ crs_stat -tName Type Target State Host

------------------------------------------------------------ ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac2

OFFLINE OFFLINE

ONLINE ONLINE rac1

4j ONLINE ONLINE rac2

ONLINE ONLINE rac1

####################################################################################### OFFLINE OFFLINE ##数据库服务关闭####################################################################################### application ONLINE ONLINE rac1

application ONLINE ONLINE rac1

application OFFLINE OFFLINE

application ONLINE ONLINE rac1

ONLINE ONLINE rac1

application ONLINE ONLINE rac2

application ONLINE ONLINE rac2

application OFFLINE OFFLINE

application ONLINE ONLINE rac2

ONLINE ONLINE rac2

ONLINE ONLINE rac1

[grid@rac2 ~]$ crs_stat -tName Type Target State Host

------------------------------------------------------------ ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

OFFLINE OFFLINE

ONLINE ONLINE rac1

4j ONLINE ONLINE rac1

ONLINE ONLINE rac1

OFFLINE OFFLINE ###数据库服务没有启动

application ONLINE ONLINE rac1

application ONLINE ONLINE rac1

application OFFLINE OFFLINE

application ONLINE ONLINE rac1

ONLINE ONLINE rac1

application ONLINE ONLINE rac2

application ONLINE ONLINE rac2

application OFFLINE OFFLINE

application ONLINE ONLINE rac2

ONLINE ONLINE rac2

ONLINE ONLINE rac1

启动数据库服务:[grid@rac1 ~]$ srvctl start database -d orcl查看 grid 集群的状态:[grid@rac2 ~]$ crs_stat -tName Type Target State Host

------------------------------------------------------------ ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1

OFFLINE OFFLINE

ONLINE ONLINE rac1

4j ONLINE ONLINE rac1

ONLINE ONLINE rac1

ONLINE ONLINE rac1 ##数据库已经启动

application ONLINE ONLINE rac1

application ONLINE ONLINE rac1

application OFFLINE OFFLINE

application ONLINE ONLINE rac1

ONLINE ONLINE rac1

application ONLINE ONLINE rac2

application ONLINE ONLINE rac2

application OFFLINE OFFLINE

application ONLINE ONLINE rac2

ONLINE ONLINE rac2

ONLINE ONLINE rac1


本文标签: 数据库 集群 关闭