Supplementary Pre-Install & Configuration Resources By Database

Oracle

• Do OpenLink drivers connect to Oracle?
  
• Which versions of Oracle are supported by OpenLink drivers?
  
• How can I detect my Oracle DBMS version?
  
• What is the Oracle native client?
  
• When do I need the Oracle native client?
  
• Where can I get the Oracle native client (a.k.a. "Net8", "Net9", "Net10")?
  
• How do I configure the Oracle native client ?
  
• How do I create a Single-Tier DSN to connect to Oracle?
  
• How do I create a standard (2-Tier) Multi-Tier DSN to connect to Oracle?
  
• How do I create an application server (3-Tier) Multi-Tier DSN to connect to Oracle?
  
• How do I create a JDBC Type 1 URL to connect to Oracle?
  
• How do I create a JDBC Type 3 URL to connect to Oracle?
  
• What value does the ORACLE_HOME environment variable pass?
  
• What value does the ORACLE_SID environment variable pass?
  
• How do I monitor open database sessions associated with Oracle ODBC connections?
  
• Where is the Oracle error log?
  
• How do I dump the Oracle error log?
  
• How do I find my Oracle SID?
  
• How do I find my Oracle TCP port?
  
• How do I find my SQL*Net or Net Service Name?