oracle中overwrite写法,【学习笔记】Oracle 11G新特性restart的深入研究案例

【学习笔记】Oracle 11G新特性restart的深入研究案例

时间:2016-11-26 22:35   来源:Oracle研究中心   作者:网络   点击:

次

天萃荷净

Oracle研究中心学习笔记：分享一篇关于Oracle数据库11GR2新特性的笔记，详细介绍oracle 11gR2的restart特性的研究案例。

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客

本文链接地址: oracle restart 体验

关于oracle 11gR2的restart特性，早就听说了，但一直没有亲身体验过，今天简单的进行了相关的测试，在部署环境过程中遇到个小问题，安装过程中执行root.sh报错，如下：

[root@11gR2test ~]# /home/ora11g/product/11.2/grid/root.sh

Running Oracle 11g root script...

The http://www.oracleplus.netfollowing environment variables are set as:

ORACLE_OWNER= ora11g

ORACLE_HOME=  /home/ora11g/product/11.2/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/ora11g/product/11.2/grid/crs/install/crsconfig_params

Creating trace directory

LOCAL ADD MODE

Creating OCR keys for user 'ora11g', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node 11gr2test successfully pinned.

Adding daemon to inittab

ohasd failed to start

Failed to start the Clusterware. Last 20 lines of the alert log follow:

2011-10-08 22:24:52.838

[client(7511)]CRS-2101:The OLR was formatted using version 3.

2011-10-08 22:24:54.073

[client(7532)]CRS-1001:The OCR was formatted using version 3.

[client(7574)]CRS-10001:CRS-6021: No msg for has:crs-6021 [l][unlimited]

[client(7575)]CRS-10001:CRS-6021: No msg for has:crs-6021 [n][65536]

ohasd failed to start at /home/ora11g/product/11.2/grid/crs/install/roothas.pl line 325.

/home/ora11g/product/11.2/grid/perl/bin/perl -I/home/ora11g/product/11.2/grid/perl/lib -I/home/ora11g/product/11.2/grid/crs/install /home/ora11g/product/11.2/grid/crs/install/roothas.pl execution failed

关于该问题类类似文件，大家可以参考如下两个MOS文档：

OHASD Failed to Start: Inappropriate ioctl for device [ID 1069182.1]

Troubleshooting 11.2 Grid Infastructure Installation Root.sh Issues [ID 1053970.1]

How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation [ID 942166.1]

特别是第3个文档，十分有用，主要是一个root.sh执行失败以后如何重跑的东西。

环境搞好以后，如下：

[ora11g@localhost database]$ cd /home/ora11g/11.2/grid/bin

[ora11g@localhost bin]$ ./crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE    ONLINE    localhost

ora.cssd       ora.cssd.type  ONLINE    ONLINE    localhost

ora.diskmon    ora....on.type ONLINE    ONLINE    localhost

ora.evmd       ora.evm.type   ONLINE    ONLINE    localhost

ora.ons        ora.ons.type   OFFLINE   OFFLINE

ora.roger.db   ora....se.type ONLINE    ONLINE    localhost

[ora11g@localhost database]$ srvctl config database -d roger

Database unique name: roger

Database name: roger

Oracle home: /home/ora11g/product/11.2/db

Oracle user: ora11g

Spfile:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Disk Groups:

Services:

[ora11g@localhost database]$ srvctl status database -d roger

Database is running.

====== 下面测试一下restart功能是否好使 ======

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   10174     1  0 00:31          00:00:00 /home/ora11g/11.2/grid/bin/tnslsnr LISTENER -inherit

ora11g   27750  4783  0 02:30 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ kill -9 10174

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27753  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27766  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27768  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27770  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27772  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27774  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ./crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE    ONLINE    localhost

ora.cssd       ora.cssd.type  ONLINE    ONLINE    localhost

ora.diskmon    ora....on.type ONLINE    ONLINE    localhost

ora.evmd       ora.evm.type   ONLINE    ONLINE    localhost

ora.ons        ora.ons.type   OFFLINE   OFFLINE

ora.roger.db   ora....se.type ONLINE    ONLINE    localhost

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27887  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27890  4783  0 02:31 pts/1    00:00:00 grep tns

[ora11g@localhost bin]$ ps -ef|grep tns

ora11g   27900     1  0 02:31          00:00:00 /home/ora11g/11.2/grid/bin/tnslsnr LISTENER -inherit

我们发现listener自动重起了，关于这里测试的过程中，listener restart的具体时间间隔？

比如说，oracle它如何知道listener已经停掉了？当检测到listener停掉以后，在多少时间内去restart listener？

关于这个小问题，我们可以同listener的profile信息得到答案：

[ora11g@localhost bin]$ ./crs_stat -p ora.LISTENER.lsnr

NAME=ora.LISTENER.lsnr

TYPE=ora.listener.type

ACTION_SCRIPT=

AUTO_START=restore

CHECK_INTERVAL=60

DESCRIPTION=CRS resource type for the Listener

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=60

START_TIMEOUT=180

STOP_TIMEOUT=0

UPTIME_THRESHOLD=1d

我们可以看到是60s检测一下，检测到之后立即重启，如果启动失败，会在180s内再次进行restart。

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】Oracle 11G新特性restart的深入研究案例