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%
??
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 =6) if you want use tnsnames, you need to set ORACLE_HOME as path to oracle client in SQL Navigator.
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.44)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
??
Комментариев нет:
Отправить комментарий