oracle 12c 靜默安裝
環境：
作業系統：CentOS 6.4
資料庫 ：Oracle 12C r1
安裝路徑，最好是20g以上，下載的安裝檔案放在次路徑
/taryartar/12c
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------安裝前準備------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
建立使用者和組
groupadd -g 1000 oinstall
groupadd -g 1031 dba
useradd -u 1101 -g oinstall -G dba oracle
oinstall組：是清單目錄組（Oracle Inventory group），用於管理清單目錄（Inventory）
dba組：用於資料庫管理。
建立目錄
mkdir -p /taryartar/12c/db_base/db_home
chown -R oracle:oinstall /taryartar/12c/db_base
chmod -R 775 /taryartar/12c/db_base
檢視實體記憶體，實體記憶體最好2G以上
[root@rac1 12c]# grep MemTotal /proc/meminfo
MemTotal: 2225780 kB
檢視記憶體檔案系統
[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
5.8G 3.8G 1.7G 70% /
/dev/sda1 99M 13M 81M 14% /boot
tmpfs 1.1G 0 1.1G 0% /dev/shm
/dev/sdb1 16G 173M 15G 2% /taryartar/12c
[root@mydns ~]# free -g
total used free shared buffers cached
Mem: 2 0 2 0 0 0
-/+ buffers/cache: 0 2
Swap: 2 0 2
檢視SWAP的大小
[root@rac1 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 2588664 kB
swap space：通常是實體記憶體的2倍
至少要有1G的臨時空間
[root@mydns ~]# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_nod1-lv_root
29G 13G 16G 44% /
決定系統的架構：是32位還是64位
[root@rac1 ~]# uname -m
x86_64
Red Hat Enterprise Linux 6要求的核心是2.6.32-71及以上
[root@rac1 ~]# cat /proc/version
Linux version 2.6.32-71.el6.x86_64 (mockbuild@c6b6.centos.org) (gcc version 4.4.4 20100726 (Red Hat 4.4.4-13) (GCC) ) #1 SMP Fri May 20 03:51:51 BST 2011
[root@rac1 12c]# uname -r
2.6.32-358.el6.x86_64
[root@rac1 12c]# lsb_release -a
LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 6.4 (Final)
Release: 6.4
Codename: Final
檢視並安裝如下的包
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
檢視包
rpm -q libX11
解壓安裝檔案
unzip linuxamd64_12c_database_1of2.zip
unzip linuxamd64_12c_database_2of2.zip
==禁用安全的LINUX(secure linux,SELINUX)
SELinux 的不正確配置會影響網路
Disable secure linux by editing the "/etc/selinux/config" file
enforcing - SELinux security policy is enforced.代表記錄警告且阻止可疑行為
permissive - SELinux prints warnings instead of 代表僅記錄安全警告但不阻止可疑行為
disabled - SELinux is fully disabled.SELinux 被禁用
SELINUXTYPE設定
targeted 代表僅針對預製的幾種網路服務和訪問請求使用 SELinux 保護，
strict 代表所有網路服務和訪問請求都要經過 SELinux。
設定
SELINUX=disabled
檢視系統當前的安全策略
[grid@rac1 ~]$ sestatus
SELinux status: disabled
[grid@rac1 ~]$ getenforce
Disabled
改變SELinux執行狀態
Enforcing=1
Permissive=0
[grid@rac1 ~]$setenforce [ Enforcing | Permissive | 1 | 0 ]
==設定環境變數
1.顯示使用哪個SHELL
[oracle@rac1 ~]$ echo $SHELL
/bin/bash
2.修改啟動檔案，或者配置檔案
Bash shell (bash):
$ vi .bash_profile
Bourne shell (sh) or Korn shell (ksh):
$ vi .profile
C shell (csh or tcsh):
% vi .login
為使用者“oracle”設定環境變數
sudo su - oracle
vi .bash_profile
加入如下內容
export ORACLE_BASE=/taryartar/12c/db_base
export ORACLE_HOME=$ORACLE_BASE/db_home
export ORACLE_SID=taryartar1
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
export ORACLE_HOSTNAME=rac1.taryartar.com
export DB_UNIQUE_NAME=tar
export CVUQDISK_GRP=oinstall
umask 022
cd $ORACLE_HOME
====核心引數設定
核心修改，所有的核心引數放在下面的檔案中
/etc/sysctl.conf
shmmax=實體記憶體*80%*80% 單位是位元組
kernel.shmmax：表示單個共享記憶體段的最大值，以位元組為單位，此值一般為實體記憶體的一半，不過大一點也沒關係，這裡設定的為4GB，即“4294967295/1024/1024/1024=4G”。
kernel.shmmin：表示單個共享記憶體段的最小值，預設為1byte
kernel.shmall：表示整個系統範圍內可用共享記憶體頁的總量，單位是頁（page），在32位系統上一頁等於4kB，也就是4096位元組。計算公式是：shmmax/PAGE_SIZE
kernel.shmmni：表示整個系統範圍內記憶體段的最大數量，一般為4096.（）
ip_local_port_range ：表示埠的範圍，。在監聽器幫助客戶端程式和伺服器程式建立連線時，會用到指定範圍內的埠。
kernel.sem ：表示設定的訊號量，這4個引數內容大小固定。
net.core.rmem_default ：表示接收套接字緩衝區大小的預設值（以位元組為單位）。
net.core.rmem_max ：表示接收套接字緩衝區大小的最大值（以位元組為單位）
net.core.wmem_default ：表示傳送套接字緩衝區大小的預設值（以位元組為單位）。
net.core.wmem_max ：表示傳送套接字緩衝區大小的最大值（以位元組為單位）。
編輯檔案/etc/sysctl.conf，加入類似於下面的內容
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1349242060
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
讓核心引數設定馬上生效
[root@rac1 ~]# cat /etc/sysctl.conf
檢視核心引數的當前值
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
/sbin/sysctl -a | grep aio-max-nr
==修改資源控制檔案
資源限制是針對單個程式的限制，不是針對整個系統總的設定
修改limits.conf以後，將馬上生效。但是，如果使用者已經登入系統，那麼對於該使用者的限制將在下一次使用者重新登入以後才生效。如果要讓對該使用者的限制生效，只能讓該使用者登出然後重新登入就可以了。
/etc/security/limits.conf
core - 限制核心檔案的大小
date - 最大資料大小
fsize - 最大檔案大小
memlock - 最大鎖定記憶體地址空間
nofile - 開啟檔案的最大數目
rss - 最大持久設定大小
stack - 最大棧大小
cpu - 以分鐘為單位的最多 CPU 時間
noproc - 程式的最大數目
as - 地址空間限制
maxlogins - 此使用者允許登入的最大數目
檢視當前的資源限制（當前使用者的）
ulimit -a
limits.conf檔案的格式
domain：可以是一個使用者名稱或者一個組(用@來區分)，或者使用萬用字元*。
type：有 soft，hard 和 -，soft 指的是當前系統生效的設定值，也就是使用者一登入就要開啟那麼多的檔案控制程式碼，hard 表明系統中所能設定的最大值。soft 的限制不能比hard 限制高。用 – 就表明同時設定了 soft 和 hard 的值。
item：可以是下列選項的任何一個：
編輯檔案/etc/security/limits.conf
為使用者oracle設定資源限制，加入如下內容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
nofile - 開啟檔案的最大數目，該值不能等於/proc/sys/fs/file-max，如果等於file-max且開啟的檔案控制程式碼的數量達到file-max，使用者將不能登陸作業系統。
注意：有些時候，設定並不能生效，如直接透過SSH以oracle登入，則設定不生效；如果以root登入再sudo 到ORACLE,則不行。
解決方法：
1）
編輯檔案/etc/ssh/sshd_config
設定UsePrivilegeSeparation等於no
2）
重啟sshd
這種做法會影響到PAM，所以需要和管理員進行協調。
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------安裝Oracle軟體------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
響應檔案模板的存放位置
$ORACLE_HOME/assistants/
$stage_area/database/response
有下面幾種型別響應檔案（模板）
db_install.rsp Silent installation of Oracle Database 12c
grid_install.rsp Silent installation of Oracle Grid Infrastructure
dbca.rsp Silent installation of Database Configuration Assistant
netca.rsp Silent installation of Oracle Net Configuration Assistant
複製模板（所有的）到/taryartar/12c/
[oracle@rac1 response]$ cp *.rsp /taryartar/12c/
改變模板的屬性
chmod 700 *.rsp
編輯響應檔案db_install.rsp，編輯後的內容如下：
####################################################################
## Copyright(c) Oracle Corporation 1998,2013. All rights reserved.##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file contains plain text passwords and ##
## should be secured to have read permission only by oracle user ##
## or db administrator who owns this installation. ##
## ##
####################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
# - INSTALL_DB_SWONLY
# - INSTALL_DB_AND_CONFIG
# - UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=rac1
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/taryartar/12c/oraInventory
#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.
#
# en : English ja : Japanese
# fr : French ko : Korean
# ar : Arabic es : Latin American Spanish
# bn : Bengali lv : Latvian
# pt_BR: Brazilian Portuguese lt : Lithuanian
# bg : Bulgarian ms : Malay
# fr_CA: Canadian French es_MX: Mexican Spanish
# ca : Catalan no : Norwegian
# hr : Croatian pl : Polish
# cs : Czech pt : Portuguese
# da : Danish ro : Romanian
# nl : Dutch ru : Russian
# ar_EG: Egyptian zh_CN: Simplified Chinese
# en_GB: English (Great Britain) sk : Slovak
# et : Estonian sl : Slovenian
# fi : Finnish es_ES: Spanish
# de : German sv : Swedish
# el : Greek th : Thai
# iw : Hebrew zh_TW: Traditional Chinese
# hu : Hungarian tr : Turkish
# is : Icelandic uk : Ukrainian
# in : Indonesian vi : Vietnamese
# it : Italian
#
# all_langs : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs
#-------------------------------------------------------------------------------
SELECTED_LANGUAGES=en
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#-------------------------------------------------------------------------------
ORACLE_HOME=/taryartar/12c/db_base/db_home
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/taryartar/12c/db_base
#-------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# - EE : Enterprise Edition
# - SE : Standard Edition
# - SEONE : Standard Edition One
# - PE : Personal Edition (WINDOWS ONLY)
#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
###############################################################################
# #
# PRIVILEGED OPERATING SYSTEM GROUPS #
# ------------------------------------------ #
# Provide values for the OS groups to which OSDBA and OSOPER privileges #
# needs to be granted. If the install is being performed as a member of the #
# group "dba", then that will be used unless specified otherwise below. #
# #
# The value to be specified for OSDBA and OSOPER group is only for UNIX based #
# Operating System. #
# #
###############################################################################
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#-------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=dba
#------------------------------------------------------------------------------
# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.BACKUPDBA_GROUP=dba
#------------------------------------------------------------------------------
# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DGDBA_GROUP=dba
#------------------------------------------------------------------------------
# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.KMDBA_GROUP=dba
###############################################################################
# #
# Grid Options #
# #
###############################################################################
#------------------------------------------------------------------------------
# Specify the type of Real Application Cluster Database
#
# - ADMIN_MANAGED: Admin-Managed
# - POLICY_MANAGED: Policy-Managed
#
# If left unspecified, default will be ADMIN_MANAGED
#------------------------------------------------------------------------------
oracle.install.db.rac.configurationType=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is ADMIN_MANAGED
#
# Specify the cluster node names selected during the installation.
# Leaving it blank will result in install on local server only (Single Instance)
#
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=
#------------------------------------------------------------------------------
# This variable is used to enable or disable RAC One Node install.
#
# - true : Value of RAC One Node service name is used.
# - false : Value of RAC One Node service name is not used.
#
# If left blank, it will be assumed to be false.
#------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=
#------------------------------------------------------------------------------
# Value is required only if oracle.install.db.isRACOneInstall is true.
#
# Specify the name for RAC One Node Service
#------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a name for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolName=pool1
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a number as cardinality for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolCardinality=2
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolCardinality=
###############################################################################
# #
# Database Configuration Options #
# #
###############################################################################
#-------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
# - GENERAL_PURPOSE/TRANSACTION_PROCESSING
# - DATA_WAREHOUSE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=
#-------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=
#-------------------------------------------------------------------------------
# Specify the Starter Database SID.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=
#-------------------------------------------------------------------------------
# Specify whether the database should be configured as a Container database.
#-------------------------------------------------------------------------------
oracle.install.db.ConfigureAsContainerDB=
#-------------------------------------------------------------------------------
# Specify the Pluggable Database name for the pluggable database in Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.PDBName=
#-------------------------------------------------------------------------------
# Specify the Starter Database character set.
#
# One of the following
# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=
#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=
#-------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available
# on the system.
# Example: oracle.install.db.config.starterdb.memoryLimit=512
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=
#-------------------------------------------------------------------------------
# This variable controls whether to load Example Schemas onto
# the starter database or not.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=
###############################################################################
# #
# Passwords can be supplied for the following four schemas in the #
# starter database: #
# SYS #
# SYSTEM #
# DBSNMP (used by Enterprise Manager) #
# #
# Same password can be used for all accounts (not recommended) #
# or different passwords for each account can be provided (recommended) #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=
#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=
#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=
#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=
#-------------------------------------------------------------------------------
# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.PDBADMIN=
#-------------------------------------------------------------------------------
# Specify the management option to use for managing the database.
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.
# 2. DEFAULT -If you want to manage your database using the default Database Express option.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.managementOption=
#-------------------------------------------------------------------------------
# Specify the OMS host to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsHost=
#-------------------------------------------------------------------------------
# Specify the OMS port to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsPort=
#-------------------------------------------------------------------------------
# Specify the EM Admin user name to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminUser=
#-------------------------------------------------------------------------------
# Specify the EM Admin password to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminPassword=
###############################################################################
# #
# SPECIFY RECOVERY OPTIONS #
# ------------------------------------ #
# Recovery options for the database can be mentioned using the entries below #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable is to be set to false if database recovery is not required. Else
# this can be set to true.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableRecovery=
#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
# - FILE_SYSTEM_STORAGE
# - ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=
#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
#-------------------------------------------------------------------------------
# Specify the recovery location.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=
#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example : MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=ccbc
#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=0
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example : PROXY_HOST=proxy.domain.com
#------------------------------------------------------------------------------
PROXY_HOST=
#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and atleast 2 chars.
#
# Example : PROXY_PORT=25
#------------------------------------------------------------------------------
PROXY_PORT=
#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_USER=username
#------------------------------------------------------------------------------
PROXY_USER=
#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_PWD=password
#------------------------------------------------------------------------------
PROXY_PWD=
#------------------------------------------------------------------------------
# Specify the proxy realm.
#
# Example : PROXY_REALM=metalink
#------------------------------------------------------------------------------
PROXY_REALM=
#------------------------------------------------------------------------------
# Specify the Oracle Support Hub URL.
#
# Example : COLLECTOR_SUPPORTHUB_URL=
#------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=
#------------------------------------------------------------------------------
# Specify the auto-updates option. It can be one of the following:
# - MYORACLESUPPORT_DOWNLOAD
# - OFFLINE_UPDATES
# - SKIP_UPDATES
#------------------------------------------------------------------------------
oracle.installer.autoupdates.option=SKIP_UPDATES
#------------------------------------------------------------------------------
# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where
# the updates are to be downloaded.
# In case OFFLINE_UPDATES option is chosen, specify the location where the updates
# are present.
#------------------------------------------------------------------------------
oracle.installer.autoupdates.downloadUpdatesLoc=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username which has the patches download privileges
# to be used for software updates.
# Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password which has the patches download privileges
# to be used for software updates.
#
# Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password
#-------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=ccbc
獲得幫助
/taryartar/12c/database/runInstaller -help
啟動靜默安裝
/taryartar/12c/database/runInstaller -silent -noconfig -responseFile /taryartar/12c/db_install.rsp
-silent 表示靜默安裝
-noconfig 表示只安裝軟體
-responseFile 指定響應檔案
監控安裝的過程
[root@rac1 db_base]# tail -f /taryartar/12c/oraInventory/logs/installActions2013-08-03_11-52-40PM.log
INFO: Installation in progress
INFO: Extracting files to '/taryartar/12c/db_base/db_home'.
INFO: Extracting files to '/taryartar/12c/db_base/db_home'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_dirs.lst'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_filemap.jar'.
INFO: Performing fastcopy operations based on the information in the file 'racfiles.jar'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_exp_1.xml'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_1.xml'.
INFO: Performing fastcopy operations based on the information in the file 'setperms1.sh'.
安裝過程如下：
.......
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 10709 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2303 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-08-03_11-52-40PM. Please wait ...[oracle@rac1 response]$ You can find the log of this install session at:
/taryartar/12c/oraInventory/logs/installActions2013-08-03_11-52-40PM.log
The installation of Oracle Database 12c was successful.
Please check '/taryartar/12c/oraInventory/logs/silentInstall2013-08-03_11-52-40PM.log' for more details.
As a root user, execute the following script(s):
1. /taryartar/12c/oraInventory/orainstRoot.sh
2. /taryartar/12c/db_base/db_home/root.sh
Successfully Setup Software.
As install user, execute the following script. to complete the configuration.
1. /taryartar/12c/db_base/db_home/cfgtoollogs/configToolAllCommands RESPONSE_FILE=
Note:
1. This script. must be run on the same host from where installer was run.
2. This script. needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
以root執行指令碼
[root@rac1 ~]# /taryartar/12c/oraInventory/orainstRoot.sh
Changing permissions of /taryartar/12c/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /taryartar/12c/oraInventory to oinstall.
The execution of the script. is complete.
[root@rac1 ~]# /taryartar/12c/db_base/db_home/root.sh
Check /taryartar/12c/db_base/db_home/install/root_rac1_2013-08-04_00-27-25.log for the output of root script
[root@rac1 ~]#
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------配置監聽器------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
編輯監聽器配置響應檔案netca.rsp，編輯後的內容如下：
######################################################################
## Copyright(c) 1998, 2012 Oracle Corporation. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize your ##
## installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## identifies the variable type. ##
## ##
## Please specify the values in the following format: ##
## ##
## Type Example ##
## String "Sample Value" ##
## Boolean True or False ##
## Number 1000 ##
## StringList {"String value 1","String Value 2"} ##
## ##
######################################################################
## ##
## This sample response file causes the Oracle Net Configuration ##
## Assistant (NetCA) to complete an Oracle Net configuration during ##
## a custom install of the Oracle12c server which is similar to ##
## what would be created by the NetCA during typical Oracle12c ##
## install. It also documents all of the NetCA response file ##
## variables so you can create your own response file to configure ##
## Oracle Net during an install the way you wish. ##
## ##
######################################################################
[GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#SHOW_GUI=false
#-------------------------------------------------------------------------------
# Name : LOG_FILE
# Datatype : String
# Description: If present, NetCA will log output to this file in addition to the
# standard out.
# Pre-req : N/A
# Default : NONE
# Note:
# This is a substitute of "/log" in the NetCA command line.
# The command line argument has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#LOG_FILE=""/oracle12cHome/network/tools/log/netca.log""
[oracle.net.ca]
#INSTALLED_COMPONENTS;StringList;list of installed components
# The possible values for installed components are:
# "net8","server","client","aso", "cman", "javavm"
INSTALLED_COMPONENTS={"server","net8","javavm"}
#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom"
INSTALL_TYPE=""typical""
#LISTENER_NUMBER;Number;Number of Listeners
# A typical install sets one listener
LISTENER_NUMBER=1
#LISTENER_NAMES;StringList;list of listener names
# The values for listener are:
# "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...
# A typical install sets only "LISTENER"
LISTENER_NAMES={"LISTENER"}
#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)
# The possible values for listener protocols are:
# "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
# A typical install sets only "TCP;1521"
LISTENER_PROTOCOLS={"TCP;1521"}
#LISTENER_START;String;name of the listener to start, in double quotes
LISTENER_START=""LISTENER""
#NAMING_METHODS;StringList;list of naming methods
# The possible values for naming methods are:
# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE
# A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"
# or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes
# A typical install does not use this variable.
#NOVELL_NAMECONTEXT = ""NAMCONTEXT""
#SUN_METAMAP;String; SUN meta. map, in double quotes
# A typical install does not use this variable.
#SUN_METAMAP = ""MAP""
#DCE_CELLNAME;String;DCE cell name, in double quotes
# A typical install does not use this variable.
#DCE_CELLNAME = ""CELL""
#NSN_NUMBER;Number;Number of NetService Names
# A typical install sets one net service name
NSN_NUMBER=1
#NSN_NAMES;StringList;list of Net Service names
# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
#NSN_SERVICE;StringList;Oracle12c database's service name
# A typical install sets Oracle12c database's service name to "PLSExtProc"
NSN_SERVICE={"PLSExtProc"}
#NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters
# The possible values for net service name protocol parameters are:
# "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY"
# A typical install sets parameters to "IPC;EXTPROC"
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
#SERVICEUSERPASSWORD;String;Windows service user password
# If the oracle home is installed as secure user, supply the password
#SERVICEUSERPASSWORD=""svcpassword""
配置監聽器
[oracle@rac1 12c]$ /taryartar/12c/db_base/db_home/bin/netca -silent -responsefile /taryartar/12c/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /taryartar/12c/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Listener "LISTENER" already exists.
Oracle Net Services configuration successful. The exit code is 0
啟動監聽器
[oracle@rac1 12c]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 04-AUG-2013 00:39:08
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /taryartar/12c/db_base/db_home/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /taryartar/12c/db_base/db_home/network/admin/listener.ora
Log messages written to /taryartar/12c/db_base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 04-AUG-2013 00:39:08
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /taryartar/12c/db_base/db_home/network/admin/listener.ora
Listener Log File /taryartar/12c/db_base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))
The listener supports no services
The command completed successfully
--------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------建立資料庫------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
編輯響應檔案dbca.rsp，編輯後的內容如下:
##############################################################################
## ##
## DBCA response file ##
## ------------------ ##
## Copyright 1998, 2012, Oracle Corporation. All Rights Reserved. ##
## ##
## Specify values for the variables listed below to customize Oracle ##
## Database Configuration installation. ##
## ##
## Each variable is associated with a comment. The comment identifies the ##
## variable type. ##
## ##
## Please specify the values in the following format : ##
## Type : Example ##
## String : "" ##
## Boolean : True or False ##
## Number : ##
## StringList : {"",""} ##
## ##
## Examples : ##
## 1. dbca -progress_only -responseFile ##
## Display a progress bar depicting progress of database creation ##
## process. ##
## ##
## 2. dbca -silent -responseFile ##
## Creates database silently. No user interface is displayed. ##
## ##
## 3. dbca -silent -createDatabase -cloneTemplate ##
## -responseFile ##
## Creates database silently with clone template. The template in ##
## responsefile is a clone template. ##
## ##
## 4. dbca -silent -deleteDatabase -responseFile ##
## Deletes database silently. ##
##############################################################################
#-----------------------------------------------------------------------------
# GENERAL section is required for all types of database creations.
#-----------------------------------------------------------------------------
[GENERAL]
#-----------------------------------------------------------------------------
# Name : RESPONSEFILE_VERSION
# Datatype : String
# Description : Version of the database to create
# Valid values : "12.1.0"
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
RESPONSEFILE_VERSION = "12.1.0"
#-----------------------------------------------------------------------------
# Name : OPERATION_TYPE
# Datatype : String
# Description : Type of operation
# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase"
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
OPERATION_TYPE = "createDatabase"
#-----------------------*** End of GENERAL section ***------------------------
#-----------------------------------------------------------------------------
# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".
#-----------------------------------------------------------------------------
[CREATEDATABASE]
#-----------------------------------------------------------------------------
# Name : GDBNAME
# Datatype : String
# Description : Global database name of the database
# Valid values : . - when database domain isn't NULL
# - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
GDBNAME = "tar.taryartar.com"
#-----------------------------------------------------------------------------
# Name : RACONENODE
# Datatype : Boolean
# Description : Set to true for RAC One Node database
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#RACONENODE = "false"
#-----------------------------------------------------------------------------
# Name : RACONENODESERVICENAME
# Datatype : String
# Description : Service is required by application to connect to RAC One
# Node Database
# Valid values : Service Name
# Default value : None
# Mandatory : No [required in case RACONENODE flag is set to true]
#-----------------------------------------------------------------------------
#RACONENODESERVICENAME =
#-----------------------------------------------------------------------------
# Name : POLICYMANAGED
# Datatype : Boolean
# Description : Set to true if Database is policy managed and
# set to false if Database is admin managed
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#POLICYMANAGED = "false"
#-----------------------------------------------------------------------------
# Name : CREATESERVERPOOL
# Datatype : Boolean
# Description : Set to true if new server pool need to be created for database
# if this option is specified then the newly created database
# will use this newly created serverpool.
# Multiple serverpoolname can not be specified for database
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#CREATESERVERPOOL = "false"
#-----------------------------------------------------------------------------
# Name : SERVERPOOLNAME
# Datatype : String
# Description : Only one serverpool name need to be specified
# if Create Server Pool option is specified.
# Comma-separated list of Serverpool names if db need to use
# multiple Server pool
# Valid values : ServerPool name
# Default value : None
# Mandatory : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
#SERVERPOOLNAME =
#-----------------------------------------------------------------------------
# Name : CARDINALITY
# Datatype : Number
# Description : Specify Cardinality for create server pool operation
# Valid values : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
#CARDINALITY =
#-----------------------------------------------------------------------------
# Name : FORCE
# Datatype : Boolean
# Description : Set to true if new server pool need to be created by force
# if this option is specified then the newly created serverpool
# will be assigned server even if no free servers are available.
# This may affect already running database.
# This flag can be specified for Admin managed as well as policy managed db.
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#FORCE = "false"
#-----------------------------------------------------------------------------
# Name : PQPOOLNAME
# Datatype : String
# Description : Only one serverpool name needs to be specified
# if create server pool option is specified.
# Comma-separated list of serverpool names if use
# server pool. This is required to
# create Parallel Query (PQ) database. Applicable to Big Cluster
# Valid values : Parallel Query (PQ) pool name
# Default value : None
# Mandatory : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
#PQPOOLNAME =
#-----------------------------------------------------------------------------
# Name : PQCARDINALITY
# Datatype : Number
# Description : Specify Cardinality for create server pool operation.
# Applicable to Big Cluster
# Valid values : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
#PQCARDINALITY =
#-----------------------------------------------------------------------------
# Name : SID
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle12c Administrator's Guide
# Default value : specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
SID = "taryartar1"
#-----------------------------------------------------------------------------
# Name : CREATEASCONTAINERDATABASE
# Datatype : boolean
# Description : flag to create database as container database
# Valid values : Check Oracle12c Administrator's Guide
# Default value : false
# Mandatory : No
#-----------------------------------------------------------------------------
#CREATEASCONTAINERDATABASE =
#-----------------------------------------------------------------------------
# Name : NUMBEROFPDBS
# Datatype : Number
# Description : Specify the number of pdb to be created
# Valid values : 0 to 252
# Default value : 0
# Mandatory : No
#-----------------------------------------------------------------------------
#NUMBEROFPDBS =
#-----------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#PDBNAME =
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Comma-separated list of cluster nodes
# Valid values : Cluster node names
# Default value : None
# Mandatory : No (Yes for RAC database-centric database )
#-----------------------------------------------------------------------------
#NODELIST=
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name of the template
# Valid values : Template file name
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "General_Purpose.dbc"
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSPASSWORD
# Datatype : String
# Description : Password for SYS user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSPASSWORD = "Xzzp2008"
#-----------------------------------------------------------------------------
# Name : SYSTEMPASSWORD
# Datatype : String
# Description : Password for SYSTEM user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSTEMPASSWORD = "Xzzp2008"
#-----------------------------------------------------------------------------
# Name : SERVICEUSERPASSWORD
# Datatype : String
# Description : Password for Windows Service user
# Default value : None
# Mandatory : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
#SERVICEUSERPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : EMCONFIGURATION
# Datatype : String
# Description : Enterprise Manager Configuration Type
# Valid values : CENTRAL|LOCAL|ALL|NONE
# Default value : NONE
# Mandatory : No
#-----------------------------------------------------------------------------
#EMCONFIGURATION = "NONE"
#-----------------------------------------------------------------------------
# Name : SYSMANPASSWORD
# Datatype : String
# Description : Password for SYSMAN user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#SYSMANPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : DBSNMPPASSWORD
# Datatype : String
# Description : Password for DBSNMP user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if EMCONFIGURATION is specified
#-----------------------------------------------------------------------------
#DBSNMPPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : CENTRALAGENT
# Datatype : String
# Description : Grid Control Central Agent Oracle Home
# Default value : None
# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#CENTRALAGENT =
#-----------------------------------------------------------------------------
# Name : HOSTUSERNAME
# Datatype : String
# Description : Host user name for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERNAME =
#-----------------------------------------------------------------------------
# Name : HOSTUSERPASSWORD
# Datatype : String
# Description : Host user password for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERPASSWORD=
#-----------------------------------------------------------------------------
# Name : BACKUPSCHEDULE
# Datatype : String
# Description : Daily backup schedule in the form. of hh:mm
# Default value : 2:00
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#BACKUPSCHEDULE=
#-----------------------------------------------------------------------------
# Name : DVCONFIGURATION
# Datatype : Boolean
# Description : Specify "True" to configure and enable Oracle Database vault
# Valid values : True/False
# Default value : False
# Mandatory : No
#-----------------------------------------------------------------------------
#DVCONFIGURATION = "false"
#-----------------------------------------------------------------------------
# Name : DVOWNERNAME
# Datatype : String
# Description : DataVault Owner
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
#DVOWNERNAME = ""
#-----------------------------------------------------------------------------
# Name : DVOWNERPASSWORD
# Datatype : String
# Description : Password for DataVault Owner
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
#DVOWNERPASSWORD = ""
#-----------------------------------------------------------------------------
# Name : DVACCOUNTMANAGERNAME
# Datatype : String
# Description : DataVault Account Manager
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DVACCOUNTMANAGERNAME = ""
#-----------------------------------------------------------------------------
# Name : DVACCOUNTMANAGERPASSWORD
# Datatype : String
# Description : Password for DataVault Account Manager
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DVACCOUNTMANAGERPASSWORD = ""
#-----------------------------------------------------------------------------
# Name : OLSCONFIGURATION
# Datatype : Boolean
# Description : Specify "True" to configure and enable Oracle Label Security
# Valid values : True/False
# Default value : False
# Mandatory : No
#-----------------------------------------------------------------------------
#OLSCONFIGURATION = "false"
#-----------------------------------------------------------------------------
# Name : DATAFILEJARLOCATION
# Datatype : String
# Description : Location of the data file jar
# Valid values : Directory containing compressed datafile jar
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DATAFILEJARLOCATION =
#-----------------------------------------------------------------------------
# Name : DATAFILEDESTINATION
# Datatype : String
# Description : Location of the data file's
# Valid values : Directory for all the database files
# Default value : $ORACLE_BASE/oradata
# Mandatory : No
#-----------------------------------------------------------------------------
#DATAFILEDESTINATION =
#-----------------------------------------------------------------------------
# Name : RECOVERYAREADESTINATION
# Datatype : String
# Description : Location of the data file's
# Valid values : Recovery Area location
# Default value : $ORACLE_BASE/flash_recovery_area
# Mandatory : No
#-----------------------------------------------------------------------------
#RECOVERYAREADESTINATION=
#-----------------------------------------------------------------------------
# Name : STORAGETYPE
# Datatype : String
# Description : Specifies the storage on which the database is to be created
# Valid values : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory : No
#-----------------------------------------------------------------------------
#STORAGETYPE=FS
#-----------------------------------------------------------------------------
# Name : DISKGROUPNAME
# Datatype : String
# Description : Specifies the disk group name for the storage
# Default value : DATA
# Mandatory : No
#-----------------------------------------------------------------------------
#DISKGROUPNAME=DATA
#-----------------------------------------------------------------------------
# Name : ASMSNMP_PASSWORD
# Datatype : String
# Description : Password for ASM Monitoring
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#ASMSNMP_PASSWORD=""
#-----------------------------------------------------------------------------
# Name : RECOVERYGROUPNAME
# Datatype : String
# Description : Specifies the disk group name for the recovery area
# Default value : RECOVERY
# Mandatory : No
#-----------------------------------------------------------------------------
#RECOVERYGROUPNAME=RECOVERY
#-----------------------------------------------------------------------------
# Name : CHARACTERSET
# Datatype : String
# Description : Character set of the database
# Valid values : Check Oracle12c National Language Support Guide
# Default value : "US7ASCII"
# Mandatory : NO
#-----------------------------------------------------------------------------
#CHARACTERSET = "US7ASCII"
#-----------------------------------------------------------------------------
# Name : NATIONALCHARACTERSET
# Datatype : String
# Description : National Character set of the database
# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory : No
#-----------------------------------------------------------------------------
#NATIONALCHARACTERSET= "UTF8"
#-----------------------------------------------------------------------------
# Name : REGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to register with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : DIRSERVICEUSERNAME
# Datatype : String
# Description : Specifies the name of the directory service user
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#DIRSERVICEUSERNAME= "name"
#-----------------------------------------------------------------------------
# Name : DIRSERVICEPASSWORD
# Datatype : String
# Description : The password of the directory service user.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#DIRSERVICEPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : WALLETPASSWORD
# Datatype : String
# Description : The password for wallet to created or modified.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#WALLETPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : LISTENERS
# Datatype : String
# Description : Specifies list of listeners to register the database with.
# By default the database is configured for all the listeners specified in the
# $ORACLE_HOME/network/admin/listener.ora
# Valid values : The list should be space separated names like "listener1 listener2".
# Mandatory : NO
#-----------------------------------------------------------------------------
#LISTENERS = "listener1 listener2"
#-----------------------------------------------------------------------------
# Name : VARIABLESFILE
# Datatype : String
# Description : Location of the file containing variable value pair
# Valid values : A valid file-system file. The variable value pair format in this file
# is =. Each pair should be in a new line.
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#VARIABLESFILE =
#-----------------------------------------------------------------------------
# Name : VARIABLES
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#VARIABLES =
#-----------------------------------------------------------------------------
# Name : INITPARAMS
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#INITPARAMS =
#-----------------------------------------------------------------------------
# Name : SAMPLESCHEMA
# Datatype : Boolean
# Description : Specifies whether or not to add the Sample Schemas to your database
# Valid values : TRUE \ FALSE
# Default value : FASLE
# Mandatory : No
#-----------------------------------------------------------------------------
#SAMPLESCHEMA=TRUE
#-----------------------------------------------------------------------------
# Name : MEMORYPERCENTAGE
# Datatype : String
# Description : percentage of physical memory for Oracle
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#MEMORYPERCENTAGE = "40"
#-----------------------------------------------------------------------------
# Name : DATABASETYPE
# Datatype : String
# Description : used for memory distribution when MEMORYPERCENTAGE specified
# Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
# Default value : MULTIPURPOSE
# Mandatory : NO
#-----------------------------------------------------------------------------
#DATABASETYPE = "MULTIPURPOSE"
#-----------------------------------------------------------------------------
# Name : AUTOMATICMEMORYMANAGEMENT
# Datatype : Boolean
# Description : flag to indicate Automatic Memory Management is used
# Valid values : TRUE/FALSE
# Default value : TRUE
# Mandatory : NO
#-----------------------------------------------------------------------------
#AUTOMATICMEMORYMANAGEMENT = "TRUE"
#-----------------------------------------------------------------------------
# Name : TOTALMEMORY
# Datatype : String
# Description : total memory in MB to allocate to Oracle
# Valid values :
# Default value :
# Mandatory : NO
#-----------------------------------------------------------------------------
#TOTALMEMORY = "800"
#-----------------------*** End of CREATEDATABASE section ***------------------------
#-----------------------------------------------------------------------------
# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".
#-----------------------------------------------------------------------------
[createTemplateFromDB]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database from which to create the template
# Valid values : The format is ::
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "myhost:1521:orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "system"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name for the new template.
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
#-----------------------------------------------------------------------------
# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".
#-----------------------------------------------------------------------------
[createCloneTemplate]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID from which to create the template.
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name for the new template.
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "My Clone TEMPLATE"
#-----------------------------------------------------------------------------
# Name : DATAFILEJARLOCATION
# Datatype : String
# Description : Location of the data file jar
# Valid values : Directory where the new compressed datafile jar will be placed
# Default value : $ORACLE_HOME/assistants/dbca/templates
# Mandatory : NO
#-----------------------------------------------------------------------------
#DATAFILEJARLOCATION =
#-----------------------*** End of createCloneTemplate section ***------------------------
#-----------------------------------------------------------------------------
# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".
#-----------------------------------------------------------------------------
[DELETEDATABASE]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------*** End of deleteDatabase section ***------------------------
#-----------------------------------------------------------------------------
# GENERATESCRIPTS section
#-----------------------------------------------------------------------------
[generateScripts]
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name of the template
# Valid values : Template name as seen in DBCA
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "New Database"
#-----------------------------------------------------------------------------
# Name : GDBNAME
# Datatype : String
# Description : Global database name of the database
# Valid values : . - when database domain isn't NULL
# - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
GDBNAME = "orcl12.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : SCRIPTDESTINATION
# Datatype : String
# Description : Location of the scripts
# Valid values : Directory for all the scripts
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#SCRIPTDESTINATION =
#-----------------------*** End of deleteDatabase section ***------------------------
#-----------------------------------------------------------------------------
# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".
#-----------------------------------------------------------------------------
[CONFIGUREDATABASE]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD =
#-----------------------------------------------------------------------------
# Name : REGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to register with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : UNREGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to unregister with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#UNREGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : REGENERATEDBPASSWORD
# Datatype : Boolean
# Description : Specifies whether regenerate database password in OID/Wallet
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGENERATEDBPASSWORD= TRUE
#-----------------------------------------------------------------------------
# Name : DIRSERVICEUSERNAME
# Datatype : String
# Description : Specifies the name of the directory service user
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#DIRSERVICEUSERNAME= "name"
#-----------------------------------------------------------------------------
# Name : DIRSERVICEPASSWORD
# Datatype : String
# Description : The password of the directory service user.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#DIRSERVICEPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : WALLETPASSWORD
# Datatype : String
# Description : The password for wallet to created or modified.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#WALLETPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : ENABLESECURITYCONFIGURATION
# Datatype : String
# Description : Database Security Settings
# Valid values : true|false
# Default value : true
# Mandatory : No
#-----------------------------------------------------------------------------
#ENABLESECURITYCONFIGURATION = "true"
#-----------------------------------------------------------------------------
# Name : EMCONFIGURATION
# Datatype : String
# Description : Enterprise Manager Configuration Type
# Valid values : CENTRAL|LOCAL|ALL|NONE
# Default value : NONE
# Mandatory : No
#-----------------------------------------------------------------------------
#EMCONFIGURATION = "NONE"
#-----------------------------------------------------------------------------
# Name : SYSMANPASSWORD
# Datatype : String
# Description : Password for SYSMAN user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#SYSMANPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : DBSNMPPASSWORD
# Datatype : String
# Description : Password for DBSNMP user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if EMCONFIGURATION is specified
#-----------------------------------------------------------------------------
#DBSNMPPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : CENTRALAGENT
# Datatype : String
# Description : Grid Control Central Agent Oracle Home
# Default value : None
# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#CENTRALAGENT =
#-----------------------------------------------------------------------------
# Name : HOSTUSERNAME
# Datatype : String
# Description : Host user name for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERNAME =
#-----------------------------------------------------------------------------
# Name : HOSTUSERPASSWORD
# Datatype : String
# Description : Host user password for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERPASSWORD=
#-----------------------------------------------------------------------------
# Name : BACKUPSCHEDULE
# Datatype : String
# Description : Daily backup schedule in the form. of hh:mm
# Default value : 2:00
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#BACKUPSCHEDULE=
#-----------------------*** End of CONFIGUREDATABASE section ***------------------------
#-----------------------------------------------------------------------------
# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".
#-----------------------------------------------------------------------------
[ADDINSTANCE]
#-----------------------------------------------------------------------------
# Name : DB_UNIQUE_NAME
# Datatype : String
# Description : DB Unique Name of the RAC database
# Valid values :
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : INSTANCENAME
# Datatype : String
# Description : RAC instance name to be added
# Valid values : Check Oracle12c Administrator's Guide
# Default value : +
# Mandatory : No
#-----------------------------------------------------------------------------
#INSTANCENAME = "orcl1"
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Node on which to add new instance
# (in 10gR2, instance addition is supported on 1 node at a time)
# Valid values : Cluster node name
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
NODELIST=
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : SERVICEUSERPASSWORD
# Datatype : String
# Description : Password for Windows Service user
# Default value : None
# Mandatory : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
#SERVICEUSERPASSWORD = "password"
#-----------------------*** End of ADDINSTANCE section ***------------------------
#-----------------------------------------------------------------------------
# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".
#-----------------------------------------------------------------------------
[DELETEINSTANCE]
#-----------------------------------------------------------------------------
# Name : DB_UNIQUE_NAME
# Datatype : String
# Description : DB Unique Name of the RAC database
# Valid values :
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : INSTANCENAME
# Datatype : String
# Description : RAC instance name to be deleted
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
INSTANCENAME = "orcl12c"
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Node on which instance to be deleted (SID) is located
# Valid values : Cluster node name
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#NODELIST=
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------*** End of DELETEINSTANCE section ***------------------------
#----------------------------------------------------------------------------------
# CREATEPLUGGABLEDATABASE section is used when PLUGPDB_TYPE is defined as "createPluggableDatabase".
#----------------------------------------------------------------------------------
[CREATEPLUGGABLEDATABASE]
#----------------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#----------------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : The name of new pluggable database
# This pdb name must not be same as sourcedb name.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
PDBNAME = "PDB1"
#----------------------------------------------------------------------------------
# Name : CREATEASCLONE
# Datatype : Boolean
# Description : specify true or false for PDB to be create as Clone.
# : When "true" is passed a new PDB GUID is generated for the plugged in PDB
# Default value : true
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEASCLONE = "TRUE"
#----------------------------------------------------------------------------------
#----------------------------------------------------------------------------------
# Name : CREATEPDBFROM
# Datatype : String
# Description : specify the source of pdb to be plugged
# Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML
# Default value : DEFAULT
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEPDBFROM = "DEFAULT"
#----------------------------------------------------------------------------------
# Name : PDBARCHIVEFILE
# Datatype : String
# Description : Full path and name for pdbArchive file
# Default value : None
# Mandatory : Mandatory when creating new PDB using FILEARCHIVE
#-----------------------------------------------------------------------------
# PDBARCHIVEFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBBACKUPFILE
# Datatype : String
# Description : Full path and name for pdb back up file
# Default value : None
# Mandatory : Mandatory when creating new PDB using RMANBACKUP
#-----------------------------------------------------------------------------
# PDBBACKUPFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBMETADATAFILE
# Datatype : String
# Description : Full path and name for pdb metadata file
# Default value : None
# Mandatory : Mandatory when creating new PDB using RMANBACKUP or USINGXML
#-----------------------------------------------------------------------------
# PDBMETADATAFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBADMINUSERNAME
# Datatype : String
# Description : PDB Administrator user name
# Default value : None
# Mandatory : Mandatory only when creating new DEFAULT PDB
#-----------------------------------------------------------------------------
# PDBADMINUSERNAME = ""
#----------------------------------------------------------------------------------
# Name : PDBADMINPASSWORD
# Datatype : String
# Description : PDB Administrator user password
# Default value : None
# Mandatory : Mandatory only when creating new DEFAULT PDB
#-----------------------------------------------------------------------------
# PDBADMINPASSWORD = ""
#----------------------------------------------------------------------------------
# Name : CREATENEWPDBADMINUSER
# Datatype : String
# Description : When Plugging a pdb from FILEARCHIVE or RMANBACKUP
# a new PDB Administrator user can be created using this option
# This option should be given along with pdbadmin username and password
# Default value : False
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATENEWPDBADMINUSER = ""
#----------------------------------------------------------------------------------
# Name : SOURCEFILENAMECONVERT
# Datatype : String
# Description : This clause specifies how to locate files listed in an XML file
# describing a Pluggable Database if they reside in a location different
# from that specified in the XML file.
# This clause is valid when creating Pluggable database in USINGXML option
# Valid values : (, ,....)
# Default value : "NONE"
# Mandatory : NO
#-----------------------------------------------------------------------------
# SOURCEFILENAMECONVERT = ""
#----------------------------------------------------------------------------------
# Name : FILENAMECONVERT
# Datatype : String
# Description : This clause specifies how to generate names of files
# for the Pluggable Database being created using names of existing files
# This clause is valid when creating Pluggable database in USINGXML option
# Valid values : (, ,....)
# Default value : "NONE"
# Mandatory : NO
#-----------------------------------------------------------------------------
# FILENAMECONVERT = ""
#----------------------------------------------------------------------------------
# Name : COPYPDBFILES
# Datatype : Boolean
# Description : If COPY is specified, it will indicate that datafiles need to be copied.
# : This option can be true only when FILENAMECONVERT is specified or
# CDB files are Oracle Managed Files(OMF)
# Valid values : TRUE \ FALSE
# Default value : False
# Mandatory : NO
#-----------------------------------------------------------------------------
# COPYPDBFILES = ""
#----------------------------------------------------------------------------------
# Name : PDBDATAFILEDESTINATION
# Datatype : String
# Description : common location for PDB datafile area
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
# PDBDATAFILEDESTINATION = ""
#----------------------------------------------------------------------------------
# Name : USEMETADATAFILELOCATION
# Datatype : Boolean
# Description : Specify true if datafile path defined in Meta. datafile within PDB
# archive file is to be used to un-archive datafile.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : NO
#-----------------------------------------------------------------------------
# USEMETADATAFILELOCATION = ""
#----------------------------------------------------------------------------------
# Name : CREATEUSERTABLESPACE
# Datatype : Boolean
# Description : Specify true if a default user tablespace need to be created in new PDB
#
# Valid values : TRUE \ FALSE
# Default value : TRUE
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEUSERTABLESPACE = ""
#-----------------------*** End of createPluggableDatabase section ***------------------------
#----------------------------------------------------------------------------------
# UNPLUGDATABASE section is used when PLUGPDB_TYPE is defined as "unplugDatabase".
#----------------------------------------------------------------------------------
[UNPLUGDATABASE]
#----------------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#----------------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : The name of new pluggable database
# This pdb name must not be same as sourcedb name.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
PDBNAME = "PDB1"
#----------------------------------------------------------------------------------
# Name : ARCHIVETYPE
# Datatype : String
# Description : The unplugged database datafile backup will in tar.gz or rman backup
# This pdb name must not be same as sourcedb name.
# Valid values : TAR | RMAN
# Default value : TAR
# Mandatory : NO
#-----------------------------------------------------------------------------
ARCHIVETYPE = "TAR"
#----------------------------------------------------------------------------------
# Name : PDBARCHIVEFILE
# Datatype : String
# Description : Full path and name for pdbArchive file
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
# PDBARCHIVEFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBBACKUPFILE
# Datatype : String
# Description : Full path and name for pdb back up file
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
# PDBBACKUPFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBMETADATAFILE
# Datatype : String
# Description : Full path and name for pdb metadata file
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
# PDBMETADATAFILE = ""
#-----------------------*** End of unplugDatabase section ***------------------------
建立資料庫
[oracle@rac1 db_home]$ /taryartar/12c/db_base/db_home/bin/dbca -silent -responseFile /taryartar/12c/dbca.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
37% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
57% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/taryartar/12c/db_base/cfgtoollogs/dbca/tar/tar4.log" for further details.
測試，是否能夠登陸資料庫
[oracle@rac1 12c]$ sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Sun Aug 4 02:16:35 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
資料庫建立成功！
===錯誤=======================================
特別要注意的是，等號2邊不能有空格
oracle.install.option=INSTALL_DB_SWONLY
DECLINE_SECURITY_UPDATES要設定成true
INFO: Adding ExitStatus VAR_VALIDATION_FAILURE to the exit status set
許可權問題
/taryartar/12c/ has enough space. Required space is 6460 MB , available space is 8155 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-12547: TNS:lost contact
ORA-24324: service handle not initialized
轉自：http://blog.itpub.net/13804621/viewspace-767741/
作業系統：CentOS 6.4
資料庫 ：Oracle 12C r1
安裝路徑，最好是20g以上，下載的安裝檔案放在次路徑
/taryartar/12c
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------安裝前準備------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
建立使用者和組
groupadd -g 1000 oinstall
groupadd -g 1031 dba
useradd -u 1101 -g oinstall -G dba oracle
oinstall組：是清單目錄組（Oracle Inventory group），用於管理清單目錄（Inventory）
dba組：用於資料庫管理。
建立目錄
mkdir -p /taryartar/12c/db_base/db_home
chown -R oracle:oinstall /taryartar/12c/db_base
chmod -R 775 /taryartar/12c/db_base
檢視實體記憶體，實體記憶體最好2G以上
[root@rac1 12c]# grep MemTotal /proc/meminfo
MemTotal: 2225780 kB
檢視記憶體檔案系統
[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
5.8G 3.8G 1.7G 70% /
/dev/sda1 99M 13M 81M 14% /boot
tmpfs 1.1G 0 1.1G 0% /dev/shm
/dev/sdb1 16G 173M 15G 2% /taryartar/12c
[root@mydns ~]# free -g
total used free shared buffers cached
Mem: 2 0 2 0 0 0
-/+ buffers/cache: 0 2
Swap: 2 0 2
檢視SWAP的大小
[root@rac1 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 2588664 kB
swap space：通常是實體記憶體的2倍
至少要有1G的臨時空間
[root@mydns ~]# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_nod1-lv_root
29G 13G 16G 44% /
決定系統的架構：是32位還是64位
[root@rac1 ~]# uname -m
x86_64
Red Hat Enterprise Linux 6要求的核心是2.6.32-71及以上
[root@rac1 ~]# cat /proc/version
Linux version 2.6.32-71.el6.x86_64 (mockbuild@c6b6.centos.org) (gcc version 4.4.4 20100726 (Red Hat 4.4.4-13) (GCC) ) #1 SMP Fri May 20 03:51:51 BST 2011
[root@rac1 12c]# uname -r
2.6.32-358.el6.x86_64
[root@rac1 12c]# lsb_release -a
LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 6.4 (Final)
Release: 6.4
Codename: Final
檢視並安裝如下的包
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
檢視包
rpm -q libX11
解壓安裝檔案
unzip linuxamd64_12c_database_1of2.zip
unzip linuxamd64_12c_database_2of2.zip
==禁用安全的LINUX(secure linux,SELINUX)
SELinux 的不正確配置會影響網路
Disable secure linux by editing the "/etc/selinux/config" file
enforcing - SELinux security policy is enforced.代表記錄警告且阻止可疑行為
permissive - SELinux prints warnings instead of 代表僅記錄安全警告但不阻止可疑行為
disabled - SELinux is fully disabled.SELinux 被禁用
SELINUXTYPE設定
targeted 代表僅針對預製的幾種網路服務和訪問請求使用 SELinux 保護，
strict 代表所有網路服務和訪問請求都要經過 SELinux。
設定
SELINUX=disabled
檢視系統當前的安全策略
[grid@rac1 ~]$ sestatus
SELinux status: disabled
[grid@rac1 ~]$ getenforce
Disabled
改變SELinux執行狀態
Enforcing=1
Permissive=0
[grid@rac1 ~]$setenforce [ Enforcing | Permissive | 1 | 0 ]
==設定環境變數
1.顯示使用哪個SHELL
[oracle@rac1 ~]$ echo $SHELL
/bin/bash
2.修改啟動檔案，或者配置檔案
Bash shell (bash):
$ vi .bash_profile
Bourne shell (sh) or Korn shell (ksh):
$ vi .profile
C shell (csh or tcsh):
% vi .login
為使用者“oracle”設定環境變數
sudo su - oracle
vi .bash_profile
加入如下內容
export ORACLE_BASE=/taryartar/12c/db_base
export ORACLE_HOME=$ORACLE_BASE/db_home
export ORACLE_SID=taryartar1
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
export ORACLE_HOSTNAME=rac1.taryartar.com
export DB_UNIQUE_NAME=tar
export CVUQDISK_GRP=oinstall
umask 022
cd $ORACLE_HOME
====核心引數設定
核心修改，所有的核心引數放在下面的檔案中
/etc/sysctl.conf
shmmax=實體記憶體*80%*80% 單位是位元組
kernel.shmmax：表示單個共享記憶體段的最大值，以位元組為單位，此值一般為實體記憶體的一半，不過大一點也沒關係，這裡設定的為4GB，即“4294967295/1024/1024/1024=4G”。
kernel.shmmin：表示單個共享記憶體段的最小值，預設為1byte
kernel.shmall：表示整個系統範圍內可用共享記憶體頁的總量，單位是頁（page），在32位系統上一頁等於4kB，也就是4096位元組。計算公式是：shmmax/PAGE_SIZE
kernel.shmmni：表示整個系統範圍內記憶體段的最大數量，一般為4096.（）
ip_local_port_range ：表示埠的範圍，。在監聽器幫助客戶端程式和伺服器程式建立連線時，會用到指定範圍內的埠。
kernel.sem ：表示設定的訊號量，這4個引數內容大小固定。
net.core.rmem_default ：表示接收套接字緩衝區大小的預設值（以位元組為單位）。
net.core.rmem_max ：表示接收套接字緩衝區大小的最大值（以位元組為單位）
net.core.wmem_default ：表示傳送套接字緩衝區大小的預設值（以位元組為單位）。
net.core.wmem_max ：表示傳送套接字緩衝區大小的最大值（以位元組為單位）。
編輯檔案/etc/sysctl.conf，加入類似於下面的內容
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1349242060
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
讓核心引數設定馬上生效
[root@rac1 ~]# cat /etc/sysctl.conf
檢視核心引數的當前值
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
/sbin/sysctl -a | grep aio-max-nr
==修改資源控制檔案
資源限制是針對單個程式的限制，不是針對整個系統總的設定
修改limits.conf以後，將馬上生效。但是，如果使用者已經登入系統，那麼對於該使用者的限制將在下一次使用者重新登入以後才生效。如果要讓對該使用者的限制生效，只能讓該使用者登出然後重新登入就可以了。
/etc/security/limits.conf
core - 限制核心檔案的大小
date - 最大資料大小
fsize - 最大檔案大小
memlock - 最大鎖定記憶體地址空間
nofile - 開啟檔案的最大數目
rss - 最大持久設定大小
stack - 最大棧大小
cpu - 以分鐘為單位的最多 CPU 時間
noproc - 程式的最大數目
as - 地址空間限制
maxlogins - 此使用者允許登入的最大數目
檢視當前的資源限制（當前使用者的）
ulimit -a
limits.conf檔案的格式
domain：可以是一個使用者名稱或者一個組(用@來區分)，或者使用萬用字元*。
type：有 soft，hard 和 -，soft 指的是當前系統生效的設定值，也就是使用者一登入就要開啟那麼多的檔案控制程式碼，hard 表明系統中所能設定的最大值。soft 的限制不能比hard 限制高。用 – 就表明同時設定了 soft 和 hard 的值。
item：可以是下列選項的任何一個：
編輯檔案/etc/security/limits.conf
為使用者oracle設定資源限制，加入如下內容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
nofile - 開啟檔案的最大數目，該值不能等於/proc/sys/fs/file-max，如果等於file-max且開啟的檔案控制程式碼的數量達到file-max，使用者將不能登陸作業系統。
注意：有些時候，設定並不能生效，如直接透過SSH以oracle登入，則設定不生效；如果以root登入再sudo 到ORACLE,則不行。
解決方法：
1）
編輯檔案/etc/ssh/sshd_config
設定UsePrivilegeSeparation等於no
2）
重啟sshd
這種做法會影響到PAM，所以需要和管理員進行協調。
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------安裝Oracle軟體------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
響應檔案模板的存放位置
$ORACLE_HOME/assistants/
$stage_area/database/response
有下面幾種型別響應檔案（模板）
db_install.rsp Silent installation of Oracle Database 12c
grid_install.rsp Silent installation of Oracle Grid Infrastructure
dbca.rsp Silent installation of Database Configuration Assistant
netca.rsp Silent installation of Oracle Net Configuration Assistant
複製模板（所有的）到/taryartar/12c/
[oracle@rac1 response]$ cp *.rsp /taryartar/12c/
改變模板的屬性
chmod 700 *.rsp
編輯響應檔案db_install.rsp，編輯後的內容如下：
####################################################################
## Copyright(c) Oracle Corporation 1998,2013. All rights reserved.##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file contains plain text passwords and ##
## should be secured to have read permission only by oracle user ##
## or db administrator who owns this installation. ##
## ##
####################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
# - INSTALL_DB_SWONLY
# - INSTALL_DB_AND_CONFIG
# - UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=rac1
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/taryartar/12c/oraInventory
#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.
#
# en : English ja : Japanese
# fr : French ko : Korean
# ar : Arabic es : Latin American Spanish
# bn : Bengali lv : Latvian
# pt_BR: Brazilian Portuguese lt : Lithuanian
# bg : Bulgarian ms : Malay
# fr_CA: Canadian French es_MX: Mexican Spanish
# ca : Catalan no : Norwegian
# hr : Croatian pl : Polish
# cs : Czech pt : Portuguese
# da : Danish ro : Romanian
# nl : Dutch ru : Russian
# ar_EG: Egyptian zh_CN: Simplified Chinese
# en_GB: English (Great Britain) sk : Slovak
# et : Estonian sl : Slovenian
# fi : Finnish es_ES: Spanish
# de : German sv : Swedish
# el : Greek th : Thai
# iw : Hebrew zh_TW: Traditional Chinese
# hu : Hungarian tr : Turkish
# is : Icelandic uk : Ukrainian
# in : Indonesian vi : Vietnamese
# it : Italian
#
# all_langs : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs
#-------------------------------------------------------------------------------
SELECTED_LANGUAGES=en
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#-------------------------------------------------------------------------------
ORACLE_HOME=/taryartar/12c/db_base/db_home
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/taryartar/12c/db_base
#-------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# - EE : Enterprise Edition
# - SE : Standard Edition
# - SEONE : Standard Edition One
# - PE : Personal Edition (WINDOWS ONLY)
#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
###############################################################################
# #
# PRIVILEGED OPERATING SYSTEM GROUPS #
# ------------------------------------------ #
# Provide values for the OS groups to which OSDBA and OSOPER privileges #
# needs to be granted. If the install is being performed as a member of the #
# group "dba", then that will be used unless specified otherwise below. #
# #
# The value to be specified for OSDBA and OSOPER group is only for UNIX based #
# Operating System. #
# #
###############################################################################
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#-------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=dba
#------------------------------------------------------------------------------
# The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.BACKUPDBA_GROUP=dba
#------------------------------------------------------------------------------
# The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DGDBA_GROUP=dba
#------------------------------------------------------------------------------
# The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.KMDBA_GROUP=dba
###############################################################################
# #
# Grid Options #
# #
###############################################################################
#------------------------------------------------------------------------------
# Specify the type of Real Application Cluster Database
#
# - ADMIN_MANAGED: Admin-Managed
# - POLICY_MANAGED: Policy-Managed
#
# If left unspecified, default will be ADMIN_MANAGED
#------------------------------------------------------------------------------
oracle.install.db.rac.configurationType=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is ADMIN_MANAGED
#
# Specify the cluster node names selected during the installation.
# Leaving it blank will result in install on local server only (Single Instance)
#
# Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=
#------------------------------------------------------------------------------
# This variable is used to enable or disable RAC One Node install.
#
# - true : Value of RAC One Node service name is used.
# - false : Value of RAC One Node service name is not used.
#
# If left blank, it will be assumed to be false.
#------------------------------------------------------------------------------
oracle.install.db.isRACOneInstall=
#------------------------------------------------------------------------------
# Value is required only if oracle.install.db.isRACOneInstall is true.
#
# Specify the name for RAC One Node Service
#------------------------------------------------------------------------------
oracle.install.db.racOneServiceName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a name for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolName=pool1
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolName=
#------------------------------------------------------------------------------
# Value is required only if RAC database type is POLICY_MANAGED
#
# Specify a number as cardinality for the new Server pool that will be configured
# Example : oracle.install.db.rac.serverpoolCardinality=2
#------------------------------------------------------------------------------
oracle.install.db.rac.serverpoolCardinality=
###############################################################################
# #
# Database Configuration Options #
# #
###############################################################################
#-------------------------------------------------------------------------------
# Specify the type of database to create.
# It can be one of the following:
# - GENERAL_PURPOSE/TRANSACTION_PROCESSING
# - DATA_WAREHOUSE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.type=
#-------------------------------------------------------------------------------
# Specify the Starter Database Global Database Name.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=
#-------------------------------------------------------------------------------
# Specify the Starter Database SID.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=
#-------------------------------------------------------------------------------
# Specify whether the database should be configured as a Container database.
#-------------------------------------------------------------------------------
oracle.install.db.ConfigureAsContainerDB=
#-------------------------------------------------------------------------------
# Specify the Pluggable Database name for the pluggable database in Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.PDBName=
#-------------------------------------------------------------------------------
# Specify the Starter Database character set.
#
# One of the following
# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.characterSet=
#------------------------------------------------------------------------------
# This variable should be set to true if Automatic Memory Management
# in Database is desired.
# If Automatic Memory Management is not desired, and memory allocation
# is to be done manually, then set it to false.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryOption=
#-------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available
# on the system.
# Example: oracle.install.db.config.starterdb.memoryLimit=512
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=
#-------------------------------------------------------------------------------
# This variable controls whether to load Example Schemas onto
# the starter database or not.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.installExampleSchemas=
###############################################################################
# #
# Passwords can be supplied for the following four schemas in the #
# starter database: #
# SYS #
# SYSTEM #
# DBSNMP (used by Enterprise Manager) #
# #
# Same password can be used for all accounts (not recommended) #
# or different passwords for each account can be provided (recommended) #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable holds the password that is to be used for all schemas in the
# starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.ALL=
#-------------------------------------------------------------------------------
# Specify the SYS password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYS=
#-------------------------------------------------------------------------------
# Specify the SYSTEM password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.SYSTEM=
#-------------------------------------------------------------------------------
# Specify the DBSNMP password for the starter database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.DBSNMP=
#-------------------------------------------------------------------------------
# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.password.PDBADMIN=
#-------------------------------------------------------------------------------
# Specify the management option to use for managing the database.
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.
# 2. DEFAULT -If you want to manage your database using the default Database Express option.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.managementOption=
#-------------------------------------------------------------------------------
# Specify the OMS host to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsHost=
#-------------------------------------------------------------------------------
# Specify the OMS port to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.omsPort=
#-------------------------------------------------------------------------------
# Specify the EM Admin user name to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminUser=
#-------------------------------------------------------------------------------
# Specify the EM Admin password to use to connect to Cloud Control.
# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.emAdminPassword=
###############################################################################
# #
# SPECIFY RECOVERY OPTIONS #
# ------------------------------------ #
# Recovery options for the database can be mentioned using the entries below #
# #
###############################################################################
#------------------------------------------------------------------------------
# This variable is to be set to false if database recovery is not required. Else
# this can be set to true.
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.enableRecovery=
#-------------------------------------------------------------------------------
# Specify the type of storage to use for the database.
# It can be one of the following:
# - FILE_SYSTEM_STORAGE
# - ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.storageType=
#-------------------------------------------------------------------------------
# Specify the database file location which is a directory for datafiles, control
# files, redo logs.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
#-------------------------------------------------------------------------------
# Specify the recovery location.
#
# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
#-------------------------------------------------------------------------------
# Specify the existing ASM disk groups to be used for storage.
#
# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.diskGroup=
#-------------------------------------------------------------------------------
# Specify the password for ASMSNMP user of the ASM instance.
#
# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE
#-------------------------------------------------------------------------------
oracle.install.db.config.asm.ASMSNMPPassword=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username.
#
# Example : MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password.
#
# Example : MYORACLESUPPORT_PASSWORD=password
#------------------------------------------------------------------------------
MYORACLESUPPORT_PASSWORD=ccbc
#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=0
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
#------------------------------------------------------------------------------
# Specify the Proxy server name. Length should be greater than zero.
#
# Example : PROXY_HOST=proxy.domain.com
#------------------------------------------------------------------------------
PROXY_HOST=
#------------------------------------------------------------------------------
# Specify the proxy port number. Should be Numeric and atleast 2 chars.
#
# Example : PROXY_PORT=25
#------------------------------------------------------------------------------
PROXY_PORT=
#------------------------------------------------------------------------------
# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_USER=username
#------------------------------------------------------------------------------
PROXY_USER=
#------------------------------------------------------------------------------
# Specify the proxy password. Leave PROXY_USER and PROXY_PWD
# blank if your proxy server requires no authentication.
#
# Example : PROXY_PWD=password
#------------------------------------------------------------------------------
PROXY_PWD=
#------------------------------------------------------------------------------
# Specify the proxy realm.
#
# Example : PROXY_REALM=metalink
#------------------------------------------------------------------------------
PROXY_REALM=
#------------------------------------------------------------------------------
# Specify the Oracle Support Hub URL.
#
# Example : COLLECTOR_SUPPORTHUB_URL=
#------------------------------------------------------------------------------
COLLECTOR_SUPPORTHUB_URL=
#------------------------------------------------------------------------------
# Specify the auto-updates option. It can be one of the following:
# - MYORACLESUPPORT_DOWNLOAD
# - OFFLINE_UPDATES
# - SKIP_UPDATES
#------------------------------------------------------------------------------
oracle.installer.autoupdates.option=SKIP_UPDATES
#------------------------------------------------------------------------------
# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where
# the updates are to be downloaded.
# In case OFFLINE_UPDATES option is chosen, specify the location where the updates
# are present.
#------------------------------------------------------------------------------
oracle.installer.autoupdates.downloadUpdatesLoc=
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username which has the patches download privileges
# to be used for software updates.
# Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com
#------------------------------------------------------------------------------
# Specify the My Oracle Support Account Username password which has the patches download privileges
# to be used for software updates.
#
# Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password
#-------------------------------------------------------------------------
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=ccbc
獲得幫助
/taryartar/12c/database/runInstaller -help
啟動靜默安裝
/taryartar/12c/database/runInstaller -silent -noconfig -responseFile /taryartar/12c/db_install.rsp
-silent 表示靜默安裝
-noconfig 表示只安裝軟體
-responseFile 指定響應檔案
監控安裝的過程
[root@rac1 db_base]# tail -f /taryartar/12c/oraInventory/logs/installActions2013-08-03_11-52-40PM.log
INFO: Installation in progress
INFO: Extracting files to '/taryartar/12c/db_base/db_home'.
INFO: Extracting files to '/taryartar/12c/db_base/db_home'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_dirs.lst'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_filemap.jar'.
INFO: Performing fastcopy operations based on the information in the file 'racfiles.jar'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_exp_1.xml'.
INFO: Performing fastcopy operations based on the information in the file 'oracle.server_EE_1.xml'.
INFO: Performing fastcopy operations based on the information in the file 'setperms1.sh'.
安裝過程如下：
.......
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 10709 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2303 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-08-03_11-52-40PM. Please wait ...[oracle@rac1 response]$ You can find the log of this install session at:
/taryartar/12c/oraInventory/logs/installActions2013-08-03_11-52-40PM.log
The installation of Oracle Database 12c was successful.
Please check '/taryartar/12c/oraInventory/logs/silentInstall2013-08-03_11-52-40PM.log' for more details.
As a root user, execute the following script(s):
1. /taryartar/12c/oraInventory/orainstRoot.sh
2. /taryartar/12c/db_base/db_home/root.sh
Successfully Setup Software.
As install user, execute the following script. to complete the configuration.
1. /taryartar/12c/db_base/db_home/cfgtoollogs/configToolAllCommands RESPONSE_FILE=
Note:
1. This script. must be run on the same host from where installer was run.
2. This script. needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
以root執行指令碼
[root@rac1 ~]# /taryartar/12c/oraInventory/orainstRoot.sh
Changing permissions of /taryartar/12c/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /taryartar/12c/oraInventory to oinstall.
The execution of the script. is complete.
[root@rac1 ~]# /taryartar/12c/db_base/db_home/root.sh
Check /taryartar/12c/db_base/db_home/install/root_rac1_2013-08-04_00-27-25.log for the output of root script
[root@rac1 ~]#
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------配置監聽器------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
編輯監聽器配置響應檔案netca.rsp，編輯後的內容如下：
######################################################################
## Copyright(c) 1998, 2012 Oracle Corporation. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize your ##
## installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## identifies the variable type. ##
## ##
## Please specify the values in the following format: ##
## ##
## Type Example ##
## String "Sample Value" ##
## Boolean True or False ##
## Number 1000 ##
## StringList {"String value 1","String Value 2"} ##
## ##
######################################################################
## ##
## This sample response file causes the Oracle Net Configuration ##
## Assistant (NetCA) to complete an Oracle Net configuration during ##
## a custom install of the Oracle12c server which is similar to ##
## what would be created by the NetCA during typical Oracle12c ##
## install. It also documents all of the NetCA response file ##
## variables so you can create your own response file to configure ##
## Oracle Net during an install the way you wish. ##
## ##
######################################################################
[GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#SHOW_GUI=false
#-------------------------------------------------------------------------------
# Name : LOG_FILE
# Datatype : String
# Description: If present, NetCA will log output to this file in addition to the
# standard out.
# Pre-req : N/A
# Default : NONE
# Note:
# This is a substitute of "/log" in the NetCA command line.
# The command line argument has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
#LOG_FILE=""/oracle12cHome/network/tools/log/netca.log""
[oracle.net.ca]
#INSTALLED_COMPONENTS;StringList;list of installed components
# The possible values for installed components are:
# "net8","server","client","aso", "cman", "javavm"
INSTALLED_COMPONENTS={"server","net8","javavm"}
#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom"
INSTALL_TYPE=""typical""
#LISTENER_NUMBER;Number;Number of Listeners
# A typical install sets one listener
LISTENER_NUMBER=1
#LISTENER_NAMES;StringList;list of listener names
# The values for listener are:
# "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...
# A typical install sets only "LISTENER"
LISTENER_NAMES={"LISTENER"}
#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)
# The possible values for listener protocols are:
# "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
# A typical install sets only "TCP;1521"
LISTENER_PROTOCOLS={"TCP;1521"}
#LISTENER_START;String;name of the listener to start, in double quotes
LISTENER_START=""LISTENER""
#NAMING_METHODS;StringList;list of naming methods
# The possible values for naming methods are:
# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE
# A typical install sets only: "TNSNAMES","ONAMES","HOSTNAMES"
# or "LDAP","TNSNAMES","ONAMES","HOSTNAMES" for LDAP
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes
# A typical install does not use this variable.
#NOVELL_NAMECONTEXT = ""NAMCONTEXT""
#SUN_METAMAP;String; SUN meta. map, in double quotes
# A typical install does not use this variable.
#SUN_METAMAP = ""MAP""
#DCE_CELLNAME;String;DCE cell name, in double quotes
# A typical install does not use this variable.
#DCE_CELLNAME = ""CELL""
#NSN_NUMBER;Number;Number of NetService Names
# A typical install sets one net service name
NSN_NUMBER=1
#NSN_NAMES;StringList;list of Net Service names
# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
#NSN_SERVICE;StringList;Oracle12c database's service name
# A typical install sets Oracle12c database's service name to "PLSExtProc"
NSN_SERVICE={"PLSExtProc"}
#NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters
# The possible values for net service name protocol parameters are:
# "TCP;HOSTNAME;1521","TCPS;HOSTNAME;2484","NMP;COMPUTERNAME;ORAPIPE","VI;HOSTNAME;1521","IPC;IPCKEY"
# A typical install sets parameters to "IPC;EXTPROC"
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
#SERVICEUSERPASSWORD;String;Windows service user password
# If the oracle home is installed as secure user, supply the password
#SERVICEUSERPASSWORD=""svcpassword""
配置監聽器
[oracle@rac1 12c]$ /taryartar/12c/db_base/db_home/bin/netca -silent -responsefile /taryartar/12c/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /taryartar/12c/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Listener "LISTENER" already exists.
Oracle Net Services configuration successful. The exit code is 0
啟動監聽器
[oracle@rac1 12c]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 04-AUG-2013 00:39:08
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /taryartar/12c/db_base/db_home/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /taryartar/12c/db_base/db_home/network/admin/listener.ora
Log messages written to /taryartar/12c/db_base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 04-AUG-2013 00:39:08
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /taryartar/12c/db_base/db_home/network/admin/listener.ora
Listener Log File /taryartar/12c/db_base/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=1521)))
The listener supports no services
The command completed successfully
--------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--------------------------------建立資料庫------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
編輯響應檔案dbca.rsp，編輯後的內容如下:
##############################################################################
## ##
## DBCA response file ##
## ------------------ ##
## Copyright 1998, 2012, Oracle Corporation. All Rights Reserved. ##
## ##
## Specify values for the variables listed below to customize Oracle ##
## Database Configuration installation. ##
## ##
## Each variable is associated with a comment. The comment identifies the ##
## variable type. ##
## ##
## Please specify the values in the following format : ##
## Type : Example ##
## String : "" ##
## Boolean : True or False ##
## Number : ##
## StringList : {"",""} ##
## ##
## Examples : ##
## 1. dbca -progress_only -responseFile ##
## Display a progress bar depicting progress of database creation ##
## process. ##
## ##
## 2. dbca -silent -responseFile ##
## Creates database silently. No user interface is displayed. ##
## ##
## 3. dbca -silent -createDatabase -cloneTemplate ##
## -responseFile ##
## Creates database silently with clone template. The template in ##
## responsefile is a clone template. ##
## ##
## 4. dbca -silent -deleteDatabase -responseFile ##
## Deletes database silently. ##
##############################################################################
#-----------------------------------------------------------------------------
# GENERAL section is required for all types of database creations.
#-----------------------------------------------------------------------------
[GENERAL]
#-----------------------------------------------------------------------------
# Name : RESPONSEFILE_VERSION
# Datatype : String
# Description : Version of the database to create
# Valid values : "12.1.0"
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
RESPONSEFILE_VERSION = "12.1.0"
#-----------------------------------------------------------------------------
# Name : OPERATION_TYPE
# Datatype : String
# Description : Type of operation
# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase"
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
OPERATION_TYPE = "createDatabase"
#-----------------------*** End of GENERAL section ***------------------------
#-----------------------------------------------------------------------------
# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".
#-----------------------------------------------------------------------------
[CREATEDATABASE]
#-----------------------------------------------------------------------------
# Name : GDBNAME
# Datatype : String
# Description : Global database name of the database
# Valid values : . - when database domain isn't NULL
# - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
GDBNAME = "tar.taryartar.com"
#-----------------------------------------------------------------------------
# Name : RACONENODE
# Datatype : Boolean
# Description : Set to true for RAC One Node database
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#RACONENODE = "false"
#-----------------------------------------------------------------------------
# Name : RACONENODESERVICENAME
# Datatype : String
# Description : Service is required by application to connect to RAC One
# Node Database
# Valid values : Service Name
# Default value : None
# Mandatory : No [required in case RACONENODE flag is set to true]
#-----------------------------------------------------------------------------
#RACONENODESERVICENAME =
#-----------------------------------------------------------------------------
# Name : POLICYMANAGED
# Datatype : Boolean
# Description : Set to true if Database is policy managed and
# set to false if Database is admin managed
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#POLICYMANAGED = "false"
#-----------------------------------------------------------------------------
# Name : CREATESERVERPOOL
# Datatype : Boolean
# Description : Set to true if new server pool need to be created for database
# if this option is specified then the newly created database
# will use this newly created serverpool.
# Multiple serverpoolname can not be specified for database
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#CREATESERVERPOOL = "false"
#-----------------------------------------------------------------------------
# Name : SERVERPOOLNAME
# Datatype : String
# Description : Only one serverpool name need to be specified
# if Create Server Pool option is specified.
# Comma-separated list of Serverpool names if db need to use
# multiple Server pool
# Valid values : ServerPool name
# Default value : None
# Mandatory : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
#SERVERPOOLNAME =
#-----------------------------------------------------------------------------
# Name : CARDINALITY
# Datatype : Number
# Description : Specify Cardinality for create server pool operation
# Valid values : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
#CARDINALITY =
#-----------------------------------------------------------------------------
# Name : FORCE
# Datatype : Boolean
# Description : Set to true if new server pool need to be created by force
# if this option is specified then the newly created serverpool
# will be assigned server even if no free servers are available.
# This may affect already running database.
# This flag can be specified for Admin managed as well as policy managed db.
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#FORCE = "false"
#-----------------------------------------------------------------------------
# Name : PQPOOLNAME
# Datatype : String
# Description : Only one serverpool name needs to be specified
# if create server pool option is specified.
# Comma-separated list of serverpool names if use
# server pool. This is required to
# create Parallel Query (PQ) database. Applicable to Big Cluster
# Valid values : Parallel Query (PQ) pool name
# Default value : None
# Mandatory : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
#PQPOOLNAME =
#-----------------------------------------------------------------------------
# Name : PQCARDINALITY
# Datatype : Number
# Description : Specify Cardinality for create server pool operation.
# Applicable to Big Cluster
# Valid values : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
#PQCARDINALITY =
#-----------------------------------------------------------------------------
# Name : SID
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle12c Administrator's Guide
# Default value : specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
SID = "taryartar1"
#-----------------------------------------------------------------------------
# Name : CREATEASCONTAINERDATABASE
# Datatype : boolean
# Description : flag to create database as container database
# Valid values : Check Oracle12c Administrator's Guide
# Default value : false
# Mandatory : No
#-----------------------------------------------------------------------------
#CREATEASCONTAINERDATABASE =
#-----------------------------------------------------------------------------
# Name : NUMBEROFPDBS
# Datatype : Number
# Description : Specify the number of pdb to be created
# Valid values : 0 to 252
# Default value : 0
# Mandatory : No
#-----------------------------------------------------------------------------
#NUMBEROFPDBS =
#-----------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#PDBNAME =
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Comma-separated list of cluster nodes
# Valid values : Cluster node names
# Default value : None
# Mandatory : No (Yes for RAC database-centric database )
#-----------------------------------------------------------------------------
#NODELIST=
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name of the template
# Valid values : Template file name
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "General_Purpose.dbc"
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSPASSWORD
# Datatype : String
# Description : Password for SYS user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSPASSWORD = "Xzzp2008"
#-----------------------------------------------------------------------------
# Name : SYSTEMPASSWORD
# Datatype : String
# Description : Password for SYSTEM user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSTEMPASSWORD = "Xzzp2008"
#-----------------------------------------------------------------------------
# Name : SERVICEUSERPASSWORD
# Datatype : String
# Description : Password for Windows Service user
# Default value : None
# Mandatory : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
#SERVICEUSERPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : EMCONFIGURATION
# Datatype : String
# Description : Enterprise Manager Configuration Type
# Valid values : CENTRAL|LOCAL|ALL|NONE
# Default value : NONE
# Mandatory : No
#-----------------------------------------------------------------------------
#EMCONFIGURATION = "NONE"
#-----------------------------------------------------------------------------
# Name : SYSMANPASSWORD
# Datatype : String
# Description : Password for SYSMAN user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#SYSMANPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : DBSNMPPASSWORD
# Datatype : String
# Description : Password for DBSNMP user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if EMCONFIGURATION is specified
#-----------------------------------------------------------------------------
#DBSNMPPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : CENTRALAGENT
# Datatype : String
# Description : Grid Control Central Agent Oracle Home
# Default value : None
# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#CENTRALAGENT =
#-----------------------------------------------------------------------------
# Name : HOSTUSERNAME
# Datatype : String
# Description : Host user name for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERNAME =
#-----------------------------------------------------------------------------
# Name : HOSTUSERPASSWORD
# Datatype : String
# Description : Host user password for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERPASSWORD=
#-----------------------------------------------------------------------------
# Name : BACKUPSCHEDULE
# Datatype : String
# Description : Daily backup schedule in the form. of hh:mm
# Default value : 2:00
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#BACKUPSCHEDULE=
#-----------------------------------------------------------------------------
# Name : DVCONFIGURATION
# Datatype : Boolean
# Description : Specify "True" to configure and enable Oracle Database vault
# Valid values : True/False
# Default value : False
# Mandatory : No
#-----------------------------------------------------------------------------
#DVCONFIGURATION = "false"
#-----------------------------------------------------------------------------
# Name : DVOWNERNAME
# Datatype : String
# Description : DataVault Owner
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
#DVOWNERNAME = ""
#-----------------------------------------------------------------------------
# Name : DVOWNERPASSWORD
# Datatype : String
# Description : Password for DataVault Owner
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
#DVOWNERPASSWORD = ""
#-----------------------------------------------------------------------------
# Name : DVACCOUNTMANAGERNAME
# Datatype : String
# Description : DataVault Account Manager
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DVACCOUNTMANAGERNAME = ""
#-----------------------------------------------------------------------------
# Name : DVACCOUNTMANAGERPASSWORD
# Datatype : String
# Description : Password for DataVault Account Manager
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DVACCOUNTMANAGERPASSWORD = ""
#-----------------------------------------------------------------------------
# Name : OLSCONFIGURATION
# Datatype : Boolean
# Description : Specify "True" to configure and enable Oracle Label Security
# Valid values : True/False
# Default value : False
# Mandatory : No
#-----------------------------------------------------------------------------
#OLSCONFIGURATION = "false"
#-----------------------------------------------------------------------------
# Name : DATAFILEJARLOCATION
# Datatype : String
# Description : Location of the data file jar
# Valid values : Directory containing compressed datafile jar
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#DATAFILEJARLOCATION =
#-----------------------------------------------------------------------------
# Name : DATAFILEDESTINATION
# Datatype : String
# Description : Location of the data file's
# Valid values : Directory for all the database files
# Default value : $ORACLE_BASE/oradata
# Mandatory : No
#-----------------------------------------------------------------------------
#DATAFILEDESTINATION =
#-----------------------------------------------------------------------------
# Name : RECOVERYAREADESTINATION
# Datatype : String
# Description : Location of the data file's
# Valid values : Recovery Area location
# Default value : $ORACLE_BASE/flash_recovery_area
# Mandatory : No
#-----------------------------------------------------------------------------
#RECOVERYAREADESTINATION=
#-----------------------------------------------------------------------------
# Name : STORAGETYPE
# Datatype : String
# Description : Specifies the storage on which the database is to be created
# Valid values : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory : No
#-----------------------------------------------------------------------------
#STORAGETYPE=FS
#-----------------------------------------------------------------------------
# Name : DISKGROUPNAME
# Datatype : String
# Description : Specifies the disk group name for the storage
# Default value : DATA
# Mandatory : No
#-----------------------------------------------------------------------------
#DISKGROUPNAME=DATA
#-----------------------------------------------------------------------------
# Name : ASMSNMP_PASSWORD
# Datatype : String
# Description : Password for ASM Monitoring
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#ASMSNMP_PASSWORD=""
#-----------------------------------------------------------------------------
# Name : RECOVERYGROUPNAME
# Datatype : String
# Description : Specifies the disk group name for the recovery area
# Default value : RECOVERY
# Mandatory : No
#-----------------------------------------------------------------------------
#RECOVERYGROUPNAME=RECOVERY
#-----------------------------------------------------------------------------
# Name : CHARACTERSET
# Datatype : String
# Description : Character set of the database
# Valid values : Check Oracle12c National Language Support Guide
# Default value : "US7ASCII"
# Mandatory : NO
#-----------------------------------------------------------------------------
#CHARACTERSET = "US7ASCII"
#-----------------------------------------------------------------------------
# Name : NATIONALCHARACTERSET
# Datatype : String
# Description : National Character set of the database
# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory : No
#-----------------------------------------------------------------------------
#NATIONALCHARACTERSET= "UTF8"
#-----------------------------------------------------------------------------
# Name : REGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to register with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : DIRSERVICEUSERNAME
# Datatype : String
# Description : Specifies the name of the directory service user
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#DIRSERVICEUSERNAME= "name"
#-----------------------------------------------------------------------------
# Name : DIRSERVICEPASSWORD
# Datatype : String
# Description : The password of the directory service user.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#DIRSERVICEPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : WALLETPASSWORD
# Datatype : String
# Description : The password for wallet to created or modified.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
#WALLETPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : LISTENERS
# Datatype : String
# Description : Specifies list of listeners to register the database with.
# By default the database is configured for all the listeners specified in the
# $ORACLE_HOME/network/admin/listener.ora
# Valid values : The list should be space separated names like "listener1 listener2".
# Mandatory : NO
#-----------------------------------------------------------------------------
#LISTENERS = "listener1 listener2"
#-----------------------------------------------------------------------------
# Name : VARIABLESFILE
# Datatype : String
# Description : Location of the file containing variable value pair
# Valid values : A valid file-system file. The variable value pair format in this file
# is =. Each pair should be in a new line.
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#VARIABLESFILE =
#-----------------------------------------------------------------------------
# Name : VARIABLES
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#VARIABLES =
#-----------------------------------------------------------------------------
# Name : INITPARAMS
# Datatype : String
# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#INITPARAMS =
#-----------------------------------------------------------------------------
# Name : SAMPLESCHEMA
# Datatype : Boolean
# Description : Specifies whether or not to add the Sample Schemas to your database
# Valid values : TRUE \ FALSE
# Default value : FASLE
# Mandatory : No
#-----------------------------------------------------------------------------
#SAMPLESCHEMA=TRUE
#-----------------------------------------------------------------------------
# Name : MEMORYPERCENTAGE
# Datatype : String
# Description : percentage of physical memory for Oracle
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
#MEMORYPERCENTAGE = "40"
#-----------------------------------------------------------------------------
# Name : DATABASETYPE
# Datatype : String
# Description : used for memory distribution when MEMORYPERCENTAGE specified
# Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
# Default value : MULTIPURPOSE
# Mandatory : NO
#-----------------------------------------------------------------------------
#DATABASETYPE = "MULTIPURPOSE"
#-----------------------------------------------------------------------------
# Name : AUTOMATICMEMORYMANAGEMENT
# Datatype : Boolean
# Description : flag to indicate Automatic Memory Management is used
# Valid values : TRUE/FALSE
# Default value : TRUE
# Mandatory : NO
#-----------------------------------------------------------------------------
#AUTOMATICMEMORYMANAGEMENT = "TRUE"
#-----------------------------------------------------------------------------
# Name : TOTALMEMORY
# Datatype : String
# Description : total memory in MB to allocate to Oracle
# Valid values :
# Default value :
# Mandatory : NO
#-----------------------------------------------------------------------------
#TOTALMEMORY = "800"
#-----------------------*** End of CREATEDATABASE section ***------------------------
#-----------------------------------------------------------------------------
# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".
#-----------------------------------------------------------------------------
[createTemplateFromDB]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database from which to create the template
# Valid values : The format is ::
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "myhost:1521:orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "system"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name for the new template.
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
#-----------------------------------------------------------------------------
# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".
#-----------------------------------------------------------------------------
[createCloneTemplate]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID from which to create the template.
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name for the new template.
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "My Clone TEMPLATE"
#-----------------------------------------------------------------------------
# Name : DATAFILEJARLOCATION
# Datatype : String
# Description : Location of the data file jar
# Valid values : Directory where the new compressed datafile jar will be placed
# Default value : $ORACLE_HOME/assistants/dbca/templates
# Mandatory : NO
#-----------------------------------------------------------------------------
#DATAFILEJARLOCATION =
#-----------------------*** End of createCloneTemplate section ***------------------------
#-----------------------------------------------------------------------------
# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".
#-----------------------------------------------------------------------------
[DELETEDATABASE]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------*** End of deleteDatabase section ***------------------------
#-----------------------------------------------------------------------------
# GENERATESCRIPTS section
#-----------------------------------------------------------------------------
[generateScripts]
#-----------------------------------------------------------------------------
# Name : TEMPLATENAME
# Datatype : String
# Description : Name of the template
# Valid values : Template name as seen in DBCA
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
TEMPLATENAME = "New Database"
#-----------------------------------------------------------------------------
# Name : GDBNAME
# Datatype : String
# Description : Global database name of the database
# Valid values : . - when database domain isn't NULL
# - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
GDBNAME = "orcl12.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : SCRIPTDESTINATION
# Datatype : String
# Description : Location of the scripts
# Valid values : Directory for all the scripts
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#SCRIPTDESTINATION =
#-----------------------*** End of deleteDatabase section ***------------------------
#-----------------------------------------------------------------------------
# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".
#-----------------------------------------------------------------------------
[CONFIGUREDATABASE]
#-----------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SOURCEDB = "orcl"
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# You can also specify the password at the command prompt instead of here.
# Default value : none
# Mandatory : YES, if no OS authentication
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD =
#-----------------------------------------------------------------------------
# Name : REGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to register with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : UNREGISTERWITHDIRSERVICE
# Datatype : Boolean
# Description : Specifies whether to unregister with Directory Service.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#UNREGISTERWITHDIRSERVICE= TRUE
#-----------------------------------------------------------------------------
# Name : REGENERATEDBPASSWORD
# Datatype : Boolean
# Description : Specifies whether regenerate database password in OID/Wallet
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#REGENERATEDBPASSWORD= TRUE
#-----------------------------------------------------------------------------
# Name : DIRSERVICEUSERNAME
# Datatype : String
# Description : Specifies the name of the directory service user
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#DIRSERVICEUSERNAME= "name"
#-----------------------------------------------------------------------------
# Name : DIRSERVICEPASSWORD
# Datatype : String
# Description : The password of the directory service user.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#DIRSERVICEPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : WALLETPASSWORD
# Datatype : String
# Description : The password for wallet to created or modified.
# You can also specify the password at the command prompt instead of here.
# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
#-----------------------------------------------------------------------------
#WALLETPASSWORD= "password"
#-----------------------------------------------------------------------------
# Name : ENABLESECURITYCONFIGURATION
# Datatype : String
# Description : Database Security Settings
# Valid values : true|false
# Default value : true
# Mandatory : No
#-----------------------------------------------------------------------------
#ENABLESECURITYCONFIGURATION = "true"
#-----------------------------------------------------------------------------
# Name : EMCONFIGURATION
# Datatype : String
# Description : Enterprise Manager Configuration Type
# Valid values : CENTRAL|LOCAL|ALL|NONE
# Default value : NONE
# Mandatory : No
#-----------------------------------------------------------------------------
#EMCONFIGURATION = "NONE"
#-----------------------------------------------------------------------------
# Name : SYSMANPASSWORD
# Datatype : String
# Description : Password for SYSMAN user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#SYSMANPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : DBSNMPPASSWORD
# Datatype : String
# Description : Password for DBSNMP user
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes, if EMCONFIGURATION is specified
#-----------------------------------------------------------------------------
#DBSNMPPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : CENTRALAGENT
# Datatype : String
# Description : Grid Control Central Agent Oracle Home
# Default value : None
# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#CENTRALAGENT =
#-----------------------------------------------------------------------------
# Name : HOSTUSERNAME
# Datatype : String
# Description : Host user name for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERNAME =
#-----------------------------------------------------------------------------
# Name : HOSTUSERPASSWORD
# Datatype : String
# Description : Host user password for EM backup job
# Default value : None
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#HOSTUSERPASSWORD=
#-----------------------------------------------------------------------------
# Name : BACKUPSCHEDULE
# Datatype : String
# Description : Daily backup schedule in the form. of hh:mm
# Default value : 2:00
# Mandatory : Yes, if ALL is specified for EMCONFIGURATION
#-----------------------------------------------------------------------------
#BACKUPSCHEDULE=
#-----------------------*** End of CONFIGUREDATABASE section ***------------------------
#-----------------------------------------------------------------------------
# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".
#-----------------------------------------------------------------------------
[ADDINSTANCE]
#-----------------------------------------------------------------------------
# Name : DB_UNIQUE_NAME
# Datatype : String
# Description : DB Unique Name of the RAC database
# Valid values :
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : INSTANCENAME
# Datatype : String
# Description : RAC instance name to be added
# Valid values : Check Oracle12c Administrator's Guide
# Default value : +
# Mandatory : No
#-----------------------------------------------------------------------------
#INSTANCENAME = "orcl1"
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Node on which to add new instance
# (in 10gR2, instance addition is supported on 1 node at a time)
# Valid values : Cluster node name
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
NODELIST=
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------------------------------------------------------------
# Name : SERVICEUSERPASSWORD
# Datatype : String
# Description : Password for Windows Service user
# Default value : None
# Mandatory : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
#SERVICEUSERPASSWORD = "password"
#-----------------------*** End of ADDINSTANCE section ***------------------------
#-----------------------------------------------------------------------------
# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".
#-----------------------------------------------------------------------------
[DELETEINSTANCE]
#-----------------------------------------------------------------------------
# Name : DB_UNIQUE_NAME
# Datatype : String
# Description : DB Unique Name of the RAC database
# Valid values :
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
#-----------------------------------------------------------------------------
# Name : INSTANCENAME
# Datatype : String
# Description : RAC instance name to be deleted
# Valid values : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
INSTANCENAME = "orcl12c"
#-----------------------------------------------------------------------------
# Name : NODELIST
# Datatype : String
# Description : Node on which instance to be deleted (SID) is located
# Valid values : Cluster node name
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
#NODELIST=
#-----------------------------------------------------------------------------
# Name : OBFUSCATEDPASSWORDS
# Datatype : Boolean
# Description : Set to true if passwords are encrypted
# Valid values : TRUE\FALSE
# Default value : FALSE
# Mandatory : No
#-----------------------------------------------------------------------------
#OBFUSCATEDPASSWORDS = FALSE
#-----------------------------------------------------------------------------
# Name : SYSDBAUSERNAME
# Datatype : String
# Description : A user with DBA role.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SYSDBAUSERNAME = "sys"
#-----------------------------------------------------------------------------
# Name : SYSDBAPASSWORD
# Datatype : String
# Description : The password of the DBA user.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
#SYSDBAPASSWORD = "password"
#-----------------------*** End of DELETEINSTANCE section ***------------------------
#----------------------------------------------------------------------------------
# CREATEPLUGGABLEDATABASE section is used when PLUGPDB_TYPE is defined as "createPluggableDatabase".
#----------------------------------------------------------------------------------
[CREATEPLUGGABLEDATABASE]
#----------------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#----------------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : The name of new pluggable database
# This pdb name must not be same as sourcedb name.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
PDBNAME = "PDB1"
#----------------------------------------------------------------------------------
# Name : CREATEASCLONE
# Datatype : Boolean
# Description : specify true or false for PDB to be create as Clone.
# : When "true" is passed a new PDB GUID is generated for the plugged in PDB
# Default value : true
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEASCLONE = "TRUE"
#----------------------------------------------------------------------------------
#----------------------------------------------------------------------------------
# Name : CREATEPDBFROM
# Datatype : String
# Description : specify the source of pdb to be plugged
# Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML
# Default value : DEFAULT
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEPDBFROM = "DEFAULT"
#----------------------------------------------------------------------------------
# Name : PDBARCHIVEFILE
# Datatype : String
# Description : Full path and name for pdbArchive file
# Default value : None
# Mandatory : Mandatory when creating new PDB using FILEARCHIVE
#-----------------------------------------------------------------------------
# PDBARCHIVEFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBBACKUPFILE
# Datatype : String
# Description : Full path and name for pdb back up file
# Default value : None
# Mandatory : Mandatory when creating new PDB using RMANBACKUP
#-----------------------------------------------------------------------------
# PDBBACKUPFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBMETADATAFILE
# Datatype : String
# Description : Full path and name for pdb metadata file
# Default value : None
# Mandatory : Mandatory when creating new PDB using RMANBACKUP or USINGXML
#-----------------------------------------------------------------------------
# PDBMETADATAFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBADMINUSERNAME
# Datatype : String
# Description : PDB Administrator user name
# Default value : None
# Mandatory : Mandatory only when creating new DEFAULT PDB
#-----------------------------------------------------------------------------
# PDBADMINUSERNAME = ""
#----------------------------------------------------------------------------------
# Name : PDBADMINPASSWORD
# Datatype : String
# Description : PDB Administrator user password
# Default value : None
# Mandatory : Mandatory only when creating new DEFAULT PDB
#-----------------------------------------------------------------------------
# PDBADMINPASSWORD = ""
#----------------------------------------------------------------------------------
# Name : CREATENEWPDBADMINUSER
# Datatype : String
# Description : When Plugging a pdb from FILEARCHIVE or RMANBACKUP
# a new PDB Administrator user can be created using this option
# This option should be given along with pdbadmin username and password
# Default value : False
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATENEWPDBADMINUSER = ""
#----------------------------------------------------------------------------------
# Name : SOURCEFILENAMECONVERT
# Datatype : String
# Description : This clause specifies how to locate files listed in an XML file
# describing a Pluggable Database if they reside in a location different
# from that specified in the XML file.
# This clause is valid when creating Pluggable database in USINGXML option
# Valid values : (, ,....)
# Default value : "NONE"
# Mandatory : NO
#-----------------------------------------------------------------------------
# SOURCEFILENAMECONVERT = ""
#----------------------------------------------------------------------------------
# Name : FILENAMECONVERT
# Datatype : String
# Description : This clause specifies how to generate names of files
# for the Pluggable Database being created using names of existing files
# This clause is valid when creating Pluggable database in USINGXML option
# Valid values : (, ,....)
# Default value : "NONE"
# Mandatory : NO
#-----------------------------------------------------------------------------
# FILENAMECONVERT = ""
#----------------------------------------------------------------------------------
# Name : COPYPDBFILES
# Datatype : Boolean
# Description : If COPY is specified, it will indicate that datafiles need to be copied.
# : This option can be true only when FILENAMECONVERT is specified or
# CDB files are Oracle Managed Files(OMF)
# Valid values : TRUE \ FALSE
# Default value : False
# Mandatory : NO
#-----------------------------------------------------------------------------
# COPYPDBFILES = ""
#----------------------------------------------------------------------------------
# Name : PDBDATAFILEDESTINATION
# Datatype : String
# Description : common location for PDB datafile area
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
# PDBDATAFILEDESTINATION = ""
#----------------------------------------------------------------------------------
# Name : USEMETADATAFILELOCATION
# Datatype : Boolean
# Description : Specify true if datafile path defined in Meta. datafile within PDB
# archive file is to be used to un-archive datafile.
# Valid values : TRUE \ FALSE
# Default value : FALSE
# Mandatory : NO
#-----------------------------------------------------------------------------
# USEMETADATAFILELOCATION = ""
#----------------------------------------------------------------------------------
# Name : CREATEUSERTABLESPACE
# Datatype : Boolean
# Description : Specify true if a default user tablespace need to be created in new PDB
#
# Valid values : TRUE \ FALSE
# Default value : TRUE
# Mandatory : NO
#-----------------------------------------------------------------------------
# CREATEUSERTABLESPACE = ""
#-----------------------*** End of createPluggableDatabase section ***------------------------
#----------------------------------------------------------------------------------
# UNPLUGDATABASE section is used when PLUGPDB_TYPE is defined as "unplugDatabase".
#----------------------------------------------------------------------------------
[UNPLUGDATABASE]
#----------------------------------------------------------------------------------
# Name : SOURCEDB
# Datatype : String
# Description : The source database is the SID
# This database must be local and on the same ORACLE_HOME.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
SOURCEDB = "orcl"
#----------------------------------------------------------------------------------
# Name : PDBNAME
# Datatype : String
# Description : The name of new pluggable database
# This pdb name must not be same as sourcedb name.
# Default value : none
# Mandatory : YES
#-----------------------------------------------------------------------------
PDBNAME = "PDB1"
#----------------------------------------------------------------------------------
# Name : ARCHIVETYPE
# Datatype : String
# Description : The unplugged database datafile backup will in tar.gz or rman backup
# This pdb name must not be same as sourcedb name.
# Valid values : TAR | RMAN
# Default value : TAR
# Mandatory : NO
#-----------------------------------------------------------------------------
ARCHIVETYPE = "TAR"
#----------------------------------------------------------------------------------
# Name : PDBARCHIVEFILE
# Datatype : String
# Description : Full path and name for pdbArchive file
# Default value : None
# Mandatory : NO
#-----------------------------------------------------------------------------
# PDBARCHIVEFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBBACKUPFILE
# Datatype : String
# Description : Full path and name for pdb back up file
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
# PDBBACKUPFILE = ""
#----------------------------------------------------------------------------------
# Name : PDBMETADATAFILE
# Datatype : String
# Description : Full path and name for pdb metadata file
# Default value : None
# Mandatory : No
#-----------------------------------------------------------------------------
# PDBMETADATAFILE = ""
#-----------------------*** End of unplugDatabase section ***------------------------
建立資料庫
[oracle@rac1 db_home]$ /taryartar/12c/db_base/db_home/bin/dbca -silent -responseFile /taryartar/12c/dbca.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
37% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
57% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/taryartar/12c/db_base/cfgtoollogs/dbca/tar/tar4.log" for further details.
測試，是否能夠登陸資料庫
[oracle@rac1 12c]$ sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Sun Aug 4 02:16:35 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
資料庫建立成功！
===錯誤=======================================
特別要注意的是，等號2邊不能有空格
oracle.install.option=INSTALL_DB_SWONLY
DECLINE_SECURITY_UPDATES要設定成true
INFO: Adding ExitStatus VAR_VALIDATION_FAILURE to the exit status set
許可權問題
/taryartar/12c/ has enough space. Required space is 6460 MB , available space is 8155 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-12547: TNS:lost contact
ORA-24324: service handle not initialized
轉自：http://blog.itpub.net/13804621/viewspace-767741/
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/18903360/viewspace-2136983/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle靜默安裝Oracle
- Oracle 靜默安裝Oracle
- 靜默安裝ORACLE（文件）Oracle
- Oracle 12C 單例項資料庫靜默安裝Oracle單例資料庫
- oracle靜默安裝raw裝置Oracle
- 靜默安裝oracle時報錯Oracle
- ORACLE 11.2.0.4靜默安裝Oracle
- 靜默安裝oracle軟體Oracle
- Oracle靜默安裝(單機）Oracle
- 靜默安裝ORACLE 軟體Oracle
- Oracle靜默安裝說明Oracle
- Android靜默安裝和靜默解除安裝Android
- oracle 19C 靜默安裝Oracle
- Oracle 11g 靜默安裝Oracle
- 靜默安裝oracle10gOracle
- oracle10g 靜默安裝Oracle
- Oracle 10g 靜默安裝Oracle 10g
- 【靜默】在RHEL 6.5上靜默安裝Oracle 18cOracle
- 【oracle】靜默安裝 oracle 11gr2Oracle
- rac靜默安裝
- dbca 靜默安裝
- centos 7.4靜默安裝oracle 19.3CentOSOracle
- 使用responseFile進行oracle靜默安裝Oracle
- Oracle 11g Database靜默安裝OracleDatabase
- oracle11g靜默安裝（修正）Oracle
- oracle安裝：使用響應檔案靜默安裝Oracle
- 靜默方式安裝、升級oracle(一): 安裝oracle軟體Oracle
- RHEL5 Oracle 11G R2 RAC 靜默安裝 （二）GI靜默安裝Oracle
- Android靜默安裝應用和靜默解除安裝應用Android
- PackageInstaller 5.0原始碼分析靜默安裝與靜默解除安裝Package原始碼
- oracle客戶端無人值守安裝 靜默安裝Oracle客戶端
- OEL6下靜默安裝Oracle 11g，靜默配置監聽Oracle
- RedHat上靜默安裝Oracle11gRedhatOracle
- CentOS 7.5靜默安裝Oracle 11gCentOSOracle
- CentOS 7.2靜默安裝Oracle11gCentOSOracle
- RedHat 7 靜默安裝Oracle11gRedhatOracle
- Oracle資料庫靜默安裝實踐Oracle資料庫
- centos6.8 靜默安裝 oracle 11.2.0.4CentOSOracle