Unable to activate config due to OCIServerAttach failed with ORA-12560 on Windows 2003 64 bit
Event_log:
with ORA-12560. (activating sid {sid name}) [module osp]
Error 2011-07-01 11:58:19.015000 2976 3472 Compile of "{config name}" for sid o.{sid name} failed: Oracle Error: connect failed for database o.{sid name} -
Ora_setup run not using tns_alias, missing registry entry key ORACLE_HOME pointing to oracle client\bin under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\{port}, and incorrect environment variables exported
1. Export proper enviroment variables:
- ORACLE_HOME: pointing to the actual ORACLE_HOME
- PATH : must point to {oracle client\bin} and ORACLE_HOME\bin
2. Ora_setup must be ran using the tns_alias
Example: splex / splex@{tns_alias}
3. Backup the registry
3.1 Under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\2100
- Add new key and string value: ORACLE_HOME= {PATH to Oracle client\bin}
Example:
1. Go to Start menu | run and type regedit
2. Click File - export and give it a name
3. Go to [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\2100, and create a new string value called "ORACLE_HOME" with value: E:\ora_client\product\11.2.0\client_1
The ORACLE_HOME must either be set as environment variable or as a as key and string value in the registry under ORACLE, NOT both.
