Home > Articles > Data > Oracle

  • Print
  • + Share This
This chapter is from the book

Sample Files

Enterprise Database Installation with Starter Database

# This is an Oracle 10g response file.
# It does an "Enterprise" install of the server
# and creates a starter database, named orcl,
# using the general-purpose template.

# For 9i, this should be changed to 1.7.0.
RESPONSEFILE_VERSION=2.2.1.0.0

# On UNIX, this variable should be set to the inventory
# group, for an initial installation.
#UNIX_GROUP_NAME=<Value Unspecified>

# Must be a fully qualified path.
FROM_LOCATION=c:\OraInst\Disk1\stage\products.jar

# If installing from multiple CDs, set this to
# the expected volume label.
#FROM_LOCATION_CD_LABEL=<Value Unspecified>

# Must be fully qualified.
ORACLE_HOME=C:\oracle\ora10

# Only needed on Windows.
ORACLE_HOME_NAME=ora10

# Designates main component to install.
# The important part in this context
# is if it's oracle.client or oracle.server.
TOPLEVEL_COMPONENT={oracle.server,10.1.0.1.0}

# Can be set to:
#  oracle.server only
#    Enterprise Edition
#    Standard Edition
#    Personal Edition
#  oracle.client only
#    Administrator
#    Runtime
#  Either client or server
#    Custom
INSTALL_TYPE=Enterprise Edition

# These only matter if the -silent flag is omitted.
# If -silent will always be used, these can be deleted.
SHOW_SPLASH_SCREEN=true
SHOW_WELCOME_PAGE=true
SHOW_CUSTOM_TREE_PAGE=true
SHOW_COMPONENT_LOCATIONS_PAGE=false
SHOW_SUMMARY_PAGE=true
SHOW_INSTALL_PROGRESS_PAGE=true
SHOW_REQUIRED_CONFIG_TOOL_PAGE=true
SHOW_CONFIG_TOOL_PAGE=true
SHOW_RELEASE_NOTES=true
SHOW_ROOTSH_CONFIRMATION=true
SHOW_END_SESSION_PAGE=true
SHOW_EXIT_CONFIRMATION=true
SHOW_DEINSTALL_CONFIRMATION=true
SHOW_DEINSTALL_PROGRESS=true

# This only matters if the LICENSE_LOCATION variable
# has been set in oraparam.ini.
# In a -silent install, this must be set to TRUE
# if there's a LICENSE_LOCATION defined in oraparam.ini.
ACCEPT_LICENSE_AGREEMENT=false

# Response files can be "chained" by setting
# NEXT_SESSION to TRUE and specifying a
# response file with NEXT_SESSION_RESPONSE.
NEXT_SESSION=false
#NEXT_SESSION_RESPONSE=<Value Unspecified>

# Only set to TRUE if you want to continue,
# even if there's been an error in the first session.
NEXT_SESSION_ON_FAIL=true

# List of software that must be installed before
# installing the currently selected software.
DEINSTALL_LIST={oracle.server,10.1.0.1.0}

# Update this if you want multiple languages.
SELECTED_LANGUAGES={en}

# On UNIX, use this to designate the DBA group.
#sl_dbaOperGroups={}

# To migrate one or more databases, set this string
# list to the SID and ORACLE_HOME of each database to be
# migrated.
# Example:
# sl_migrateSIDDialogReturn={"orcl","C:\oracle\ora92"}
#sl_migrateSIDDialogReturn={}

# Where should the JDKs be installed?
JDK_HOME=C:\oracle\ora10\jdk

# HTTP listener port for the Microsoft Transaction Server
# recod service
s_recodHTTPPort=2030

###############################
# Database Creation Variables #
###############################

# Set both of these to TRUE to create a starter
# database.
oracle.server:b_createStarterDBReturn=true
oracle.assistants.dbca:b_createStarterDBReturn=true

