Skip to main content

Oracle Response Files

Oracle Database Install

Creating a response file for a silent installation of Oracle Database is a common task that allows you to automate the installation process without needing to interact with the graphical user interface. Below is an example response file for installing Oracle Database 19c on a Linux system. Keep in mind that response files can significantly vary depending on the Oracle Database version and the specific configurations you need. Adjustments may be required to fit your particular environment and requirements.

This example assumes you're installing Oracle Database 19c with a typical installation type, which includes the creation of a general-purpose database. You'll need to replace placeholders (like <YOUR_VALUE_HERE>) with actual values relevant to your setup.

Create a file named db_install.rsp and include the following content:

[GENERAL]
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=<YOUR_HOSTNAME>
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
ORACLE_BASE=/u01/app/oracle

[INSTALL]
nodelist=<YOUR_HOSTNAME>
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.rootconfig.executeRootScript=true
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=<YOUR_GLOBAL_DBNAME>
oracle.install.db.config.starterdb.SID=<YOUR_SID>
oracle.install.db.ConfigureAsContainerDB=false
oracle.install.db.config.PDBName=<YOUR_PDB_NAME>
oracle.install.db.config.starterdb.characterSet=<YOUR_CHARACTER_SET>
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=<MEMORY_LIMIT_IN_MB>
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.password.ALL=<YOUR_PASSWORD>
oracle.install.db.config.starterdb.storageType=FS
oracle.install.db.config.starterdb.dataLocation=/u01/oradata
oracle.install.db.config.starterdb.recoveryLocation=<YOUR_RECOVERY_LOCATION>
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.registerWithDirService=false
oracle.install.db.config.starterdb.listeners=<LISTENER_NAME>

[DELPHIX]
DELPHIX_DB_CONF=<DELPHIX_CONFIGURATION_OPTION>

Replace the placeholders with your specific configuration:

  • <YOUR_HOSTNAME>: The hostname of your server.
  • <YOUR_GLOBAL_DBNAME>: The global database name.
  • <YOUR_SID>: The system identifier for your database.
  • <YOUR_PDB_NAME>: The pluggable database name, if you're using the multitenant architecture.
  • <YOUR_CHARACTER_SET>: The character set for your database (e.g., AL32UTF8).
  • <MEMORY_LIMIT_IN_MB>: The memory limit for your database in megabytes.
  • <YOUR_PASSWORD>: The password for SYS, SYSTEM, and other default administrative accounts.
  • <YOUR_RECOVERY_LOCATION>: The path for the recovery area.
  • <LISTENER_NAME>: The name of the Oracle Net listener.
  • <DELPHIX_CONFIGURATION_OPTION>: Specific to your Delphix configuration, if applicable.

To run the Oracle Database installer silently using your response file, execute the following command from the directory where your Oracle Database installation files are located:

./runInstaller -silent -responseFile /path/to/db_install.rsp -ignorePrereqFailure

Replace /path/to/db_install.rsp with the actual path to your response file.

Important Notes:

  • Ensure that all prerequisites for Oracle Database installation are met before running the installer, including any required packages, kernel parameters, and user and group configurations.
  • The -ignorePrereqFailure flag is optional and allows the installer to continue even if some prerequisites are not met. It's generally recommended to address all prerequisite checks for a production environment.
  • Running the root scripts (/u01/app/oraInventory/orainstRoot.sh and /u01/app/oracle/product/19.0.0/dbhome_1/root.sh) as the root user is typically required to complete the installation. The installer will prompt you for this if not included in the response file.
  • This example does not cover all possible configurations and options. Review the Oracle Database Installation Guide for your specific version and adjust the response file accordingly.

Database Creation

To create a new Oracle Database that includes a new Container Database (CDB) with a Pluggable Database (PDB), and to ensure that logs, archive logs, data files, and the Fast Recovery Area are on different volumes, you will use a response file tailored for the database creation process using the Database Configuration Assistant (DBCA).

The character set compatible with WebLogic SOA Suite RCU is typically AL32UTF8, as it supports Unicode and is widely used for applications requiring extensive character support.

Given the specifications, the response file will be crafted to meet the following requirements:

  • Create a new CDB and PDB
  • Allocate 6GB of RAM to the database and enable Automatic Memory Management
  • Place logs, archive logs, data files, and the Fast Recovery Area on different volumes
  • Use AL32UTF8 as the character set to ensure compatibility with WebLogic SOA Suite RCU

Below is an example response file template for creating a new Oracle CDB with a PDB. Please adjust paths and names to suit your environment.

[GENERAL]
responseFileVersion=/oracle/assistants/dbca/rspfmt_dbca.rsp
GDBNAME = "cdb1.example.com"
SID = "cdb1"
CREATEASCONTAINERDATABASE = true
NUMBEROFPDBS = 1
PDBNAME = "pdb1"
PDBADMINPASSWORD = "<Your_PDB_Admin_Password>"
TEMPLATENAME = "General_Purpose.dbc"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16"
DATABASETYPE = "MULTIPURPOSE"

[createDatabase]
gdbName = cdb1
sid = cdb1
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=pdb1
templateName=General_Purpose.dbc
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
databaseType=MULTIPURPOSE
automaticMemoryManagement=true
totalMemory=6000
storageType=FS
datafileDestination=/u02/oradata
recoveryAreaDestination=/u03/fast_recovery_area
redoLogFileSize=300
emConfiguration=NONE
listeners=LISTENER

[createContainerDatabase]
gdbName = cdb1
templateName = General_Purpose.dbc
sid = cdb1
createAsContainerDatabase = true
numberOfPDBs = 1
pdbName = pdb1
createPDBTemplate = "PDB Admin Managed Template"
pdbAdminUserName = admin
pdbAdminPassword = <Your_PDB_Admin_Password>
datafileDestination = /u02/oradata/cdb1/
recoveryAreaDestination = /u03/fast_recovery_area/cdb1/
storageType = FS

[CONFIGUREDATABASE]
LOGFILEDEST_1 = "/u04/logs/"
LOGFILEDEST_2 = "/u05/archive_logs/"
LOGFILEDEST_3 = "/u02/oradata/"

Replace <Your_PDB_Admin_Password> with a secure password for your PDB admin user.

Notes:

  • Paths: /u02/oradata, /u03/fast_recovery_area, /u04/logs, and /u05/archive_logs should be replaced with the actual mount points or directories you've set up on your system for data files, the Fast Recovery Area, logs, and archive logs, respectively.
  • Total Memory: The totalMemory parameter is set to 6000, representing approximately 6GB of RAM dedicated to the Oracle instance. Oracle will manage this memory automatically because automaticMemoryManagement is set to true.
  • Character Sets: CHARACTERSET is set to AL32UTF8, and NATIONALCHARACTERSET is set to AL16UTF16, which are suitable for globalized applications and compatibility with WebLogic SOA Suite RCU.
  • Listeners: This template assumes a listener named LISTENER is already configured on the default port (1521). Adjust as necessary for your environment.

Execution

To create the database using the response file, you would typically use the dbca command-line tool, specifying the response file with the -silent and -responseFile options:

dbca -silent -createDatabase -responseFile /path/to/your_response_file.rsp

Make sure to replace /path/to/your_response_file.rsp with the actual path to your response file.

Important: This response file template is provided as a starting point. You may need to adjust values and paths according to your specific Oracle Database version, system architecture, and requirements. Always review the Oracle Database documentation for the version you're installing to ensure compatibility and correctness.

No Comments
Back to top