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