1.在安装了Oracle客户端程序后,在Oracle安装目录下有如下目录和文件是连接Oracle数据库服务器所必需的:(最好保持目录层次关系结构)
2.Oracle/BIN目录以及下面的27个DLL文件,并且保证应用程序可以找到该目录,即该目录为系统目录或者PATH目录。
3.Oracle/OCOMMON/NLS/ADMIN目录以及其下所有文件
4.Oracle/OCOMMON/NLS/MESG目录以及其下所有文件
5.Oracle/NETWORK/ADMIN/tnsnames.ora
6.Oracle/ORACORE/Mesg以及其下所有MSB文件
7.导入注册表到客户机:
REGEDIT4
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE]
"inst_loc"="C://Program Files//Oracle//Inventory"
"ORACLE_HOME"="D://oracle//ora81"
"ORACLE_HOME_NAME"="OraHome81"
"API"="D://oracle//ora81//dbs"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"NLS_LANG"="NA"
"OLEDB"="D://oracle//ora81//oledb//mesg"
"VOBHOME2.0"="D://oracle//ora81"
"OO4O"="D://oracle//ora81//oo4o//mesg"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ALL_HOMES]
"HOME_COUNTER"="1"
"DEFAULT_HOME"="OraHome81"
"LAST_HOME"="0"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ALL_HOMES/ID0]
"NAME"="OraHome81"
"PATH"="D://oracle//ora81"
"NLS_LANG"="NA"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"ORACLE_HOME_NAME"="OraHome81"
"ORACLE_HOME"="D://oracle//ora81"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_SID"="QIAODB"
"ORACLE_HOME_KEY"="Software//ORACLE//HOME0"
"SQLPATH"="D://oracle//ora81//dbs"
"ORACLE_BASE"="D://oracle"
"MSHELP_TOOLS"="D://oracle//ora81//MSHELP"
"RDBMS_CONTROL"="D://oracle//ora81//DATABASE"
"RDBMS_ARCHIVE"="D://oracle//ora81//DATABASE//ARCHIVE"
这27个DLL是(我在ORACLE 8i下用VC在调试模式得到的,其他版本可能略有出入):
oci.dll
oraclient8.dll
oracommon8.dll
oracore8.dll
orageneric8.dll
oraldapclnt8.dll
oran8.dll
ORANCDS8.DLL
orancrypt8.dll
oranhost8.dll
oranl8.dll
oranldap8.dll
ORANLS8.DLL
oranms.dll
oranmsp.dll
orannds8.dll
orannzsbb8.dll
oranoname8.dll
oranro8.dll
orantcp8.dll
orantns8.dll
ORAPLS8.DLL
ORASLAX8.dll
ORASQL8.DLL
oratrace8.dll
oravsn8.dll
orawtc8.dll
2.Oracle/BIN目录以及下面的27个DLL文件,并且保证应用程序可以找到该目录,即该目录为系统目录或者PATH目录。
3.Oracle/OCOMMON/NLS/ADMIN目录以及其下所有文件
4.Oracle/OCOMMON/NLS/MESG目录以及其下所有文件
5.Oracle/NETWORK/ADMIN/tnsnames.ora
6.Oracle/ORACORE/Mesg以及其下所有MSB文件
7.导入注册表到客户机:
REGEDIT4
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE]
"inst_loc"="C://Program Files//Oracle//Inventory"
"ORACLE_HOME"="D://oracle//ora81"
"ORACLE_HOME_NAME"="OraHome81"
"API"="D://oracle//ora81//dbs"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"NLS_LANG"="NA"
"OLEDB"="D://oracle//ora81//oledb//mesg"
"VOBHOME2.0"="D://oracle//ora81"
"OO4O"="D://oracle//ora81//oo4o//mesg"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ALL_HOMES]
"HOME_COUNTER"="1"
"DEFAULT_HOME"="OraHome81"
"LAST_HOME"="0"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ALL_HOMES/ID0]
"NAME"="OraHome81"
"PATH"="D://oracle//ora81"
"NLS_LANG"="NA"
[HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"ORACLE_HOME_NAME"="OraHome81"
"ORACLE_HOME"="D://oracle//ora81"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_SID"="QIAODB"
"ORACLE_HOME_KEY"="Software//ORACLE//HOME0"
"SQLPATH"="D://oracle//ora81//dbs"
"ORACLE_BASE"="D://oracle"
"MSHELP_TOOLS"="D://oracle//ora81//MSHELP"
"RDBMS_CONTROL"="D://oracle//ora81//DATABASE"
"RDBMS_ARCHIVE"="D://oracle//ora81//DATABASE//ARCHIVE"
这27个DLL是(我在ORACLE 8i下用VC在调试模式得到的,其他版本可能略有出入):
oci.dll
oraclient8.dll
oracommon8.dll
oracore8.dll
orageneric8.dll
oraldapclnt8.dll
oran8.dll
ORANCDS8.DLL
orancrypt8.dll
oranhost8.dll
oranl8.dll
oranldap8.dll
ORANLS8.DLL
oranms.dll
oranmsp.dll
orannds8.dll
orannzsbb8.dll
oranoname8.dll
oranro8.dll
orantcp8.dll
orantns8.dll
ORAPLS8.DLL
ORASLAX8.dll
ORASQL8.DLL
oratrace8.dll
oravsn8.dll
orawtc8.dll