linux平台配置oracle odbc dsn的方法.docx
LINUX平台配置ORACLEODBCDSN的方法1DSN配置方法ORACLE11编辑配置文件一.OSRHEL5X86(ORACLEDATABASE11GSOFTWARE,VERSION111070)二.UNIXODBCUNIXODBC230三.ORACLEORACLEINSTANTCLIENT112BASIC1120101I386RPMORACLEINSTANTCLIENT112ODBC1120101I386RPM安装路径/USR/LIB/ORACLE/112/CLIENT/LIB/四.DSN配置1./ETC/ODBCINSTINIORACLE_DRIVERDESCRIPTIONODBCFORORACLEDRIVER/USR/LIB/LIBSQORASO111SETUP/USR/LIB/LIBORAODBCSSOFILEUSAGE12./ETC/ODBCINIDSN_ORADRIVERORACLE_DRIVERSERVER19216811209PORT1521SERVERNAMEORCLUSERIDUSR1PASSWORD123456783.创建TNS文件MKDIR–P/USR/LIB/ORACLE/112/NETWORK/ADMINCD/USR/LIB/ORACLE/112/NETWORK/ADMINTOUCHTNSNAMESORAORCLDESCRIPTIONADDRESSPROTOCOLTCPHOST19216811209PORT1521CONNECT_DATASERVERDEDICATEDSERVICE_NAMEORCL4.环境变量EXPORTTNS_ADMIN/USR/LIB/ORACLE/112/NETWORK/ADMIN5.测试连接ISQLDSN_ORA–VROOTVMDBSRV02SHAREISQLDSN_ORAV|CONNECTED||||SQLSTATEMENT||HELPTABLENAME||QUIT|||SQL图形化配置参考/ETC/ODBCINSTINIODBCINI