The vpxd-svcs service start failed after reset all certificates
The vpxd-svcs service start failed after reset all certificates VCSA 6.7 Symptoms ~]# service-control --start --allOperation not cancellable. Please wait for it to finish...Performing start operation on service lwsmd...Successfully started service lwsmdPerforming start operation on service vmafdd...Successfully started service vmafddPerforming start operation on service vmdird...Successfully started service vmdirdPerforming start operation on service vmcad...Successfully started service v...
Multitenant Environment (CDB & PDB) on Oracle 12c
Multitenant Environment (CDB & PDB) on Oracle 12c Related commands 查看是否为 CDB 数据库 SQL> select name, cdb, open_mode, con_id from v$database;NAME CDB OPEN_MODE CON_ID--------- --- -------------------- ----------ORCL YES READ WRITE 0 1> 查看当前容器（Container） SQL> show con_nameCON_NAME------------------------------CDB$ROOT 2> 查看 CDB 容器中的 PDBs 信息（在 CDB 模式下） SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED-----...
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...
