Gunther Oracle APEX und Datenbank Wiki

Diese Seite ist nicht editierbar. Sie können den Quelltext sehen, jedoch nicht verändern. Kontaktieren Sie den Administrator, wenn Sie glauben, dass hier ein Fehler vorliegt.
=====Installation eines 32 Bit ODBC Treibers unter Windows 7 / 2008 64bit =====

On a 64 Bit Windows you need the 32 Bit Drivers!

Prerequist: tnsnames.ora file with the tnsalias to your database system and a sqlnet.ora configuration file.
See examples:

<code SQL tnsnames.ora>
ORA_MYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jupiter)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = GPI)
    )
  )
</code>

<code sql sqlnet.ora>
NAMES.DIRECTORY_PATH= (TNSNAMES)
</code>

Please download the following files from [[http://www.oracle.com/technetwork/topics/winsoft-085727.html| Instant  Client Downloads for Microsoft Windows (32-bit)]]
   
  * instantclient-basic-nt-11.2.0.3.0.zip
  * instantclient-jdbc-nt-11.2.0.3.0.zip
  * instantclient-odbc-nt-11.2.0.3.0.zip


**Hint : If you neeed a connection to a Oracle Database 9 you need the 10.2.0.5 drivers! **

  - Please download the zip
  - Create directory d:\oracle\11_2_client
  - Unzip the content of the zip files in to this folder (NO SUBFOLDER instant client, all files in one directory)
  - Create directory d:\oracle\TNS_NAMES
  - Set the “Runtime Environment”  system variable TNS_ADMIN to the Path of the folder d:\oracle\TNS_NAMES (TNS_ADMIN= d:\oracle\TNS_NAMES)
  - Edit the PATH Variable, add the path d:\oracle\11_2_client to the beginning of the path variable
  - Copy the attached file tnsnames.ora and sqlnet.ora to the directory d:\oracle\TNS_NAMES
  - Open the file tnsnames.ora and check the name/IP Adresse of the DB Server and the service name of the DB, adjust if necessary
  - Open cmd shell and test with “set” if the variable TNS_ADMIN is set to the directory d:\oracle\TNS_NAMES
  - Check the path variable, if in the path “d:\oracle\11_2_client “ is defined
  - Ping the name of the dbserver (or IP Adresse) used in the file tnsnames.ora if the DB server is reachable
  - With the the CMD Schell, go to the directory d:\oracle\11_2_client and start the “odbc_install.exe” program
  - Open Explorer and go the directory “c:\windows\syswow64”
  - Open the ODBC 32 Bit Manager “odbcad32.exe”
  - Create new System DNS with the Oracle Driver “Oracle in instantclient_11_2"
  - From TNS SERVICE NAME check carefully that the  TNS_ALIAS “ORA_MYDB” is visible over the drop down box “connection “ and select this value (if not the TNS_ADMIN parameter or the file tnsname.ora has a problem!)
  - Insert Username and password and check the connection