Brief Introduction to Oracle silent installation

This article mainly introduces the installation of Oracle database and the creation of database in silent way. Create users, user groups and environment settings and graphical installation is the same, the specific setting of the way please refer to blog: http://blog.csdn.net/huang_tg/archive/2010/06/03/5645131.aspx.

Silent installation consists of three steps: Silently installing Oracle software, silently upgrading Oracle software, and silently creating a database. First we start with the silent installation of Oracle software.

I. Silent installation of Oracle software

1. Create a silent installation response file (Oui mode)

Using Oui to record a response file, this step requires a graphical terminal that can be recorded on other servers if the target server is not supported, but be aware that the related environment settings are consistent with the target server. Using the Oui method is the simplest and not error-prone, but it is more cumbersome when the server does not support graphics terminals. Oui recording a response file requires attention: During the recording process, choose to install only the database software does not create the database, when the installation interface to the last step is to select Cancel. The following is a specific command, OUI operation is not given.

[Oracle@test database]$. Runinstaller-record-destinationfile/u01/enterprise01.rsp

2. Create a silent installation response file (text editing method)

Directly edit the way to operate the most simple, of course, it is easier to make mistakes, need to have some understanding of the relevant parameters, but in the server does not support graphics terminals when his advantages are reflected, the specific parameters and the meaning of reference documents/database/response/ Enterprise.rsp. The following is an example of a response file for reference only:

[Oracle@test u01]$ VI ENTERPRISE01.RSP

responsefile_version=2.2.1.0.0

From_location= ". /stage/products.xml "

Oracle_home= "/u01/app/oracle/product/10.2.0/db_1/"

Oracle_home_name= "Oradb10g_home1"

toplevel_component={"Oracle.server", "10.2.0.1.0"}

deinstall_list={"Oracle.server", "10.2.0.1.0"}

Show_splash_screen=false

Show_welcome_page=false

Show_component_locations_page=false

Show_custom_tree_page=false

Show_summary_page=false

Show_install_progress_page=false

Show_required_config_tool_page=false

Show_config_tool_page=false

Show_release_notes=false

Show_rootsh_confirmation=false

Show_end_session_page=false

Show_exit_confirmation=false

Next_session=false

Next_session_on_fail=false

Show_deinstall_confirmation=false

Show_deinstall_progress=false

Accept_license_agreement=true

component_languages={"en"}

cluster_nodes=

Install_type= "EE"

S_namefordbagrp=dba

S_nameforopergrp=dba

B_oneclick=false

Show_database_configuration_page=false

B_createstarterdb=false

3. Install Oracle software using response files

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

The actual need to generate a response file, through the replay response file to install Oracle software. Specific steps

[Oracle@test database]$. Runinstaller-silent-responsefile/u01/enterprise01.rsp

When you are done, view/u01/app/oracle/orainventory/logs/ Silentinstallyyyy-mm-dd.log log file, if no error, switch to root run script orainstroot.sh and root.sh

[Root@test u01]#. /u01/app/oracle/orainventory/orainstroot.sh

[Root@test u01]#. /u01/app/oracle/product/10.2.0/db_1/root.sh

There is no error in this step, then congratulations, Oracle Software is installed, the next task on the patch package, the package can be patched through oui, through the oui Way of reference blog: http://blog.csdn.net/huang_tg/archive/ 2010/06/08/5656329.aspx. You can also upgrade by silently. The following describes how to patch the database software by using a response file.

4. Use response file to patch Oracle software

The following is the introduction of 10.2.0.1 upgrade to 10.2.0.3, extract the file after the upgrade package DISK1/RESPONSE/PATCHSET.RSP, according to the actual environment settings to edit this file, the main editing items are: unix_group_name,from_ Location,oracle_home,oracle_home_name. Oracle_home_name can be obtained from the Home Name field in the file/orainventory/contentsxml/inventory.xml.

[Oracle@test disk1]$./runinstaller-silent-ignorediskwarning-responsefile/u01/patchset01.rsp

[Root@test u01]#. /u01/app/oracle/product/10.2.0/db_1/root.sh

After the response file has finished running, view the related log according to its prompts, if there is no error, then the patch installation is successful, and finally with the information prompted to switch to the root user to run the relevant script. Our Oracle installation and patching has been completed in one step. The next task creates the database and configures the listener. There are many ways to create a database, use a seed database to create or use commands, and make decisions based on the actual situation. Here's how to create the data we need using the response file and the seed database.

5. Create database using response file and seed database

The seed database needs to be created through the DBCA manage templates, and of course it uses the $oracle_home/assistants/dbca/templates/seed database. After the seed database is created, modify the/DATABASE/RESPONSE/DBCA.RSP file in the Oracle installation file and modify the parameter Gdbname,sid,templatename according to the actual situation. If you want to use an OEM, you also need to modify the emconfiguration= "local", Sysmanpassword,dbsnmppassword. Then execute the following command:

[Oracle@test bin]#./dbca-silent-createdatabase-responsefile/u01/dbca.rsp

You can use the command to silently delete a database that already exists:

[Oracle@test bin]$ dbca-silent-deletedatabase-sourcedb orcl-sid orcl-sysdbausername Orcl-sysdbapassword

6. Configure listening via response file

The monitoring configuration can also be configured through response files, modify the/DATABASE/RESPONSE/DBCA.RSP files in the Oracle installation files, modify the parameters according to the actual situation install_type= "custom", listener_names={ "LISTENER"},listener_protocols={"tcp;1521"},listener_start= "" LISTENER ""

[Oracle@test ~]#./dbca/silent/responsefile/u01/netca.rsp

The above is simply a brief introduction of how to complete our Oracle database installation with several response files under/database/response/in the Oracle installation files. These methods are very useful at some point.