Methods that clients can also connect to databases without installing Oracle

Methods that clients can also connect to databases without installing Oracle

This paper takes oracle8i as an example:

First install an Oracle client,

Keep the Bin,network,ocommon three directories under the Oracle directory, and delete all the rest,

Export hkey_local_machine/software/oracle in the registry.

When you install a new machine, copy the Oracle directory and registry files into the registry, register with the Oracle/bin path, and restart.

Precautions:

1. The new computer directory to install the Oracle client machine directory consistent, if not consistent, you need to modify the registry;

2. Must add Oracle/bin path in path;

3. Restart the machine, the above two steps must restart the machine Oracle client to work. )

I do not install the client connection Oracle8 by using the following methods: The client operating system is 98.

1. Create a directory (such as: C:/orawin95) to copy the Oracle/bin directory and related files from the Nlsrtl33/data directory to this directory (the files in these two directories can be placed together or placed in the same place.) After the list of documents is shown);

2. Add three Oracle Registration items in the registry (see after registration);

3. Increase the Oracle and application paths in the Autoexec.bat;

4. Copy the runtime of the application to the path that the system can search, preferably in the application directory;

5. Copy the Tnsnames.ora and Sqlnet.ora to the application directory and configure them;

6. Restart your computer to ensure that both directories are in the PATH environment variable for your system.

7. At this point, the configuration is complete.

Report:

1. Oracle Document List

/bin/*.dll; Most of these DLLs are not needed. Given the large number of documents, this is not listed here, can be eliminated in the actual test;

LSRTL33/DATA/*.NLB; This directory is delegated Oracle's description file, if the system cannot find these files, there will be errors;

2. List of registered items

[Hkey_local_machine/software/oracle]

"Nls_lang" = "Simplified Chinese_china." ZHS16GBK "

"Oracle_home" = "C://orawin95"

"Ora_nls33" = "C://orawin95//nlsrtl33//data"

In layman's terms, the host string is the way Oracle uses to indicate a client-side connection to the server. It's just an alias, and its true content contains items such as network protocols, oracle instance names, and so on. If you want to create or modify a host string, you can use the Sql*net Easy Config program. For example, a new Oracle installation can be entered in the following ways:

User name: SYSTEM

Password: MANAGER

Host string: Tcp-loopback