【工具】一款oracle rac 检查工具
2023-09-14 08:57:29 时间
一 raccheck 是什么
RACcheck is a RAC Configuration Audit tool designed to audit various important configuration settings within a Real Application Clusters (RAC), Oracle Clusterware (CRS), Automatic Storage Management (ASM) and Grid Infrastructure environment.
raccheck 可以审计如下组件的配置信息:
1 OS kernel parameters
2 OS packages
3 Many other OS configuration settings important to RAC.
4 CRS/Grid Infrastructure
5 RDBMS
6 ASM
7 Database parameters
8 Many other database configuration settings important to RAC
9 11.2.0.3 Upgrade Readiness assessment 二 支持的版本
3 rules.dat 其中collections.dat rules.dat 称为raccheck的驱动。注意:一个raccheck工具的驱动不能手工更改! 四 何时使用 1 第一次安装完成rac 2 在例行的os维护之前 3 在例行的os维护之后 4 至少三个月一次 五 提供那些参数: 仅仅在数据库服务器上以oracle用户安装和运行该软件即可,如果没有则需要在root 用户下了!
raccheck 有以下几个参数: 1. -a - performs all checks, best practice and Database/Clusterware patch/OS recommendations.
2. -b - best practice recommendations only
3. -p - database/clusterware patch recommendations only
4. -f - offline, performs analysis for all
5. -u - performs pre-upgrade and post-upgrade readiness checks (see Appendix M for a full
description of the upgrade readiness feature)
a. supports upgrade readiness checks for upgrading to 11.2.0.3 or higher
b. Pre-upgrade (11.2.0.3) checks require the additional argument pre (specified by -o):
$ ./raccheck -u -o pre
c. Post-upgrade (11.2.0.3) checks require the additional argument post (specified by -o):
$ ./raccheck -u -o post
6. -S - please see the How to Run RACcheck Silently section for more on this argument
7. -s - please see the How to Run RACcheck Silently section for more on this argument
8. -c - for use when checking individual components, for example:
For only ASM Component Checks:
$ ./raccheck -a -c ASM
For only ACFS Component Checks:
$ ./raccheck -a -c ACFS
9. -o - for invoking various optional functionality:
v or verbose would display PASSing audit checks as well as non-
PASSing:
$ ./raccheck -a -o v
$ ./raccheck -a -o verbose
$ ./raccheck -a -c ASM -o verbose
10. -v - returns the version of the tool
11. -m - supresses the Maximum Availability Architecture Scorecard which is now enabled by default in RACcheck ! 六 如何使用RACcheck 1 以oracle 用户(如果没有安装oracle rdbms ,则以root 用户执行) 2 在将要执行racckeck 工具的节点的本地目录上 accheck -- 3 unzip raccheck.zip 工具 将脚本和驱动文件放到同一个目录下。 4 验证此工具是否具有+x 权限,如果没有则: chmod +x raccheck 5 执行如下命令: ./raccheck -a 将会出现如下样式的输出: oracle@rac1:/home/oracle/software ./raccheck -a
CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /opt/rac/11.2.0/grid?[y/n][y]y
Checking ssh user equivalency settings on all nodes in cluster
Node rac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
.
List of running databases registered in OCR
1. rac
2. None of above
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
. .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
rac1 Yes Yes Yes Yes Yes Yes rac1
rac2 Yes Yes Yes Yes Yes Yes rac2
-------------------------------------------------------------------------------------------------------
96 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which require root privileged data collection can be skipped.
1. Enter 1 if you will enter root password for each host when prompted
2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script
3. Enter 3 to skip the root privileged collections
4. Enter 4 to exit and work with the SA to configure sudo or to arrange for root access and run the tool later.
Please indicate your selection from one of the above options[1-4][1]:- 1
*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
Log file for collections and audit checks are at
/home/oracle/software/raccheck_070212_202946/raccheck.log
如果选择了1 则下下面的提示中会让用户输入root的密码:如果没有在规定时间内提供密码,以root权限进行的收集工作会被kill掉并继续进行!如下所示
如果及时提供了root用户的密码,则结果如下图:
6 当整个raccheck 工具检查完成之后会生成如下文件:zip 文件和 执行raccheck过程的目录存放临时文件 还有 html文件
用户可以把生产的文体交给sr 以便进行分析~!
【Oracle】oracle sqluldr2工具使用方法 oracle数据导出工具sqluldr2可以将数据以csv、txt等格式导出,适用于大批量数据的导出,导出速度非常快。导出后可以使用oracle loader工具将数据导入。
yugong阿里巴巴去Oracle数据迁移同步工具(全量+增量,目标支持MySQL/DRDS) 2008年,阿里巴巴开始尝试使用 MySQL 支撑其业务,开发了围绕 MySQL 相关的中间件和工具,Cobar/TDDL(目前为阿里云DRDS产品),解决了单机 Oracle 无法满足的扩展性问题,当时也掀起一股去IOE项目的浪潮,愚公这项目因此而诞生,其要解决的目标就是帮助用户完成从 Oracle 数据迁移到 MySQL 上,完成去 IOE 的重要一步工作。
Oracle MySQL相关工具replace操作实现方式区别 本文列举MySQL、Oracle、常用数据导入工具碰到主键冲突、唯一约束、以及其他对重复数据、已有数据的处理区别,并介绍MySQL、Oracle replace相关语句实现区别。 由此可见在实际使用不同数据库过程中,还是有许多差别,需要大家细心留意。
2 OS packages
3 Many other OS configuration settings important to RAC.
4 CRS/Grid Infrastructure
5 RDBMS
6 ASM
7 Database parameters
8 Many other database configuration settings important to RAC
9 11.2.0.3 Upgrade Readiness assessment 二 支持的版本
3 rules.dat 其中collections.dat rules.dat 称为raccheck的驱动。注意:一个raccheck工具的驱动不能手工更改! 四 何时使用 1 第一次安装完成rac 2 在例行的os维护之前 3 在例行的os维护之后 4 至少三个月一次 五 提供那些参数: 仅仅在数据库服务器上以oracle用户安装和运行该软件即可,如果没有则需要在root 用户下了!
raccheck 有以下几个参数: 1. -a - performs all checks, best practice and Database/Clusterware patch/OS recommendations.
2. -b - best practice recommendations only
3. -p - database/clusterware patch recommendations only
4. -f - offline, performs analysis for all
5. -u - performs pre-upgrade and post-upgrade readiness checks (see Appendix M for a full
description of the upgrade readiness feature)
a. supports upgrade readiness checks for upgrading to 11.2.0.3 or higher
b. Pre-upgrade (11.2.0.3) checks require the additional argument pre (specified by -o):
$ ./raccheck -u -o pre
c. Post-upgrade (11.2.0.3) checks require the additional argument post (specified by -o):
$ ./raccheck -u -o post
6. -S - please see the How to Run RACcheck Silently section for more on this argument
7. -s - please see the How to Run RACcheck Silently section for more on this argument
8. -c - for use when checking individual components, for example:
For only ASM Component Checks:
$ ./raccheck -a -c ASM
For only ACFS Component Checks:
$ ./raccheck -a -c ACFS
9. -o - for invoking various optional functionality:
v or verbose would display PASSing audit checks as well as non-
PASSing:
$ ./raccheck -a -o v
$ ./raccheck -a -o verbose
$ ./raccheck -a -c ASM -o verbose
10. -v - returns the version of the tool
11. -m - supresses the Maximum Availability Architecture Scorecard which is now enabled by default in RACcheck ! 六 如何使用RACcheck 1 以oracle 用户(如果没有安装oracle rdbms ,则以root 用户执行) 2 在将要执行racckeck 工具的节点的本地目录上 accheck -- 3 unzip raccheck.zip 工具 将脚本和驱动文件放到同一个目录下。 4 验证此工具是否具有+x 权限,如果没有则: chmod +x raccheck 5 执行如下命令: ./raccheck -a 将会出现如下样式的输出: oracle@rac1:/home/oracle/software ./raccheck -a
CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /opt/rac/11.2.0/grid?[y/n][y]y
Checking ssh user equivalency settings on all nodes in cluster
Node rac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
.
List of running databases registered in OCR
1. rac
2. None of above
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1
. .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
rac1 Yes Yes Yes Yes Yes Yes rac1
rac2 Yes Yes Yes Yes Yes Yes rac2
-------------------------------------------------------------------------------------------------------
96 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which require root privileged data collection can be skipped.
1. Enter 1 if you will enter root password for each host when prompted
2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script
3. Enter 3 to skip the root privileged collections
4. Enter 4 to exit and work with the SA to configure sudo or to arrange for root access and run the tool later.
Please indicate your selection from one of the above options[1-4][1]:- 1
*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
Log file for collections and audit checks are at
/home/oracle/software/raccheck_070212_202946/raccheck.log
如果选择了1 则下下面的提示中会让用户输入root的密码:如果没有在规定时间内提供密码,以root权限进行的收集工作会被kill掉并继续进行!如下所示
![22664653_201207022220101.jpg](http://blog.itpub.net/attachments/2012/07/22664653_201207022220101.jpg)
![22664653_201207022221301.jpg](http://blog.itpub.net/attachments/2012/07/22664653_201207022221301.jpg)
![22664653_201207022220271.jpg](http://blog.itpub.net/attachments/2012/07/22664653_201207022220271.jpg)
【Oracle】oracle sqluldr2工具使用方法 oracle数据导出工具sqluldr2可以将数据以csv、txt等格式导出,适用于大批量数据的导出,导出速度非常快。导出后可以使用oracle loader工具将数据导入。
yugong阿里巴巴去Oracle数据迁移同步工具(全量+增量,目标支持MySQL/DRDS) 2008年,阿里巴巴开始尝试使用 MySQL 支撑其业务,开发了围绕 MySQL 相关的中间件和工具,Cobar/TDDL(目前为阿里云DRDS产品),解决了单机 Oracle 无法满足的扩展性问题,当时也掀起一股去IOE项目的浪潮,愚公这项目因此而诞生,其要解决的目标就是帮助用户完成从 Oracle 数据迁移到 MySQL 上,完成去 IOE 的重要一步工作。
Oracle MySQL相关工具replace操作实现方式区别 本文列举MySQL、Oracle、常用数据导入工具碰到主键冲突、唯一约束、以及其他对重复数据、已有数据的处理区别,并介绍MySQL、Oracle replace相关语句实现区别。 由此可见在实际使用不同数据库过程中,还是有许多差别,需要大家细心留意。
相关文章
- 推荐第三方Oracle客户端查询工具
- 【Oracle】并行等待之PX Deq Credit: need buffer
- 【Oracle】Opatch 工具介绍
- 【Python Oracle】使用cx_Oracle 连接oracle的简单介绍
- struts+hibernate+oracle+easyui实现lazyout组件的简单案例——OpSessionview实现
- 《oracle每日一练》免安装Oracle客户端使用PL/SQL
- ORACLE——Instant Client配置SQL*LDR、EXP等命令工具
- 使用plsql连接别人的oracle(转)
- 【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之RAC 特殊问题和实战经验(五)
- Oracle-揭开RAC神秘面纱
- 【学亮IT手记】oracle远程连接工具PL/SQL Developer的安装使用教程
- oracle 判断某个表是否存在
- oracle 统计语句 与常见函数的归纳(未完待续)
- Oracle与Sql Server复制表结构及数据
- Oracle EXTRACT (datetime)
- oracle 判断某个表是否存在
- Oracle 如何查看建表时间?
- PLSQL连Oracle数据库Could not load "……binoci.dll"
- Windows环境下在Oracle VM VirtualBOX下克隆虚拟机镜像(克隆和导入)
- Oracle EBS 入门
- 怎样绕过oracle listener 监听的password设置
- oracle提权执行命令工具oracleShell v0.1
- Oracle的学习心得和知识总结(十八)|Oracle数据库性能压测工具swingbench的安装和使用及AWR ASH ADDM报告生成
- 【Mysql异构实时同步Oracle】OGG12异构同步mysql到oracle(windows mysql实时同步数据到linux oracle)详细文档