Endian Mismatch Between HVA and Source Oracle Database
Issue
An endian mismatch prevents HVA from properly parsing logs, resulting in failed incremental syncs.
Environment
- Connector: High-Volume Agent Oracle
- Incremental sync method: Archive Log Only
Resolution
To resolve this issue set the HVR_PLATFORM_ORA_ID and HVR_PLATFORM_ID parameters to force HVA to use the same endian order as the source Oracle database when parsing the archive log files.
Set the applicable HVR_PLATFORM_ORA_ID value:
| HVR_PLATFORM_ORA_ID | DESCRIPTION |
|---|---|
ORA_BE_SOLARIS_32 | Solaris[tm] OE (32-bit) |
ORA_BE_SOLARIS_64 | Solaris[tm] OE (64-bit) |
ORA_BE_HPUX_64 | HP-UX (64-bit) |
ORA_BE_HPUX_IA64 | HP-UX IA (64-bit) |
ORA_LE_HPUX_TRU64 | HP Tru64 UNIX |
ORA_BE_AIX_64 | AIX-Based Systems (64-bit) |
ORA_LE_WIN_IA32 | Microsoft Windows IA (32-bit) |
ORA_LE_WIN_IA64 | Microsoft Windows IA (64-bit) |
ORA_BE_IBM_Z_LINUX | IBM zSeries Based Linux |
ORA_LE_LINUX_IA32 | Linux IA (32-bit) |
ORA_LE_LINUX_IA64 | Linux IA (64-bit) |
ORA_LE_WIN_X86_64 | Microsoft Windows x86 64-bit |
ORA_LE_LINUX_X86_64 | Linux x86 64-bit |
ORA_LE_HP_OPEN_VMS | HP Open VMS |
ORA_BE_MACOS | Apple Mac OS |
ORA_LE_SOLARIS_X86 | Solaris Operating System (x86) |
ORA_BE_IBM_POWER_LINUX | IBM Power Based Linux |
ORA_HP_IA_OPEN_VMS | HP IA Open VMS |
ORA_LE_SOLARIS_X86_64 | Solaris Operating System (x86-64) |
Select the applicable HVR_PLATFORM_ID value:
| HVR_PLATFORM_ID | DESCRIPTION |
|---|---|
LE_LINUX | Linux LE |
BE_SOLARIS | Solaris Sparc BE |
LE_SOLARIS | Solaris x86_64 LE |
BE_HPUX | HP-UX IA64 BE |
BE_AIX | AIX BE |
LE_WIN | Windows LE |
Example
For example, if the source Oracle database runs on IA64 but the HVA runs on Linux, set the following:
HVR_PLATFORM_ORA_ID=ORA_BE_HPUX_IA64 HVR_PLATFORM_ID=BE_HPUX
You can add the parameters when running the hvragentlistener command.
- Linux:
hvragentlistener -d 4343 "-EHVR_PLATFORM_ORA_ID=ORA_BE_HPUX_IA64" "-EHVR_PLATFORM_ID=BE_HPUX" - Windows:
hvragentlistener -acs 4343 "-EHVR_PLATFORM_ORA_ID=ORA_BE_HPUX_IA64" "-EHVR_PLATFORM_ID=BE_HPUX"
Cause
This issue occurs when HVA runs on a little-endian platform, such as Linux or Windows, but reads archive log files from an Oracle database on a big-endian platform, such as HP-UX.