The client can connect to the database without installing Oracle.

Source: Internet
Author: User

This document uses Oracle8i as an example:

First install an oracle client,

Retain the bin, network, and ocommon directories in the oracle directory, and delete all the other directories,

Export HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE in the registry.

When installing the new machine, copy the oracle directory and registry file, register the registry, add the oracle \ bin path to the path, and restart.

Note:
1. The directory on the new machine must be consistent with the directory on the oracle client. If the directory is inconsistent, You need to modify the registry;

2. Add the oracle \ bin path to the path;

3. Restart the machine. After completing the preceding two steps, you must restart the oracle client.

I used the following method to connect oracle8 without installing a client. The client operating system is 98:

1. create a directory (for example, c: \ orawin95 ), copy the relevant files in the \ bin directory of oracle and the Nlsrtl33 \ Data directory to this directory (the files in these two directories can be put together or placed according to the original location. For the file list, see );

2. Add three oracle registration items to the Registry (see the registration items below );

3. Add the path of oracle and Application in autoexec. bat;

4. Copy the application Runtime Library to the path that can be searched by the system, preferably in the application directory;

5. Copy TNSNAMES. ORA and SQLNET. ORA to the application directory and configure them;

6. restart the computer and make sure that the system's PATH environment variables contain the preceding two directories.

7. Now, the configuration is complete.

Appendix:
1. oracle file list

\ Bin \ *. dll; most of them are not required. In view of the large number of files, we will not list them here. We can exclude them one by one in actual tests;

\ Nlsrtl33 \ data \ *. nlb; the description file of oracle is stored in this directory. If the system cannot find these files, an error will occur;

2. registration item list

[HKEY_LOCAL_MACHINE \ Software \ Oracle]
"NLS_LANG" = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_HOME" = "C: \ orawin95"
"ORA_NLS33" = "C :\\ orawin95 \ NLSRTL33 \ DATA"

Generally speaking, the host string is used in ORACLE to indicate the connection method between the client and the server. It is just an alias. Its real content includes network protocols, ORACLE instance names, and other projects. If you want to create or modify a host string, you can use the SQL * NET EASY CONFIG program. For example, if you want to install a new ORACLE, enter the following method:

User name: SYSTEM
Password: MANAGER
Host string: TCP-LOOPBACK

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.