# Designate what type of starter database to create.
# Oracle sample response files say that this is not
# to be set by the user, but no starter database
# will be installed if this is left blank.
# Can be set to:
#   General-Purpose
#   Data Warehouse
#   OLTP
s_cfgtyperet=General Purpose

# If this is set to D, then four separate admin passwords
# should be supplied in the superAdminPasswds varables.
# If set to S, then one password should be supplied in
# the superAdminSamePasswd variables.
s_superAdminPasswdType=D

sl_superAdminPasswds={"password1","password2","password3","password4"}
sl_superAdminPasswdsAgain={"password1","password2","password3","password4"}

#s_superAdminSamePasswd=<Value Unspecified>
#s_superAdminSamePasswdAgain=<Value Unspecified>

# Designate what type of disk storage to use.
# Can be set to:
#   File System
#   Raw Device
#   ASM
s_DataorASMret=File System

# To use raw devices, set this string to a raw device.
#s_rawDeviceName=<Value Unspecified>

#s_rawDeviceMapFileLocation=
# To use Automatic Storage Management, set
# this string list.
#sl_retdisklist={NO_VALUE,null}
#s_ASMString=

# If TRUE, example schemas will be loaded.
s_loadExampleSchemas=Y

# Define database SID and global name.
s_dbSid=orcl
s_globalDBName=orcl

# Designate database character set.
s_dbRetChar=Unicode standard UTF-8 AL32UTF8

# Mount point (directory) for datafiles.
# Files will be created in a subdirectory
# with the same name as the database SID.
s_mountPoint=C:\oracle\ora10

# Schedule automatic backups of the database?
s_dlgEMExtAutoBackupSelected=Y

# Allow the database to send email notifications?
s_dlgEMEmailNotificationSelected=Y

# Use a local or central Enterprise Manager (EM) console?
s_dlgEMOptionSelected=Local Management

# Name of central EM agent.
s_dlgEMCentralAgentSelected=No Agents Found

# SMTP server to use for email notification.
s_dlgEMSMTPServer=smtp-server.austin.rr.com

# Address to which email should be sent.
s_dlgEMEmailAddress=cord@badfiddler.com

# Local operating system (OS) account and password to
# use for backups.
s_dlgEMExtUsername=OSusername
s_dlgEMExtPassword=OSpassword


#####################
# Gateway Variables #
#####################

# Designate Sybase database and directory.
#sl_sybSerRetVal=<Value Unspecified>
#s_sybRetDir=<Value Unspecified>

# Designate MS SQL Server database.
#sl_sqlDBRetVal=<Value Unspecified>

# Designate Open Database Connectivity (ODBC) database.
#s_odbcInstLoc=<Value Unspecified>
#s_odbcDsn=<Value Unspecified>

Minimal Client Response File for Windows

RESPONSEFILE_VERSION=2.2.1.0.0
FROM_LOCATION=c:\OraInst\Disk1\stage\products.jar
ORACLE_HOME=C:\oracle\ora10
ORACLE_HOME_NAME=ora10
TOPLEVEL_COMPONENT={oracle.client,10.1.0.1.0}
NEXT_SESSION=false
NEXT_SESSION_ON_FAIL=false
DEINSTALL_LIST={oracle.client,10.1.0.1.0}
SELECTED_LANGUAGES={en}
INSTALL_TYPE=Runtime

Oraparam.ini

[Oracle]
DISTRIBUTION=FALSE
SOURCE=../../stage/products.jar
LICENSE_LOCATION=
JRE_LOCATION=../../stage/Components/oracle.swd.jre/1.4.1.3.0a/1/DataFiles/Expanded
JRE_MEMORY_OPTIONS=" -mx96m"
DEFAULT_HOME_LOCATION=\oracle\ora10
DEFAULT_HOME_NAME=Ora10
NO_BROWSE=/mnt
NLS_ENABLED=TRUE
BOOTSTRAP=FALSE
OUI_VERSION=2.3.0.7.0
  • + Share This
  • 🔖 Save To Your Account