Oracle9i客户端免安装步骤

Oracle9i客户端免安装步骤

Oracle9i客户端免安装步骤： 一、将Oracle目录/oracle/ora92/bin所有的*.dll文件、/oracle/ora92/network下所有文件、/oracle/ora92/ocommon下所有文件、/oracle/ora92/oracore所有文件复制到C：盘根目录下； 二、修改ORACLE/ora92/NETWORK/ADMIN/的listener和tnsnames 文件 1、LISTENER文件配置 LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 你的ORACLE服务器IP)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:/ORACLE) (PROGRAM = extproc) ) ) 2、TNSNAMES文件配置 dbserver = //连接字符串 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 你的ORACLE服务器IP)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORACLE9)//oracle9为oracle服务器的实例名 ) ) 三、执行注册表文件； 如下是注册表文件的内容 Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE/SOFTWARE/oracle] "NLS_LANG"="AMERICAN_AMERICA.zhs16gbk" "ORACLE_HOME"="C://ORACLE" "ORACLE_HOME_NAME"="DEFAULT_HOME" "ORACLE_GROUP_NAME"="Oracle - DEFAULT_HOME" [HKEY_LOCAL_MACHINE/SOFTWARE/oracle/ALL_HOMES] "HOME_COUNTER"="1" "DEFAULT_HOME"="DEFAULT_HOME" "LAST_HOME"="0" [HKEY_LOCAL_MACHINE/SOFTWARE/oracle/ALL_HOMES/ID0] "NAME"="DEFAULT_HOME" "PATH"="C://ORACLE" "NLS_LANG"="NA" [HKEY_LOCAL_MACHINE/SOFTWARE/oracle/HOME0] "ID"="0" "ORACLE_GROUP_NAME"="Oracle - DEFAULT_HOME" "ORACLE_HOME_NAME"="DEFAULT_HOME" "ORACLE_HOME"="C://ORACLE" "NLS_LANG"="AMERICAN_AMERICA.zhs16gbk" "ORACLE_BUNDLE_NAME"="Enterprise" "ORACLE_HOME_KEY"="Software//ORACLE//HOME0" 四、将C:/oracle/ora92/bin路径加入AUTOEXEC.BAT批处理里面或环境变量的系统变量PATH里。 PATH=C:/oracle/ora92/bin