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