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
- SQL to check Database character(Unicode/non-Unicode)
SQLPLUS > select value from nls_database_parameters