суббота, 2 февраля 2013 г.

[Windows] instantclient + SQL Navigator

1) install only 32 bit instantclient. (instantclient_folder). download all packages. basic, sqlplus, etc.
2) install SQL Navigator not in .\Program Files (x86)\. Only in .\Program Files\. or d:\***\
3) set %ORACLE_HOME%=%TNS_ADMIN%=%LD_LIBRARY_PATH%=instantclient_folder. add to %PATH%
4) set %NLS_LANG% = *** (for new db for russia RUSSIAN_CIS.RU8PC866)
5) create tnsnames.ora in %ORACLE_HOME%

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.44)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
6) if you want use tnsnames, you need to set ORACLE_HOME as path to oracle client in SQL Navigator.
??

Комментариев нет:

Отправить комментарий