installing oracle instant client - oracle instant client installieren

1) download insant client basic, unzip, copy files to c:\orahome (or any other name)
2) environment variables: add c:\orahome to path (system, environment variabls) add oracle_home=c:\orahome; tns_admin=c:\orahome\network
3) make dir network in orahome and create file sqlnet.ora example:

# sqlnet.ora Network Configuration File: C:\oracle\11gR2\client\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT)

4) create file tnsnames.ora

5) for ldap access create file ldap.ora
DEFAULT_ADMIN_CONTEXT = "dc=subdomain,dc=mydomain,dc=at"

DIRECTORY_SERVERS = (oraoid2.subdomain:389:636,oraoid1.subdomain:389:636,oraoid1.xxx:389:636)

DIRECTORY_SERVER_TYPE = OID


6) test by sqlplus: downloas sqlplus instant client, copy files to c:\orahome and execute at cmd:
sqlplus  user@sid
(sid should be defined in ldap or tnsnames)
select table_name from user_tables;