Oracle环境变量设置

::oracle system environment,no space block
@echo off
::关于如果出现空格字符需要用双引号
echo "设置TNS_ADMIN"
:: modify these value of TNS_ADMIN_env,ORACLE_HOME_env & LD_LIBRARY_PATH_env
set TNS_ADMIN_env="c:appAdministratorproduct11.2.0dbhome_1NETWORKADMIN"
:: defalut appended to path when installed
set ORACLE_HOME_env="c:appAdministratorproduct11.2.0dbhome_1"
:: default set
set NLS_LANG_env=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
set reg_path=HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession ManagerEnvironment
@reg add "%reg_path%" /v ORACLE_HOME /t reg_expand_sz /d "%ORACLE_HOME_env%" /f
@reg add "%reg_path%" /v TNS_ADMIN /t reg_expand_sz /d "%TNS_ADMIN_env%" /f
@reg add "%reg_path%" /v NLS_LANG /t reg_expand_sz /d "%NLS_LANG_env%" /f
:: arcgis sde
set LD_LIBRARY_PATH_env="C:Program Files (x86)ArcGISinstantclient_10_2"
@reg add "%reg_path%" /v path /t reg_expand_sz /d ".;%path%;%LD_LIBRARY_PATH_env%" /f
echo "查看变量是否设置成功"
echo %ORACLE_HOME%
echo %TNS_ADMIN%
echo %NLS_LANG%
echo %PATH%
pause

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!