Table of Contents
The response file for installing Oracle Database 11gR2
This file is generated by the Oracle Universal Installer.
Location of the Oracle base directory.
Name of the Oracle inventory directory.
The location for your Oracle home.
The name of the database. This is typically a name that
starts with a letter and contains up to 8 characters.
Global database name.
Character set of the database.
Specify whether to install the database software or create a
database. Choose "Software Only" for database software
installation.
Specify whether to create a database or upgrade an existing one .
Choose "Create Database" for new database creation.
Choose "Upgrade an Existing Database" to upgrade an
existing database.
Password for SYS and SYSTEM users.
Database file location.
Control file location.
Redo log file location.
Memory limit for database SGA and PGA.
Language of the installation.
Valid values ​​are: AMERICAN_AMERICA.WE8ISO8859P1,
AMERICAN_AMERICA.UTF8, or other valid character set names.
You can also supply your own language name.
Installation type.
Specify whether to check for product updates.
Activate security options
Enter the system class, which determines the maximum number
of memory allowed for SGA and PGA.
Valid values ​​are: Desktop, Server, or Custom
If you choose Custom, you must specify the memory size yourself.
The following example is for a server class machine.
Specify the template to use when creating the database.
Global database name for this database.
Character set for the database.
National character set for the database.
Perform database backup after installation.
Valid values ​​are: YES or NO
Enter Y if you want to configure Enterprise Manager.
Enterprise Manager password.
Specify whether this is a Real Application Clusters installation.
Specify the VIP name and port.
Specify the SCAN name and port.
Specify the database name and listener port.
Specify the database storage type.
Configure Automatic Storage Management.
The name and file location of the installer log file.
If you do not specify a log file name or directory, the log
file is created in the /tmp directory. By default, the log
file name is "installActions.log".
Example:
LOGFILE=/u01/app/oracle/installer/log/installation.log
The name and location for storing the inventory of installed software.
If you do not specify an inventory location, the software is
installed in the default inventory directory.
INVENTORY_LOCATION=/tmp/oracleInventory
Specify the name and file location for the installation plan file.
The installation plan file provides a record of all the configuration
settings you selected during installation.
INSTALL_PLAN=/u01/app/oracle/installer/log/ planFile.lst
Specify the path to the remote shell program, if any.
This setting is required only if you are installing Oracle software
on a remote computer.
SSH_PATH=/usr/local/bin/ssh
Home Database Oracle How to install oracle11g silently

How to install oracle11g silently

Apr 17, 2023 pm 04:36 PM

Oracle is the world's leading database management system, and its 11g version is favored by many enterprises and individual users. However, the installation process of Oracle11g is relatively cumbersome. If it needs to be installed on multiple machines, it will consume a lot of time and human resources. In order to improve installation efficiency, Oracle provides a silent installation method, which can complete the automatic installation of software without human intervention. This article will introduce how to silently install Oracle11g.

1. Preparation
Before silently installing Oracle11g, you need to prepare the following work:
1.Oracle11g installation media, usually a CD or ISO image;
2.Oracle11g The response file (.rsp file) of the installation file can be modified using the template file provided by Oracle;
3. Installation schedule (.lst file), used to record the installation process and error information;
4. Management A command line interface or terminal with administrator privileges, and sufficient disk space and memory resources.

2. Create a response file
The response file (.rsp file) is the key to the silent installation of Oracle11g. It records various parameter information that needs to be entered during the installation process. Oracle provides template files (such as db_install.rsp) for modification. If you need to customize the installation parameters, you can modify the file content according to the actual situation. The following is an example of a typical response file:

The response file for installing Oracle Database 11gR2

This file is generated by the Oracle Universal Installer.

[GENERAL]

Location of the Oracle base directory.

ORACLE_BASE="/u01/app/oracle"

Name of the Oracle inventory directory.

INVENTORY_LOCATION="/ u01/app/oraInventory"

The location for your Oracle home.

ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"

The name of the database. This is typically a name that

starts with a letter and contains up to 8 characters.

ORACLE_SID="orcl"

Global database name.

GDBNAME="orcl"

Character set of the database.

CHARACTERSET="AL32UTF8"

Specify whether to install the database software or create a

database. Choose "Software Only" for database software

installation.

INSTALL_OPTION="INSTALL_DB_AND_CONFIG"

Specify whether to create a database or upgrade an existing one .

Choose "Create Database" for new database creation.

Choose "Upgrade an Existing Database" to upgrade an

existing database.

CREATE_DATABASE_TYPE= "CREATE_DATABASE"

Password for SYS and SYSTEM users.

SYS_PASSWORD="password"
SYSTEM_PASSWORD="password"

Database file location.

DATA_LOCATION="/u01/app/oracle/oradata"

Control file location.

DB_CONTROL_FILES_LOCATION="/u01/app/oracle/oradata"
DB_CONTROL_FILES="ora_control1, ora_control2 , ora_control3"

