检查安装结果
安装完成后，您需要进行必要的检查，以验证数据库是否安装成功。

检查Oracle监听状态
介绍如何检查监听状态。本任务需要在各服务器节点中分别执行。
检查Oracle实例状态
介绍如何检查Oracle实例状态。本任务需要在各服务器节点中分别执行。
检查CRS集群状态
介绍如何检查CRS集群状态。本任务需要在各服务器节点中分别执行。

 

操作步骤
1.以oracle用户分别登录各服务器节点。
2.查看监听状态。

lsnrctl status LISTENER_ORA
在节点shdb1中显示类似如下信息时表示监听正常。

 

oracle@shdb1:~> lsnrctl status LISTENER_ORA

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-AUG-2020 15:18:15

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ORA)))
STATUS of the LISTENER
------------------------
Alias listener_ora
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 10-AUG-2020 15:05:39
Uptime 0 days 0 hr. 12 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/product/network/admin/listener.ora
Listener Log File /opt/app/oracle/diag/tnslsnr/shdb1/listener_ora/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ORA)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1526)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.30)(PORT=1526)))
Services Summary...
Service "shinfo" has 1 instance(s).
Instance "shinfo1", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@shdb1:~>

在节点shdb2中显示类似如下信息时表示监听正常。

oracle@shdb2:~> lsnrctl status LISTENER_ORA

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-AUG-2020 14:54:58

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ORA)))
STATUS of the LISTENER
------------------------
Alias listener_ora
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 10-AUG-2020 14:38:31
Uptime 0 days 0 hr. 16 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/product/network/admin/listener.ora
Listener Log File /opt/app/oracle/diag/tnslsnr/shdb2/listener_ora/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ORA)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.20)(PORT=1526)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.40)(PORT=1526)))
Services Summary...
Service "shinfo" has 1 instance(s).
Instance "shinfo2", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@shdb2:~>

检查Oracle实例状态

介绍如何检查Oracle实例状态。本任务需要在各服务器节点中分别执行。

操作步骤
1.以oracle用户分别登录各服务器节点。
2.登录数据库。

sqlplus / as sysdba
select INSTANCE_NAME, STATUS from v$instance;

oracle@shdb1:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 10 15:23:24 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

select INSTANCE_NAME, STATUS from v$instance;
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

INSTANCE_NAME STATUS
---------------- ------------
shinfo1 OPEN

 

oracle@shdb2:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 10 14:56:33 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

select INSTANCE_NAME, STATUS from v$instance;
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

INSTANCE_NAME STATUS
---------------- ------------
shinfo2 OPEN

SQL>

查CRS集群状态
介绍如何检查CRS集群状态。本任务需要在各服务器节点中分别执行。
操作步骤
1.以grid用户分别登录各服务器节点。
2.执行olsnodes命令查看集群关系是否建立成功。
2个节点中都显示类似如下信息，说明创建成功。
shdb1
shdb2

3.执行crsctl stat res -t命令查看集群状态。
2个节点中都显示类似如下信息，说明集群状态正常。