Oracle 11g RAC
文章平均质量分 79
冰释镜湖
DBA at Huawei since 2015.6, Focus on Oracle/MySQL/Redis/MongoDB/PaaS/Kubernetes/Docker/RDS;
Senior Oracle DBA at Oracle until 2015.6
展开
-
Oracle GoldenGate 安全性配置系列:利用 CMDSEC 文件控制 GoldenGate 命令的用户访问权限
最近生产环境的历史查询库有多个厂商在使用,goldengate同步经常莫名奇妙的被其他厂商关掉重启,一下子前台应用便感受到了。我们这些运维人员倍感压力啊。这个周末好好瞅了瞅Oracle GoldenGate 官方文档,研究了一下如何利用GoldenGate 安全性配置来控制用户访问 GoldenGate ggsci 命令的权限,今天先发这个最紧迫的 CMDSEC,将在近期系列性地探索一下Golde原创 2013-03-03 22:49:31 · 2815 阅读 · 1 评论 -
DNS and DHCP Setup Example for Grid Infrastructure GNS (Doc ID 946452.1)
Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.PurposeThe Grid Naming Service (GNS) is a new feature in the 1转载 2013-11-30 22:48:04 · 3497 阅读 · 0 评论 -
Linux: How to Configure the DNS Server for 11gR2 SCAN (Doc ID 1107295.1)
Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Generic LinuxThe commands listed in this Note tested at Red Hat Enterprise Server 5 Update 2. For th转载 2013-11-30 22:50:54 · 2404 阅读 · 0 评论 -
Tracing Techniques for Listeners in 11.2 RAC Environments (Doc ID 1325284.1)
In this Document Purpose Troubleshooting StepsApplies to: Oracle Database Products > Oracle Database > Net ServicesInformation in this document applies to a转载 2013-12-12 16:54:35 · 1338 阅读 · 0 评论 -
How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure (Doc ID 1063571
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.GOALDuring the Grid Infrastructure installation, the (default转载 2013-12-13 22:20:39 · 2759 阅读 · 0 评论 -
How to Setup Active DataGuard on Exadata (Doc ID 1580796.1)
APPLIES TO:Oracle Exadata Storage Server Software - Version 11.2.2.3.5 to 11.2.3.2.1 [Release 11.2]Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]Information i转载 2013-12-13 22:18:10 · 2491 阅读 · 0 评论 -
How to create a Oracle 11g RAC Database manually without DBCA ?
From now on, Write everything in English.To create a Oracle 11g RAC database manually, there should be a ready RAC env, and you should following the steps below.1.Create a Single instance Databa原创 2013-12-20 12:50:43 · 3429 阅读 · 0 评论 -
How to copy a datafile from ASM to a file system not using RMAN (Doc ID 428893.1)
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.***Checked for relevance on 03-Apr-2013*** GoalThis>Note 390转载 2013-12-25 17:09:32 · 1215 阅读 · 0 评论 -
How to move a datafile from a file system to ASM (Doc ID 390274.1)
Applies to: Oracle Database - Enterprise Edition - Version 10.1.0.5 to 10.2.0.3 [Release 10.1 to 10.2]Information in this document applies to any platform.***Checked for relevance on 23-June-201转载 2013-12-25 17:13:32 · 1436 阅读 · 0 评论 -
Maste Note for OCR / Vote disk Maintenance Operations (ADD/REMOVE/REPLACE/MOVE)
Doc ID 428681.1Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1.0 [Release 10.2 to 11.2]Information in this document applies to any platform.GoalThe goal of this note i原创 2014-07-14 17:05:27 · 5970 阅读 · 0 评论 -
Start Of ONS Resource Fails With CRS-2672, CRS-5016, CRS-2674 and CRS-4000
(Doc ID 1633123.1)Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.SymptomsThe ONS resource shows state OFFLINE for on转载 2014-08-22 12:18:38 · 5228 阅读 · 0 评论 -
Using Class of Secure Transport (COST) to Restrict Instance Registration in Oracle RAC (Doc ID 13408
Applies to: Oracle Net Services - Version 10.2.0.3 to 11.2.0.4 [Release 10.2 to 11.2]Information in this document applies to any platform.GoalTo demonstrate how the COST parameter "SECURE_RE转载 2013-11-04 12:24:25 · 5294 阅读 · 0 评论 -
Oracle 11g R2 RAC:使用 DBMS_SERVICE 包管理 service 资源
Summary of DBMS_SERVICE SubprogramsTable 130-5 DBMS_SERVICE Package SubprogramsSubprogramDescriptionCREATE_SERVICE ProcedureCreates serviceDELETE_SERVICE Pr原创 2013-08-16 18:30:05 · 4397 阅读 · 0 评论 -
Linux 上 RAC 环境检查脚本
echo "#*******************************os check****************************************"echo `hostname`echo "----------------------------------------------------------------------------------"原创 2013-02-05 00:19:09 · 1590 阅读 · 0 评论 -
Oracle 11.2.0.3 RAC环境 ORA-29280 错误解决办法
客户的11.2.0.3 RAC环境自动运行的JOB报错ORA-29280。详细错误信息为:Sat Sep 15 05:59:59 2012 VKRM started with pid=54, OS id=32622 Sat Sep 15 06:00:09 2012 Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl1/原创 2013-02-05 00:30:08 · 2353 阅读 · 0 评论 -
在虚拟机上安装 Oracle 11g RAC 过程中遇 SCAN Name 配置错误的处理办法
Cause?-?The plug-in failed in its perform method Action?-?Refer to the logs or contact Oracle Support Services. Log File Location/u01/app/oraInventory/logs/installActions2013-01-04_08-37-53PM.原创 2013-02-05 00:27:34 · 2479 阅读 · 0 评论 -
从 ASM 中删除归档日志遇 ORA-15028 错误
今天一8点跑去中金校验数据,发现近期库(AIX6.1下4节点11gR2 RAC)的归档满了,数据库hang住,跑去问提前到的中间件的哥们,结果来了一句没发现什么异常……心凉了一截,这他妈我要是晚来一会,准出事啊,纳税人还不得急死……二话不说赶紧去先清清再说,切换到grid用户下,通过 asmcmd 用 os 命令连删除了两个文件夹结果删到第二个文件夹时,突然报错:ORA-15032:原创 2013-03-15 22:56:43 · 8948 阅读 · 0 评论 -
Oracle 11g R2 RAC:CRS 管理员用户的管理
To query the list of users that are CRS Administrators:[grid@rac1 ~]$ crsctl query crs administratorCRS Administrator List: *To enable role-separated management and grant privileges to non-p原创 2013-03-31 22:57:06 · 1960 阅读 · 0 评论 -
CVU NTP Prerequisite Check Fails With PRVF-5410 and PRVF-5416 [ID 1384298.1]
CVU NTP Prerequisite Check Fails With PRVF-5410 and PRVF-5416 [ID 1384298.1]Applies to:Oracle Database - Standard Edition - Version 11.2.0.1 and laterInformation in this document applies to原创 2013-06-22 10:36:45 · 10195 阅读 · 0 评论 -
Bug 11775332 - cluvfy fails with PRVF-5636 with DNS response timeout error [ID 11775332.8]
Bug 11775332 cluvfy fails with PRVF-5636 withDNS response timeout error but error text is not clear Thisnote gives a brief overview of bug 11775332. The content was last updated on:17-JUN-2013原创 2013-06-23 10:18:13 · 4621 阅读 · 0 评论 -
About Oracle 11gR2 Grid Infrastructure Single Client Access Name (SCAN)
Oracle 11gR2Grid Infrastructure (CRS) 中引入了 Single Client Access Name (SCAN) 来简化客户端对数据库服务的访问,本文将详细说明 SCAN 的含义及其工作原理。 SCAN 概念Single client access name (SCAN) 是提供给所有客户端用于连接集群的虚拟主机名称(与10g 和 11g R1 中的 vip 主机名称相对应)。 SCAN 是 DNS 或 Grid Naming Service (GNS) 中注原创 2013-07-02 16:36:29 · 3983 阅读 · 0 评论 -
Oracle 11g R2 RAC:配置 DNS 解析 SCAN VIP
Oracle 11gR2Grid Infrastructure (CRS) 中引入了 Single Client Access Name (SCAN) 来简化客户端对数据库服务的访问。本文将详细介绍如何配置 DNS 来解析 SCAN VIP原创 2013-07-03 17:38:04 · 4124 阅读 · 0 评论 -
Oracle 11g R2 RAC:使用 srvctl 工具管理 service 资源
1、使用 srvctl 工具创建 service 资源srvctl add service -d db_unique_name -s service_name {-r "preferred_list" [-a "available_list"] [-P {BASIC | NONE | PRECONNECT}] | -g server_pool [-c {UNIFORM | SI原创 2013-08-14 22:43:44 · 6341 阅读 · 0 评论 -
How to move RAC Database ORACLE_HOME from one location to another one (Doc ID 1438719.1)
How to move RAC Database ORACLE_HOME from one location to another one (Doc ID 1438719.1)To BottomIn this Document Goal SolutionApplies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 1转载 2014-10-14 10:30:15 · 1797 阅读 · 0 评论