Connect to VMConnect Failed with Your credentials did not work
Connect to VMConnect Failed with Your credentials did not work Windows Server 2025 Core Hyper-V Overview of VMConnect Default port: 2179 Using RDP potocal Symptoms Issue: VMConnect fails with "Your credentials did not work Windows Defender Credential Guard does not allow using Windows logon credentials. Please enter your credentials". Solution Disable the GPO Computer Configuration\Administrative Templates\System\Device Guard\Turn On Virtualizaton Based Security on VMM server. gpupdate...
Database Link of Oracle Database
Database Link of Oracle Database Statement: CREATE [PUBLIC] DATABASE LINK linkCONNECT TO username IDENTIFIED BY passwordUSING 'connectstring'; Query database link. select * from dba_db_links; Grant privileges. grant create public database link, create database link to jove; Sample: create public database link to_source connect to jove identified by jove using '172.17.0.2:1521/orcl';create database link to_source connect to jove identified by jove using 'tns_orcl';create database link to_sour...
OGG-01496 Failed to open target trail file xxx
OGG-01496 Failed to open target trail file xxx OGG 11.2 Symptoms The datapump process abending with error OGG-01496. GGSCI (bbb49d666616) > info pump00EXTRACT PUMP00 Last Started 2026-04-30 11:16 Status ABENDEDCheckpoint Lag 00:00:00 (updated 57:35:36 ago)Log Read Checkpoint File ./dirdat/capt00/ct000003 2026-04-28 01:42:36.000000 RBA 78723GGSCI (bbb49d666616) > view report pump002026-04-30 11:16:43 ERROR OGG-01496 Failed to open target trail...
Enabling DDL Replication on Oracle GoldenGate
Enabling DDL Replication on Oracle GoldenGate Configuring on Source Side (Unidirectional) Stop all OGG processes. GGSCI> stop capt00GGSCI> stop pump00GGSCI> stop rept00 Specify the ggschema for DDL replication. GGSCI> edit params ./GLOBALSGGSCHEMA goldengate Grant ddl privileges to OGG user on both side. SQL> grant execute on utl_file to goldengate;SQL> grant restricted session to goldengate;SQL> grant create table, create sequence to goldengate; Run the scripts ...
Overview of Oracle GoldenGate (OGG)
Overview of Oracle GoldenGate (OGG) Docs ・ https://docs.oracle.com/en/database/goldengate/core/index.html Initialize Way ・ RMAN ・ DataPump ・ OGG Sequence ・ 双向复制时，不能使用序列。 ・ 单向复制时，不能使用序列的 cache，否则会造成源和目标不同步（缺省使用 cache=20）。 Trigger ・ 目标库需要删除触发器，或设置禁用。由于触发器可能会造成目标库数据重复插入。 Constraint ・ 目标库需要删除约束，或设置禁用。 Supplemental Log ・ 事先确认附加日志是否有效，没有附加日志会不会丢失数据。 DDL replication ・ 用户默认的表空间不要指定 system 表空间。 ・ 关闭数据库回收站功能，并清空回收站。 -- alter system set recyclebin=off scope=spfile; -- 10g r1/r2purge dba_recycle...
Deploying OGG 11.1 Replication from Oracle 10g FS to Oracle 11g RAC
Deploying OGG 11.1 Replication from Oracle 10g FS to Oracle 11g RAC Oracle GoldenGate V11.1.1.1.0 for Oracle 10g 64bit on Windows 2003, 2008 Oracle GoldenGate V11.1.1.1.0 for Oracle 11g on Linux x86-64 1 Environment Preparation Source: IP: 192.168.1.50 Hostname: oracle10g Database: 10.2.0.4 - 64bit SID: orcl OS: Windows Server 2008 R2 Target: IP: 192.168.1.51 Hostname: rac-cluster Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 6.10 Requirements: Replicat schema: zemr Eable...
Deploying OGG 11.2 Replication from Oracle 11g FS to Oracle 11g FS
Deploying OGG 11.2 Replication from Oracle 11g FS to Oracle 11g FS OGG 11.2.1.0.3 1 Environment Preparation Source: IP: 172.17.0.2 Hostname: oracle11g-1 Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 6.10 Target: IP: 172.17.0.3 Hostname: oracle11g-2 Database: 11.2.0.4.0 - 64bit SID: orcl OS: Oracle Linux Server 6.10 Requirements: DB size < 50GB, blob column Enable DDL replicate, encrypt password Using OGG to initialize target database Unidirectional replication 2 Insta...
Oracle Database Test Data
Oracle Database Test Data SQL> create tablespace tbs_jove datafile '/u01/app/oracle/oradata/orcl/tbs_jove_1.dbf' size 1m autoextend on next 10m maxsize unlimited;SQL> create user jove identified by jove default tablespace tbs_jove quota unlimited on tbs_jove;SQL> grant connect,resource to jove;SQL> grant create job to jove; -- Create tableconn jove/joveDROP TABLE IF EXISTS tbl01;CREATE TABLE tbl01 ( name VARCHAR2(10), amount NUMBER(20,2), time TIMESTAMP);-- Create Proced...
Debugging a Bash Script
Debugging a Bash Script Enabling verbose Mode ~]$ bash -v demo.sh Syntax Checking Using noexec Mode ~]$ bash -n demo.sh Debugging Using xtrace Mode ~]$ bash -x demo.sh Identifying Unset Variables ~]$ bash -u demo.sh Debugging Specific Parts of the Script #!/usr/bin/env bashset -xecho "Debugging"set +xecho "Script Ended" Bash Special Variables #!/usr/bin/env bash# Debug output script filename, line number, function namePS4='+ ${BASH_SOURCE}:${LINENO}:${FUNCNAME[0]:+${FUNCNAME[0]}()} ' Redirec...
Silent installation of Oracle Database 11g
Silent installation of Oracle Database 11g # Install database software./runInstaller -silent -force -responseFile /home/oracle/db_install.rsp# Install grid software./runInstaller -responseFile /home/grid/grid_install.rsp -silent -ignorePrereq -ignoreSysPrereqs -showProgress# Create listenernetca -silent -responsefile /home/oracle/netca.rsp# Create instancedbca -silent -responseFile /home/oracle/dbca.rsp db_install.rsp oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=oracleUNIX_GROUP_N...
