I tried to use tnsping to test the network conditions on a remote company's computer yesterday, but I found that
On the Oracle client, tnsping cannot be executed at all. What should we talk about when we need to install an Oracle client in a remote location?
Easy, almost a nightmare. The installation program is compressed to 453 MB, which is time-consuming and laborious. I just want to test
Would it take a week to try the network? In the future, there will be more such requirements, so we decided to re-execute the client program.
Package.
1. Find a client with 10gr2 installed on a computer without an Oracle client, and select Oracle Net only.
And other required components. (Dizzy, it will take more than two hundred MB after the installation ).2. By reading documents and using Filemon and regmon, rip files in the following directories:
Zhu── Bin
├ ── Network
│ ├ ── Admin
│ Mesg
─ ── NLS
│ ─ ── Data
│ Mesg
─ ── Oracore
│ Mesg
│ ─ ── Zoneinfo
├ ── RDBMS
│ Mesg
─ ── Sqlplus
Mesg 3. Export the Registry HKLM/softwar/Oracle and save it as ora. Reg.
Ora. Reg content:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE/software/Oracle]
[HKEY_LOCAL_MACHINE/software/Oracle/key_1_lient10g_home1]
"ORACLE_HOME" = "D: // oracle"
"Oracle_home_name" = "maid"
"Oracle_group_name" = "oracle-zoolient10g_home1"
"Oracle_bundle_name" = "enterprise"
"Nls_lang" = "simplified chinese_china.zhs16gbk"
"Oracle_home_key" = "software // Oracle // key_1_lient10g_home1" 4. Add a file named nlsand sqlplusto ora.regto oracle_1.rar.
(About 11mb/s, nlsand sqlplusare packaged into oracle_2.rar (about 8.5 m), and PLSQL developer
Package it into plsqldev.rar (about 8.7 MB ).
If the secret is ingress tnsping, decompress oracle_1.rar to D:/, and then ora. Reg (if
The Directory of is not D:/Oracle, You need to first modify the Registry File "ORACLE_HOME" value to extract the Directory) Import Registration
Table.
If the supervisor runs sqlplus, you must decompress oracle_2.rar to D:/and then run
/Oracle/bin/sqlplusw.exe.
If you need to run PLSQL scripts, decompress plsqldev.rar to any directory and run
Plsqldev.exe. 5. ORACLE_HOME also supports the UNC path. If you use it within the company's Lan, you can directly upload the above files.
Put it in a public directory and change ORACLE_HOME to the corresponding UNC path. For ease of use, you can create
Import and delete registry key values in batches.
Example:
I put the file in the public path: // files/pub/Oracle
A. Change ora. Reg:
"ORACLE_HOME" = "///Files // pub // oracle"
B. Copy the Windows XP console registry tool % SystemRoot %/system32/reg.exe to the bin directory.
(This file is not available in Win2000)
C. Create a batch file sqlplus. bat
@ Echo off
If exist % SystemRoot %/bk_hklm_soft_oracle.reg copy % SystemRoot %/bk_hklm_soft_oracle.reg *. Reg. Bak> NUL
// Files/pub/Oracle/bin/REG export HKLM/software/Oracle % SystemRoot %/bk_hklm_soft_oracle.reg> NUL
// Files/pub/Oracle/bin/REG Delete HKLM/software/Oracle/F> NUL
// Files/pub/Oracle/bin/REG import // files/pub // Oracle/REG/ora. Reg> NUL
// Files/pub/Oracle/bin/sqlplusw.exe> NUL
// Files/pub/Oracle/bin/REG Delete HKLM/software/Oracle/F> NUL
// Files/pub/Oracle/bin/REG import % SystemRoot %/bk_hklm_soft_oracle.reg> NUL
Echo on
6. Software Version: 10.2.0.1.0
Client operating system WINXP + SP2, Win2000 + SP4.
7. If you need these runtime environments for your own applications, You can include these files in the installation package for release. Reference: http://www.cnblogs.com/xulei/archive/2006/11/16/562092.html |