Redo log file location.

DB_RECOVERY_FILE_DEST="/u01/app/oracle/flash_recovery_area"
DB_RECOVERY_FILE_DEST_SIZE=2G

Memory limit for database SGA and PGA.

TOTAL_MEMORY=2048

[LANGUAGE]

Language of the installation.

Valid values ​​are: AMERICAN_AMERICA.WE8ISO8859P1,

AMERICAN_AMERICA.UTF8, or other valid character set names.

You can also supply your own language name.

SELECTED_LANGUAGES="AMERICAN_AMERICA.UTF8"

[INSO]

Installation type.

INSTALL_TYPE="Typical"

[INSTALLUPDATES]

Specify whether to check for product updates.

UPDATES_CHECK= TRUE

[SECURITY]

Activate security options

SECURITY_UPDATES_VIA_MYORACLESUPPORT=FALSE

[SYSTEMCLASS]

Enter the system class, which determines the maximum number

of memory allowed for SGA and PGA.

Valid values ​​are: Desktop, Server, or Custom

If you choose Custom, you must specify the memory size yourself.

The following example is for a server class machine.

oracle.install.db.config.starterdb.memoryLimit=1024

[DATABASE]

Specify the template to use when creating the database.

TEMPLATE_NAME="General_Purpose.dbc"

Global database name for this database.

GDBNAME="orcl"

Password for SYS and SYSTEM users.

SYS_PASSWORD="password"
SYSTEM_PASSWORD="password"

Character set for the database.

CHARACTERSET ="AL32UTF8"

National character set for the database.

NATIONAL_CHARACTERSET="UTF8"

Database file location.

DATA_LOCATION="/u01/ app/oracle/oradata"

Control file location.

DB_CONTROL_FILES_LOCATION="/u01/app/oracle/oradata"

Redo log file location.

DB_RECOVERY_FILE_DEST="/u01/app/oracle/flash_recovery_area"
DB_RECOVERY_FILE_DEST_SIZE=2G

Perform database backup after installation.

Valid values ​​are: YES or NO

DB_INSTALLATION_SLIM_CONFIG=true

[EMCONFIG]

Enter Y if you want to configure Enterprise Manager.

EM_CONFIGURATION=LOCAL

Enterprise Manager password.

EM_PASSWORD="password"

[REAL_APPLICATION_CLUSTER]

Specify whether this is a Real Application Clusters installation.

CLUSTER_NODES=a1,a2,a3

Specify the VIP name and port.

NODEVIP="orclvip"
NODEVIP_PORT=1521

Specify the SCAN name and port.

CLUSTER_SCAN_NAME="orclscan"
CLUSTER_SCAN_PORT="1521"
CLUSTER_SCAN_PORTS="1522,1523,1524"

Specify the database name and listener port.

DB_NAME="racdb"
DB_UNIQUE_NAME="racdb1"
DB_LISTENER_PORT=1521

Specify the database storage type.

DB_STORAGE_TYPE="ASM"

Configure Automatic Storage Management.

ASM_DISK_STRING="ORCL:*"

The above is part of the response file example, which contains Commonly used installation parameter settings are provided and can be modified according to actual conditions.

3. Create an installation plan
The installation plan (.lst file) is used to record the log information and error information generated during the silent installation of Oracle11g. Creating an installation schedule can facilitate troubleshooting problems during the installation process. Typically, the installation schedule can be configured in a response file as follows:

[GENERIC]

The name and file location of the installer log file.

If you do not specify a log file name or directory, the log

file is created in the /tmp directory. By default, the log

file name is "installActions.log".

Example:

LOGFILE=/u01/app/oracle/installer/log/installation.log

LOG_FILE="oraInstall.log"

The name and location for storing the inventory of installed software.

If you do not specify an inventory location, the software is

installed in the default inventory directory.

Example:

INVENTORY_LOCATION=/tmp/oracleInventory

INVENTORY_LOCATION="/u01/app/oraInventory"

Specify the name and file location for the installation plan file.

The installation plan file provides a record of all the configuration

settings you selected during installation.

Example:

INSTALL_PLAN=/u01/app/oracle/installer/log/ planFile.lst

INSTALL_PLAN="ora_install_plan.lst"

Specify the path to the remote shell program, if any.

This setting is required only if you are installing Oracle software

on a remote computer.

Example:

SSH_PATH=/usr/local/bin/ssh

SSH_PATH="/usr/bin/ ssh"

The above example is a configuration file for creating an installation schedule.

4. Perform silent installation
To perform silent installation, you need to use the command line interface or terminal, run with administrator privileges, enter the path where the Oracle11g installation media is located, and execute the following command:

. /runInstaller -silent -responseFile /path/to/response/file -ignoreSysPrereqs -ignorePrereq

