How to package application programs with Oracle clients

oracle| Program | packaging | How the client packages the application program with the Oracle client                                                     Author: Bi Zhaojie    We often need to install Oracle clients when we do the program, and if the client terminal is very many, this will be a very troublesome task, on the one hand, to arrange our application, on the other hand, to install the Racle client, And it's annoying to have a net easy configuration for Oracle clients.    for this I studied for a long time, and now I finally did it. You can package Oracle clients and applications, and configure net easy with your own program, just two days ago, two little boys asked me how to package the client and use the program to configure net easy, I'm going to say it here today.    due to the time problem, today can only talk about the client packaging problem, another issue I will tell you in the next article. 1, packaging to know the problem:   a, what files to package.   b, how to modify the registry.   c, how to set environment variables.   d, packaging and using which tools. 2, packaging to use the file:   we first find a machine equipped with Oracle, the following files packaged. In order to ensure Oracle access, we need to keep the original directory structure unchanged.   a, $ORACLE _home\bin all dll,imp below. Exe,exp. Exe,sqlplus. EXE,SQLPLUSW. Exe. ($ORACLE _home refers to the home directory of ORACLE, such as D:\ORACLE\ORA8I).   b, $ORACLE _home\network directory of three directories: Admin, MESG,Tnsapi, pack them all up.   c, $ORACLE _home\ocommon\nls directory.   d, $ORACLE _HOME\ORACORE\MESG directory.   e, $ORACLE _home qlplus under two directories: admin, MESG. 3, how to modify the registry:   no trouble, we can copy the Oracle information in the registry of the Oracle machine. Copy all. 4, how to set environment variables:   Set environment variables, we want to add $oracle_home\bin;5 in front of the path, which packaging tools to use:       My favorite tool is Wiseinstaller, which is powerful enough to import the entire file directory (which I feel is better than install shilled), import the registry, set environment variables, and set up NT services, etc. (I seem to advertise it).        we can use it now to be our client.        The first step, first of all I said the file directory into our installation works.        Step Two, locate the Setup registry option, and import all the registry values below HKEY_LOCAL_MACHINE Oftware\oracle in the registry.        step three, find the environment variable setting option and add $oracle_home\bin to its path. The $oracle_home here are replaced with <Installdir>.        finish all this, compile, publish, OK. 6, how to use manual to modify net easy.        now suppose that we have finished this installation package and installed it on our computer, then there is no Oracle option on the Start menu, how to set Oracle NET Easy to do?        we can now temporarily thisSample do:       open our Oracle Client installation directory, find the Network\admin subdirectory below the Tnsnames.ora this file, directly to edit it on the line.        For example, we now want to configure a service name called NTServer, which we can write: NTServer = (DESCRIPTION =   ( Address_list =       (address = (PROTOCOL = TCP) (HOST = machine name) (port = port number))    nbsp;  (Connect_data =       (service_name = global database name)   ))         then, add it directly to the back of the Tnsnames.ora file.        if ntserver This service name already exists, we can directly modify its machine name,        Port number and global database name is OK.