Installing Oracle Database 23.26.1.0.0 RAC on RHEL 9.6
Installing Oracle Database 23.26.1.0.0 RAC on RHEL 9.6 Operating System: RHEL 9.6 Database Software: LINUX.X64_2326100_grid_home.zip, LINUX.X64_2326100_db_home.zip Oracle Standalone Cluster Requirements Minimum Available Space Requirements for Oracle Standalone Cluster With GIMR Configuration Redundancy Level DATA Disk Group Oracle Fleet Patching and Provisioning Total Storage External 1 GB 1 GB 2 GB Normal 2 GB 2 GB 4 GB High/Flex/Extended 3 GB 3 GB 6 GB Configuring Operat...
Configuring Password Security on GoldenGate
Configuring Password Security on GoldenGate Generating encryption password key. GGSCI> encrypt password goldengate, encryptkey defaultUsing default key...Encrypted password: AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVCAlgorithm used: BLOWFISH Modify the userid parameter in capture and replicat processes. GGSCI> edit params capt00userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC, encryptkey defaultGGSCI> edit params rept00userid goldengate, password A...
How to disable,enable the constraints,triggers,jobs for oracle database migration
How to disable,enable the constraints,triggers,jobs for oracle database migration Disable set pagesize 2000define schema_owner=JOVE','USER01','USER02','USER03-- foregin key constraints/cascading deletesselect 'ALTER TABLE '||owner||'.'||table_name||' DISABLE CONSTRAINT '||constraint_name||';'from dba_constraintswhere constraint_type = 'R' and delete_rule = 'CASCADE' and owner in ('&schema_owner');-- confirm foregin key disableselect owner,constraint_name,constraint_type,statusfrom dba_c...
Deploying OGG 12.2 Replication from Oracle 11g RAC to Oracle 11g RAC
Deploying OGG 12.2 Replication from Oracle 11g RAC to Oracle 11g RAC OGG 12.2.0.1.1 1 Environment Preparation Source: IP: 192.168.3.156 Hostname: asm-scan Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 7.4 Target: IP: 192.168.3.165 Hostname: rac-scan Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 7.4 Requirements: DB size > 1TB, blob column Disable DDL replicate, encrypt password Using expdp/impdp to initialize target database Unidirectional replication ...
Overview of YashanDB
Overview of YashanDB Docs ・ https://doc.yashandb.com/
How to Restore ocrconfig on Oracle RAC
How to Restore ocrconfig on Oracle RAC Stop clusterware force. ~]# $GRID_HOME/bin/crsctl stop crs -f Show ocrconfig backup. ~]# $GRID_HOME/bin/ocrconfig -showbackuporacle11gasm01 2026/05/26 15:25:13 /u01/app/11.2.0/grid/cdata/rac-cluster/backup00.ocroracle11gasm01 2026/05/26 11:25:12 /u01/app/11.2.0/grid/cdata/rac-cluster/backup01.ocroracle11gasm01 2026/05/26 07:25:10 /u01/app/11.2.0/grid/cdata/rac-cluster/backup02.ocroracle11gasm01 2026/05/25 03:24:55 /u0...
CRS-0804,PROC-44
CRS-0804,PROC-44 crsctl start crs failed. Symptoms CRS-0804:Cluster Ready Service aborted due to Oracle Cluster Registry error ~]# tail -f /u01/app/11.2.0/grid/log/oracle11gasm01/alertoracle11gasm01.log2026-05-31 14:58:31.804:[/u01/app/11.2.0/grid/bin/oraagent.bin(3163)]CRS-5011:Check of resource "+ASM" failed: details at "(:CLSN00006:)" in "/u01/app/11.2.0/grid/log/oracle11gasm01/agent/ohasd/oraagent_grid/oraagent_grid.log"2026-05-31 14:58:32.785:[ohasd(3049)]CRS-2767:Resource state recove...
ORA-01078 failure in processing system parameters
ORA-01078 failure in processing system parameters Oracle Database 11.2.0.4 RAC Symptoms Case Ⅰ: ~]$ srvctl start instance -d orcl -i orcl1PRCR-1013 : Failed to start resource ora.orcl.dbPRCR-1064 : Failed to start resource ora.orcl.db on node oracle11gasm01CRS-5017: The resource action "ora.orcl.db start" encountered the following error:ORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DATA/spfileorcl.ora'ORA-17503: ksfdopn:2 Failed to open file +DAT...
YashanDB POC Daily Report
YashanDB POC Daily Report 日报 / 周报模板： 日报内容模板（按实际情况填写各项内容） ： 标题： POC 日报 - XXX 客户 XXX 系统 -- 总体完成 XX%--[无风险 | 中风险 | 高风险]-- 日期 销售： ， SA： ， POC： 当前阶段： 总体计划进行到哪步，总体完成百分比 风险： [无风险 | 中风险 | 高风险] 风险描述： 风险问题简述，影响范围，是否导致 POC 失败（必选）。 低风险简单描述，高风险要详细描述（报错关键，用户是否感知，若感知用户态度是否必须解决，性能问题目标和当前状态，友商指标。如研发有不同意见，列出研发意见，记录已尝试方案，剩余可选方案，责任人是谁，以及计划解决时间。）。 今日进展： 完成哪些工作，描述进展尽量用明确的数字，比如：总体任务 XX 个，本周完成 XX 个，性能优化提升多少，发现 XX 个问题 ，处理 XX 个，剩余是什么问题。 遇到哪些问题，问题处理方式，是否阻塞问题。 后续计划： 总体计划： XX 月 XX 日启动，XX 周内完成 XXXX 年 ...
YashanDB ystop.sh
YashanDB ystop.sh 1 概述 ystop.sh 是 YashanDB 的交互式性能监控工具，用于实时监控数据库活动。通过按键切换不同的监控视图。 2 基本用法 # 默认连接本地数据库./ystop.sh# 指定数据库连接./ystop.sh sys/yasdb_123@192.168.1.2:1688 3 快捷键说明 快捷键 功能 说明 d Database overview 数据库监控大盘，显示 TPS、响应时间、数据库大小、Buffer 命中率、VM 使用、等待事件等 D Database detail 数据库详细运行指标，显示系统运行统计信息 b Buffer pool 缓冲区池使用状况 s Top SQL 显示 TOP SQL，可按多种指标排序 z Select orderby column 在 Top SQL 视图下选择排序字段 l Lock & Spinlock 显示锁和自旋锁统计 L Lockwait 显示锁等待详细信息 S Session 显示会话状况和当前运...