Among them, the -responseFile parameter specifies the path and file name of the response file, the -silent parameter indicates running in silent mode, -ignoreSysPrereqs and The -ignorePrereq parameter indicates that system prerequisites and prerequisite checks are ignored.

During the installation process, you can modify the parameters according to the actual situation and follow the prompts until the installation is completed. After the installation is completed, log information and error information will be generated in the installation schedule, which can be used to troubleshoot problems.

Summary
This article introduces the steps of silent installation of Oracle11g, including creating a response file, creating an installation schedule and performing silent installation. Silent installation can significantly improve installation efficiency, especially when Oracle11g needs to be installed on multiple machines, it is more convenient and faster. I hope this article can help users who are installing Oracle11g and reduce their workload.

The above is the detailed content of How to install oracle11g silently. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What are the oracle database operation tools? What are the oracle database operation tools? Apr 11, 2025 pm 03:09 PM

In addition to SQL*Plus, there are tools for operating Oracle databases: SQL Developer: free tools, interface friendly, and support graphical operations and debugging. Toad: Business tools, feature-rich, excellent in database management and tuning. PL/SQL Developer: Powerful tools for PL/SQL development, code editing and debugging. Dbeaver: Free open source tool, supports multiple databases, and has a simple interface.

How to check tablespace size of oracle How to check tablespace size of oracle Apr 11, 2025 pm 08:15 PM

To query the Oracle tablespace size, follow the following steps: Determine the tablespace name by running the query: SELECT tablespace_name FROM dba_tablespaces; Query the tablespace size by running the query: SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_

How to learn oracle database How to learn oracle database Apr 11, 2025 pm 02:54 PM

There are no shortcuts to learning Oracle databases. You need to understand database concepts, master SQL skills, and continuously improve through practice. First of all, we need to understand the storage and management mechanism of the database, master the basic concepts such as tables, rows, and columns, and constraints such as primary keys and foreign keys. Then, through practice, install the Oracle database, start practicing with simple SELECT statements, and gradually master various SQL statements and syntax. After that, you can learn advanced features such as PL/SQL, optimize SQL statements, and design an efficient database architecture to improve database efficiency and security.

What to do if the oracle can't be opened What to do if the oracle can't be opened Apr 11, 2025 pm 10:06 PM

Solutions to Oracle cannot be opened include: 1. Start the database service; 2. Start the listener; 3. Check port conflicts; 4. Set environment variables correctly; 5. Make sure the firewall or antivirus software does not block the connection; 6. Check whether the server is closed; 7. Use RMAN to recover corrupt files; 8. Check whether the TNS service name is correct; 9. Check network connection; 10. Reinstall Oracle software.

How to create oracle database How to create oracle database How to create oracle database How to create oracle database Apr 11, 2025 pm 02:36 PM

To create an Oracle database, the common method is to use the dbca graphical tool. The steps are as follows: 1. Use the dbca tool to set the dbName to specify the database name; 2. Set sysPassword and systemPassword to strong passwords; 3. Set characterSet and nationalCharacterSet to AL32UTF8; 4. Set memorySize and tablespaceSize to adjust according to actual needs; 5. Specify the logFile path. Advanced methods are created manually using SQL commands, but are more complex and prone to errors. Pay attention to password strength, character set selection, tablespace size and memory

Oracle PL/SQL Deep Dive: Mastering Procedures, Functions & Packages Oracle PL/SQL Deep Dive: Mastering Procedures, Functions & Packages Apr 03, 2025 am 12:03 AM

The procedures, functions and packages in OraclePL/SQL are used to perform operations, return values ​​and organize code, respectively. 1. The process is used to perform operations such as outputting greetings. 2. The function is used to calculate and return a value, such as calculating the sum of two numbers. 3. Packages are used to organize relevant elements and improve the modularity and maintainability of the code, such as packages that manage inventory.

How to view the oracle database How to view the oracle database How to view the oracle database How to view the oracle database Apr 11, 2025 pm 02:48 PM

To view Oracle databases, you can use SQL*Plus (using SELECT commands), SQL Developer (graphy interface), or system view (displaying internal information of the database). The basic steps include connecting to the database, filtering data using SELECT statements, and optimizing queries for performance. Additionally, the system view provides detailed information on the database, which helps monitor and troubleshoot. Through practice and continuous learning, you can deeply explore the mystery of Oracle database.

How to encrypt oracle view How to encrypt oracle view Apr 11, 2025 pm 08:30 PM

Oracle View Encryption allows you to encrypt data in the view, thereby enhancing the security of sensitive information. The steps include: 1) creating the master encryption key (MEk); 2) creating an encrypted view, specifying the view and MEk to be encrypted; 3) authorizing users to access the encrypted view. How encrypted views work: When a user querys for an encrypted view, Oracle uses MEk to decrypt data, ensuring that only authorized users can access readable data.

See all articles