How to manually create an Oracle9i/10g Client

In fact, with the Instant Client, there may be no need to try to create an Oracle Client. Here, I want to explain my reasons:

1. The bug of the Instant Client is much higher than the package of the Oracle Client, which has been found in many practices.

2. Tech-loving people want to see how to extract a client package, that is, some redundancy does not matter much.

3. After you prepare a client, you only need to make it this time. You do not need to re-install the client and unzip it to use it.

Let's take a look at Oracle9i, starting from it:

Assume that the Client is installed under drive d: oracleora92 and d: oracle is used as the root directory ORACLE_BASE of all Oracle versions. The ora92 sub-directory serves as ORACLE_HOME.

Then extract some useful sub-directories. Assume that you have installed an Oracle9i server on another machine, which is located in c: oracleora92. We recommend that you extract the following sub-directories:

Assistants

Bin

Database

Dbs

Network

Oci

Ocommon

ODBC

Oledb

Oracore

Otrace

Plsql

Rdbms

Slax

Sqlplus

In bin, there are many executable programs that you don't need. You can delete them directly. We can decide on our own. Oci sub-directories facilitate the development of OCI-based applications. ODBC is used for ODBC drivers, and oledb is used for OLEDB. Other subdirectories are required.

The above is the basic file extraction. Copy these files to the d: oracleora92 directory. Then, you need a registry file to register it. This is very critical. In the past, people often asked me why it didn't work. Most of the Registry content is incorrect or not registered.

The Registry content is as follows:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREORACLE]

"Inst_loc" = "C: \ Program Files \ Oracle \ Inventory"

"ORACLE_HOME" = "D: \ oracle \ ora92"

"ORACLE_HOME_NAME" = "OraHome92"

"API" = "D: \ oracle \ ora92 \ dbs"

"ORACLE_GROUP_NAME" = "Oracle-OraHome92"

"NLS_LANG" = "NA"

"VOBHOME2.0" = "D: \ oracle \ ora92"

[HKEY_LOCAL_MACHINESOFTWAREORACLEALL_HOMES]

"HOME_COUNTER" = "1"

"DEFAULT_HOME" = "OraHome92"

"LAST_HOME" = "0"

[HKEY_LOCAL_MACHINESOFTWAREORACLEALL_HOMESID0]

"NAME" = "OraHome92"

"PATH" = "D: \ oracle \ ora92"

"NLS_LANG" = "NA"

[HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0]

"ID" = "0"

"ORACLE_GROUP_NAME" = "Oracle-OraHome92"

"ORACLE_HOME_NAME" = "OraHome92"

"ORACLE_HOME" = "D: \ oracle \ ora92"

"NLS_LANG" = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

"ORACLE_HOME_KEY" = "Software \ ORACLE \ HOME0"

"SQLPATH" = "D: \ oracle \ ora92 \ dbs"

"ORACLE_BASE" = "D: \ oracle"

"MSHELP_TOOLS" = "D: \ oracle \ ora92 \ MSHELP"

"RDBMS_CONTROL" = "D: \ oracle \ ora92 \ DATABASE"

"RDBMS_ARCHIVE" = "D: \ oracle \ ora92 \ DATABASE \ ARCHIVE"

Register this file to the Registry.

Add d: oracleora92in to your PATH environment variable, and run: sqlplus to see if there is any error. Add some Oracle service host information to the d: oracleora92etworkadminnsadmin. ora file.

Finally, as a suggestion, we recommend that you add the current user to the group "ORA_DBA.

In user management, create a group "ORA_DBA" and add the current user to the group.

These steps are basically the same. Extracted clean, a total of 200 MB, remove irrelevant, can be compressed into a compressed file is about 20 mb. Think about how much of the original oracle9i has been installed. The difference is too obvious.

As for the 10 Gb, we believe that if the above steps can be taken smoothly, 10 Gb should not be a problem.

If you are interested, you can also try to extract the file yourself to make it a green version of Oracle Server. You don't need to install it, just need a few commands.

I have tried to extract and install Oracle9i and Oracle10g. By doing this on your own, you can gain a better understanding of Oracle.