glori.xyz

Tag: Oracle

  • TDM Oracle Database Tips

    Environment:

    • TDM 2018+
    • Oracle 19c
    • Windows10/11

    Tips:

    • Do NOT change ORACLE_HOME\network\admin\sqlnet.ora
      • Some document was said to change AUTH… to (none). Do NOT change and keep it as (NTS) in Windows10/11, or it might cause some problem during DB creation and startup.
    • Avoid to install both Oracle DB Server and Client in same machine(Standalone)
    • Old TDM version(2018 or early) may still need 32bit Oracle Client. test.udl file can only verify 64bit, NOT 32bit OLE DB component.
    • Newer TDM version does not need TNSName anymore

  • TDM Installation – Required Oracle(19c) components

    Notes:

    1. Actually OLE DB was the key component.
    2. Early TDM version/TDM Installer may need 32bit Oracle Client.
    3. Both Oracle DB Server and Client was needed for TDM standard alone installation. If there’s problem to recognize the component, please consider on which ORACLE HOME was used (especially command line operation).