IS2009 Making an Oracle Silent installation package (a) Thank you, Mr. Blank. Licensing

Original: IS2009 making Oracle Silent installation package (a) Thank you, Mr. Blank. Licensing

Previous: MyEclipse in the elimination frame caused by "The file XXX can not found." Check the location and try again. " The error

This article by the original author authorized in the Sea goddess issued, reproduced please be sure to indicate the source and link; The original author and the Goddess of the Sea reserve the rights to all laws of the article; need to be published in a profitable newspaper, website, etc. please contact the original or the goddess of the sea.
Preface

This document is not written by me, but a friend in the recent installation package after the summary of the tutorial, thank you very much for the selfless sharing of this friend blank. It takes a lot of time to do a project, and writing an article even takes more time, and if everyone is able to respect the work of others, then perhaps more will be received.

The first part: Preface
Target Requirements
Implement esl--Embedded Software licensing
During the installation process, we need to install our software products and install the Oracle database. After you install the database
You need to import the underlying data, create the specified library, and create the user and tablespace. When you install Oracle data, you must implement the
Silent installation, no GUI interface, no installation parameters can be exposed. All installation processes are completed at once, eliminating the need for
User intervention.
Environment description
Operating system--windows XP SP3
Installation Tool--installshield 2009-premier Edition
Database--oracle 10G-R2

Part II: Configuring Oracle
This process requires an associated configuration of Oracle, including recording response files, making templates with data,
Adjust installation scripts, unlock user scripts, set environment variables, and more.
Recording response files
1. Run cmd, enter Oracle's path in the command Line window, where the path is D:\Orac\database,
ORACLE10GSERVER.RSP is the name of the file to save.

2. After running this command, the Oracle installation interface is opened.
3. Remove the Create Startup database
4. When the summary information appears, exit the installation screen and do not install.

5. The oracle10gserver.rsp file appears in the D:\Orac\database directory, indicating that the recording was successful. The
The path where the files are stored, we will use them later in the Install.bat.
Create users, tablespaces, import base data
1. Create a user, tablespace, and import base data in an existing version of the database
2. Log in using the SQL System account and execute the Createdb.sql script. Note: The path in the script should be in the actual
The data path is accurate.
3. Import files Zgisexp.dmp and zproexp.dmp. Save this script as a cmd file and execute it directly.
Note: The path in the script should be the path where the actual dmp file is stored. In addition, this script is the data information of this unit,
Not as a reference!

To create a user, Tablespace script:

Create a template with basic data
With the above data, we started to create a template for the data to use when building the library.
1. Create a database template

2. Once created, we will find the following two templates in the <oracle_home>\assistants\dbca\templates\ directory
File. Temp_10g.dbc TEMP_10.DFB
The purpose of the two files here is to create the database in the form of a database template, without having to import tables, create
User and import the underlying data. This step is done first in an existing Oracle environment. We copy these two texts.
Pieces.
3. Modify Temp_10g.dbc

Installation Script Description
During the Oracle installation process, the Setup program calls the following script to implement the Oracle installation process.
1. Install.cmd Installing Oracle Software Scripts
When you execute this script, you need to bring the above parameters, which are explained later in the specific parameters.

2. copynetca.cmd copy the Listener files and template files and create a listener service script.

Ø There are two received variables in the script, and this is the path parameter from the IS, which must exist. In addition, the mold
The board file must be copied to the specified path, <oracle_home>\assistants\dbca\templates.
3. Createdb.cmd Create a database script with template data.
This script is used to create a database from a data template with the following parameters:

4. Unlock.bat User Unlock Script
Install the database generated by the template whose user state is locked and need to perform an unlock script.

Where Change.sql is:

Collection Oracle Installation Script
The 4 scripts above are the 4 scripts required for the installation process, and we are now working on a batch file Install.bat,
So that we can call the batch when we make the installation package. Based on the parameter types of the above script, we complete the parameters.

Ø there is a received environment variable%databasedir% in the script, which is the parameter that is run by the
This parameter is the target path for the installation.
ø%sourpath% This parameter does not have any receive instructions in the bat file, but performs the installation
Process, is creates the parameter at the head end of the bat file, which is the destination source path address. How to self-
Create the variable, as described in the third part.
Ø the above script calls the top 4 scripts, each with parameters behind them.

Ok, now that the Oracle settings have been completed, we need to keep the files as 1+4 batch files, 1. SQL
Files and two template files. These files will be called in the is or installation.
Unload Script Description
1. Deinstall.cmd Uninstall the Oracle software, the parameters of the script are as follows:

2. Completeclean.cmd clears the relevant files and settings, the relevant parameters of the script are as follows:

Collection Unload Script
Ø above two scripts are used to unload the database, we set him up as a batch to facilitate the IS call.
Ø%databasedir% and%sourpath% two parameters are still present in the script. function with Install.bat

Next: IS2009 Making Oracle Silent installation package (ii) Thank you, Mr. Blank. Licensing