Created
July 17, 2015 20:54
-
-
Save wy8162/56fbc6cb6d7d05b8d77c to your computer and use it in GitHub Desktop.
Install Oracle Silently
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| if [ $USER = "oracle" ]; then | |
| if [ $SHELL = "/bin/ksh" ]; then | |
| ulimit -p 16384 | |
| ulimit -n 65536 | |
| else | |
| ulimit -u 16384 -n 65536 | |
| fi | |
| fi |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # Script to install Oracle 11g R2 | |
| # | |
| # Yang Wang, 08/21/2014 | |
| # | |
| #------------------------------------------------------ | |
| # Constants | |
| #------------------------------------------------------ | |
| source ./oracle_constants.sh | |
| # | |
| # The following is IMPORTANT. Otherwise, the Oracle installer will get following errors and fail to install. | |
| # http://dbhk.wordpress.com/2010/11/25/oracle-11gr2-silent-installation-problem/ | |
| # Checking Temp space: must be greater than 180 MB. Actual 180764 MB Passed | |
| # Checking swap space: must be greater than 150 MB. Actual 4233 MB Passed | |
| # Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-25_10-52-41AM. Please wait …$ Exception in thread “main” java.lang.NoClassDefFoundError | |
| # at java.lang.Class.forName0(Native Method) | |
| # ... | |
| # at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132) | |
| #savedDISPLAY=$DISPLAY | |
| #unset DISPLAY | |
| # | |
| # Changed to do this when install Oracle database | |
| #------------------------------------------------------ | |
| # Functions start here | |
| #------------------------------------------------------ | |
| function isInstalled { | |
| if yum list installed "$@" >/dev/null 2>&1; then | |
| return 0 # true | |
| else | |
| return 1 # false | |
| fi | |
| } | |
| function configureSSH { | |
| echo "Configuring ssh now..." | |
| if ! grep -E "#session +required +pam_limits" /etc/pam.d/system-auth; then | |
| echo "Fixing /etc/pam.d/system-auth" | |
| sed -ri 's/^(session +required +pam_limits)/#\1/g' /etc/pam.d/system-auth | |
| fi | |
| if ! grep -E "#session +required +pam_limits" /etc/pam.d/password-auth; then | |
| echo "Fixing /etc/pam.d/password-auth" | |
| sed -ri 's/^(session +required +pam_limits)/#\1/g' /etc/pam.d/password-auth | |
| fi | |
| if ! grep -E "#account +required +pam_nologin" /etc/pam.d/sshd; then | |
| echo "Fixing /etc/pam.d/sshd" | |
| sed -ri 's/^(account +required +pam_nologin)/#\1/g' /etc/pam.d/sshd | |
| fi | |
| if ! grep -E "#session +required +pam_loginuid" /etc/pam.d/sshd; then | |
| echo "Fixing /etc/pam.d/sshd" | |
| sed -ri 's/^(session +required +pam_loginuid)/#\1/g' /etc/pam.d/sshd | |
| fi | |
| # Enable X11 forwarding | |
| sed -ri 's/#X11Forwarding yes/X11Forwarding yes/g' /etc/ssh/sshd_config | |
| sed -ri 's/#X11DisplayOffset 10/X11DisplayOffset 10/g' /etc/ssh/sshd_config | |
| sed -ri 's/#X11UseLocalhost yes/X11UseLocalhost yes/g' /etc/ssh/sshd_config | |
| echo "X11 Forwarding is enabled. So command ssh -Y host can be used." | |
| service sshd restart | |
| } | |
| function installSSH { | |
| if [ ! -f "/etc/yum.repos.d/public-yum-ol6.repo" ]; | |
| then | |
| echo "Installing Oracle Public YUM Repository" | |
| cd /etc/yum.repos.d | |
| wget http://public-yum.oracle.com/public-yum-ol6.repo | |
| wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle | |
| cd | |
| fi | |
| if [ ! -d "/etc/ssh" ]; then | |
| echo "Installing openssh-server openssh-clients sudo passwd rsyslog unzip xterm..." | |
| yum -y install openssh-server openssh-clients sudo passwd \ | |
| rsyslog unzip xterm xorg-x11-xauth libXtst \ | |
| xorg-x11-fonts-base liberation-fonts xorg-x11-fonts-* \ | |
| xterm xfonts-base ttf-liberation | |
| mkdir /var/run/sshd | |
| chmod -rx /var/run/sshd | |
| chkconfig sshd on | |
| chkconfig rsyslog on | |
| service sshd start | |
| service rsyslog start | |
| fi | |
| configureSSH | |
| } | |
| function addGroupAndUser { | |
| echo "==> Creating Oracle groups and user oracle. Default password marlo12" | |
| groupadd -g 501 oinstall | |
| groupadd -g 502 dba | |
| groupadd -g 503 oper | |
| groupadd -g 504 asmadmin | |
| groupadd -g 506 asmdba | |
| groupadd -g 505 asmoper | |
| useradd -u 502 -g oinstall -G dba,asmdba,oper,wheel oracle | |
| # Change password anyway | |
| echo oracle:marlo12 | chpasswd | |
| if ! grep "ywang" /etc/passwd; then | |
| /usr/sbin/useradd -m -u 501 -g users -G wheel ywang | |
| else | |
| echo "==> User ywang exists" | |
| fi | |
| # Change password anyway | |
| echo ywang:marlo12 | chpasswd | |
| # Add us to the SUDOERS | |
| echo "oracle ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers | |
| echo "ywang ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers | |
| } | |
| function createDirStructureAndSetupScripts { | |
| if [ -e /etc/profile.d/custom.sh ]; then | |
| echo "==> File custom.sh exists" | |
| else | |
| # Not to add the following script because Docker container does not allow | |
| # changing limits. //Yang Wang | |
| #cp /vagrant/ora11gr2/custom.sh /etc/profile.d | |
| #chmod +x /etc/profile.d/custom.sh | |
| echo "==> Docker container does not allow changing limits. So not to add custom.sh" | |
| fi | |
| if [ ! -d $ORACLE_HOME ]; then | |
| mkdir -p $ORACLE_HOME | |
| fi | |
| chown -R $ORACLE_U_USER:$ORACLE_G_OINSTALL $ORACLE_DIR | |
| chmod -R 775 $ORACLE_DIR | |
| if ! grep "ORACLE_BASE" /home/oracle/.bash_profile >/dev/null 2>&1; then | |
| echo "==> Set up user oracle environment profile" | |
| cat >> /home/oracle/.bash_profile << EOF | |
| TMP=/tmp; export TMP | |
| TMPDIR=$TMP; export TMPDIR | |
| ORACLE_HOSTNAME=$ORACLE_HOST_NAME; export ORACLE_HOSTNAME | |
| ORACLE_UNQNAME=develop; export ORACLE_UNQNAME | |
| ORACLE_BASE=$ORACLE_DIR/oracle; export ORACLE_BASE | |
| ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME | |
| ORACLE_SID=develop; export ORACLE_SID | |
| PATH=/usr/sbin:$PATH; export PATH | |
| PATH=$ORACLE_HOME/bin:$PATH; export PATH | |
| LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH | |
| CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH | |
| EOF | |
| else | |
| echo "==> Profile /home/oracle/.bash_profile already configured" | |
| fi | |
| if ! grep "JAVA_HOME" /home/oracle/.bash_profile >/dev/null 2>&1; then | |
| echo "==> Set up user oracle Java environment profile" | |
| cat $JAVA_HOME/java_env.sh >> /home/oracle/.bash_profile | |
| fi | |
| } | |
| function installJava { | |
| if [ -d $JAVA_HOME ]; then | |
| echo "==> Java alrady installed under $JAVA_HOME" | |
| return | |
| fi | |
| cp $ORACLE_SW_DIR/$JAVA_SW_NAME /opt | |
| cd /opt | |
| tar xzf $JAVA_SW_NAME | |
| chown -R root:root $JAVA_HOME | |
| alternatives --install /usr/bin/java java /opt/jdk1.7.0_65/bin/java 1 | |
| echo 1 | alternatives --config java | |
| alternatives --install /usr/bin/jar jar /opt/jdk1.7.0_65/bin/jar 1 | |
| alternatives --install /usr/bin/javac javac /opt/jdk1.7.0_65/bin/javac 1 | |
| alternatives --set jar /opt/jdk1.7.0_65/bin/jar | |
| alternatives --set javac /opt/jdk1.7.0_65/bin/javac | |
| echo "# Setup JAVA environments" >> $JAVA_HOME/java_env.sh | |
| echo "export JAVA_HOME=/opt/jdk1.7.0_65" >> $JAVA_HOME/java_env.sh | |
| echo "export JRE_HOME=/opt/jdk1.7.0_65/jre" >> $JAVA_HOME/java_env.sh | |
| echo "export PATH=\$PATH:/opt/jdk1.7.0_65/bin:/opt/jdk1.7.0_65/jre/bin" >> $JAVA_HOME/java_env.sh | |
| java -version | |
| rm /opt/$JAVA_SW_NAME | |
| } | |
| function installNeededPackagesForOracle { | |
| # Not used because I'm using Oracle PreInstall package. Save for later usage if needed. | |
| # Run this function if Oracle PreInstall Package does not work. //Yang Wang | |
| yum -y install binutils compat-db gcc gcc-c++ glibc unixODBC \ | |
| compat-libstdc++-33-3.2.3 elfutils-libelf-devel \ | |
| glibc-common libstdc++ libstdc++-devel gnome-libs make \ | |
| pdksh sysstat libaio libaio-devel xscreensaver openmotif21 xorg-x11-xfs \ | |
| usbutils urw-fonts shared-mime-info perl-libwww-perl \ | |
| perl-XML-Parser perl-URI perl-HTML-Tagset perl-HTML-Parser \ | |
| patch lvm2 intltool libIDL libart_lgpl libbonobo xterm \ | |
| libcap libcroco libgnomecanvas libexif libgnomecups \ | |
| libgnomeprint22 libsoup libwnck libxklavier | |
| } | |
| function prepareOracleInstallResponse { | |
| parameters=( | |
| "<%ORACLE_BASE%>:$ORACLE_BASE" | |
| "<%ORACLE_HOME%>:$ORACLE_HOME" | |
| "<%ORACLE_INVENTORY%>:$ORACLE_INVENTORY" | |
| "<%ORACLE_PASSWORD%>:$ORACLE_PASSWORD" | |
| "<%ORACLE_OPTION%>:$ORACLE_OPTION" | |
| "<%ORACLE_LANGUAGE%>:$ORACLE_LANGUAGE" | |
| "<%ORACLE_CHARSET%>:$ORACLE_CHARSET" | |
| "<%ORACLE_EDITION%>:$ORACLE_EDITION" | |
| "<%ORACLE_HOSTNAME%>:$ORACLE_HOST_NAME" | |
| "<%ORACLE_SID%>:$ORACLE_SID" | |
| "<%ORACLE_DBNAME%>:$ORACLE_DBNAME" | |
| "<%ORACLE_U_USER%>:$ORACLE_U_USER" | |
| "<%ORACLE_U_PASSWORD%>:$ORACLE_U_PASSWORD" | |
| "<%ORACLE_G_OINSTALL%>:$ORACLE_G_OINSTALL" | |
| "<%ORACLE_G_DBA%>:$ORACLE_G_DBA") | |
| cp $ORACLE_RSP_INSTALL $ORACLE_INSTALL_DIR/db_install.rsp | |
| for e in "${parameters[@]}" ; do | |
| KEY=${e%%:*} | |
| VALUE=${e#*:} | |
| sed -ri 's|'$KEY'|'$VALUE'|g' $ORACLE_INSTALL_DIR/db_install.rsp | |
| done | |
| echo "==> Database installation response file prepared: $ORACLE_INSTALL_DIR/db_install.rsp" | |
| } | |
| function prepareTnsnamesSqlnet { | |
| parameters=( | |
| "<%ORACLE_HOSTNAME%>:$ORACLE_HOST_NAME" | |
| "<%ORACLE_SID%>:$ORACLE_SID") | |
| cp $ORACLE_T_TNSNAMES $ORACLE_INSTALL_DIR/tnsnames.ora | |
| cp $ORACLE_T_SQLNET $ORACLE_INSTALL_DIR/sqlnet.ora | |
| for e in "${parameters[@]}" ; do | |
| KEY=${e%%:*} | |
| VALUE=${e#*:} | |
| sed -ri 's|'$KEY'|'$VALUE'|g' $ORACLE_INSTALL_DIR/tnsnames.ora | |
| done | |
| if [ -e $ORACLE_TNSNAMES ]; then | |
| echo "Saved $ORACLE_TNSNAMES to ${ORACLE_TNSNAMES}.backup" | |
| su - $ORACLE_U_USER -c "cp $ORACLE_TNSNAMES ${ORACLE_TNSNAMES}.backup" | |
| fi | |
| if [ -e $ORACLE_SQLNET ]; then | |
| echo "Saved $ORACLE_SQLNET to ${ORACLE_SQLNET}.backup" | |
| su - $ORACLE_U_USER -c "cp $ORACLE_SQLNET ${ORACLE_SQLNET}.backup" | |
| fi | |
| su - $ORACLE_U_USER -c "cp $ORACLE_INSTALL_DIR/tnsnames.ora $ORACLE_TNSNAMES" | |
| su - $ORACLE_U_USER -c "cp $ORACLE_INSTALL_DIR/sqlnet.ora $ORACLE_SQLNET" | |
| echo "==> Oracle $ORACLE_TNSNAMES and $ORACLE_SQLNET have been created." | |
| } | |
| function installSqlDeveloper { | |
| rpm -Uhv $ORACLE_SW_DIR/sqldeveloper-4.0.2.15.21-1.noarch.rpm | |
| } | |
| # Usage: fn=lookForOracleLogFile | |
| # RETURN: "" = no log file | |
| # = log file name | |
| # | |
| # It waits for 50 seconds so that Oracle can have the time to write the log file | |
| # | |
| function lookForOracleLogFile { | |
| logdirs=( | |
| "$ORACLE_INVENTORY" | |
| "/tmp" | |
| ) | |
| cnt=0 | |
| while : | |
| do | |
| for dir in "${logdirs[@]}"; | |
| do | |
| if [ -d $dir ]; then | |
| # Looking for log file created within last 2 minutes | |
| fn=$(find $dir -type f -mmin -2 -name "installActions*log") | |
| if [[ $fn = *installActions* ]]; then | |
| echo "$fn" | |
| return 0 | |
| fi | |
| fi | |
| done | |
| let cnt=$cnt+1 | |
| if (( $cnt >= 10 )); then | |
| return 0 | |
| fi | |
| sleep 5 | |
| done | |
| return 1 | |
| } | |
| function installOracleDatabaseSoftware { | |
| if [[ -e $ORACLE_HOME/bin/dbca && -e $ORACLE_HOME/bin/netca ]]; then | |
| echo "==> Oracle has already been installed." | |
| return 0 | |
| fi | |
| swFile1="${ORACLE_SW_NAME}_1of2.zip" | |
| swFile2="${ORACLE_SW_NAME}_2of2.zip" | |
| if [[ -e $ORACLE_INSTALL_DIR/$swFile1 && -e $ORACLE_INSTALL_DIR/$swFile2 ]]; then | |
| echo "==> Files $swFile1 and $swFile2 exist in $ORACLE_INSTALL_DIR" | |
| else | |
| echo "==> Copying $swFile1 and $swFile2 to $ORACLE_INSTALL_DIR..." | |
| su - $ORACLE_U_USER -c "mkdir -p $ORACLE_INSTALL_DIR" | |
| su - $ORACLE_U_USER -c " \ | |
| cp $ORACLE_SW_DIR/$swFile1 $ORACLE_INSTALL_DIR; \ | |
| cp $ORACLE_SW_DIR/$swFile2 $ORACLE_INSTALL_DIR" | |
| fi | |
| if [ ! -d $ORACLE_INSTALL_DIR/database ]; then | |
| echo "==> Uncompressing $swFile1 and $swFile2..." | |
| su - $ORACLE_U_USER -c "cd $ORACLE_INSTALL_DIR; unzip $swFile1" >/dev/null 2>&1 | |
| su - $ORACLE_U_USER -c "cd $ORACLE_INSTALL_DIR; unzip $swFile2" >/dev/null 2>&1 | |
| fi | |
| prepareOracleInstallResponse | |
| echo "==> Now installing the Oracle database software..." | |
| # Add the code below to wait for the installation to complete | |
| # This is because runInstaller will spawn a process to install and exit immediately | |
| su - $ORACLE_U_USER -c "cd $ORACLE_INSTALL_DIR/database; \ | |
| $ORACLE_INSTALL_DIR/database/runInstaller \ | |
| -silent \ | |
| -force \ | |
| -noconfig \ | |
| -ignoreSysPrereqs \ | |
| -ignorePrereq \ | |
| -jreLoc /opt/jdk1.7.0_65/jre \ | |
| -responseFile $ORACLE_INSTALL_DIR/db_install.rsp" | |
| # Wait until the background installer finishes the work - either successful or failed | |
| # Wait until a log file is ready for being checked | |
| sleep 15 | |
| #LOGFILE=$(echo $ORACLE_INVENTORY/logs/$(ls -t $ORACLE_INVENTORY/logs/installAction*log | head -n 1)) | |
| LOGFILE=$(lookForOracleLogFile) | |
| echo "==> Oracle installation log file: $LOGFILE" | |
| grep -q 'INFO: Shutdown Oracle Database' $LOGFILE | |
| while [[ $? -ne 0 ]] ; do | |
| sleep 2 | |
| grep -q 'INFO: Shutdown Oracle Database' $LOGFILE | |
| done | |
| if [ -e $ORACLE_INVENTORY/orainstRoot.sh ]; then | |
| $ORACLE_INVENTORY/orainstRoot.sh | |
| fi | |
| if [ -e $ORACLE_HOME/root.sh ]; then | |
| $ORACLE_HOME/root.sh | |
| fi | |
| } | |
| function createDatabase { | |
| echo "==> Configuring listener..." | |
| su - $ORACLE_U_USER -c "netca -silent -responsefile $ORACLE_RSP_NETCA" | |
| echo "==> Status of the listener:" | |
| su - $ORACLE_U_USER -c "lsnrctl status LISTENER" | |
| echo "==> Creating database $ORACLE_SID..." | |
| su - $ORACLE_U_USER -c " | |
| dbca -silent \ | |
| -createDatabase \ | |
| -templateName General_Purpose.dbc \ | |
| -gdbName $ORACLE_DBNAME \ | |
| -sid $ORACLE_SID \ | |
| -sysPassword $ORACLE_PASSWORD \ | |
| -systemPassword $ORACLE_PASSWORD \ | |
| -sysmanPassword $ORACLE_PASSWORD \ | |
| -dbsnmpPassword $ORACLE_PASSWORD \ | |
| -emConfiguration LOCAL \ | |
| -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates \ | |
| -characterset $ORACLE_CHARSET \ | |
| -obfuscatedPasswords false \ | |
| -sampleSchema false \ | |
| -asmSysPassword $ORACLE_PASSWORD" | |
| echo "==> Database $ORACLE_SID created. Try to test it with 'sqlplus sys@develop AS SYSDBA'" | |
| } | |
| function configureOracleService { | |
| echo "==> Installing an Oracle service. Oracle service is stopped by default." | |
| cp $ORACLE_SERVICE_SCRIPT /etc/init.d/oracle | |
| chmod +x /etc/init.d/oracle | |
| chkconfig --add oracle | |
| chkconfig oracle off | |
| } | |
| function isOracleFunctioning { | |
| # Not being used yet. Saved for later reference. | |
| check_stat=`ps -ef|grep ${ORACLE_SID}|grep pmon|wc -l`; | |
| echo "$check_stat" | |
| oracle_num=`expr $check_stat` | |
| if [ $oracle_num -lt 1 ]; then | |
| return 1 | |
| fi | |
| # Test to see if Oracle is accepting connections | |
| cat >> /tmp/test_sql_$ORACLE_SID.sql << EOF | |
| select * from v\$database; | |
| exit | |
| EOF | |
| testresult=$(su - oracle -c "sqlplus sys/password1@developdb AS SYSDBA @/tmp/test_sql_$ORACLE_SID.sql") | |
| #sqlplus sys/password1@developdb AS SYSDBA @/tmp/sql.sql > /tmp/check_$ORACLE_SID.ora | |
| rm /tmp/test_sql_$ORACLE_SID.sql | |
| if [[ $testresult == *Connected* ]]; then | |
| return 0 # true | |
| else | |
| return 1 # false | |
| fi | |
| } | |
| #------------------------------------------------------ | |
| # Main program starts here | |
| #------------------------------------------------------ | |
| #user=`ps -o user= -p $$ | awk "{print $1}"` | |
| # | |
| # Better solution: get the current user name | |
| user=`id -nu` | |
| if [ "$user" == "root" ]; then | |
| echo "" | |
| echo "Beginning the installation of Oracle 11g R2" | |
| else | |
| echo "" | |
| echo "This install tool has to be executed by user root." | |
| echo "" | |
| exit 0 | |
| fi | |
| echo "" | |
| echo "==> Checking prerequisite environments..." | |
| echo "==> Checking sshd, etc..." | |
| if [ ! -d "/etc/ssh" ]; then | |
| echo "Installing packages openssh-server openssh-clients sudo passwd rsyslog..." | |
| installSSH | |
| fi | |
| echo "==> Installing Java $JAVA_SW_NAME..." | |
| installJava | |
| if [ ! -f "/etc/yum.repos.d/public-yum-ol6.repo" ]; | |
| then | |
| echo "Installing Oracle Public YUM Repository" | |
| cd /etc/yum.repos.d | |
| wget http://public-yum.oracle.com/public-yum-ol6.repo | |
| wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle | |
| cd | |
| fi | |
| echo "Preparing users oracle, ywang, group oinstall, dba. User ywang and oracle will \ | |
| be able to sudo. Default password for both ywang and oracle will be marlo12. \ | |
| We do this first so that we can use our preferred user and group IDs" | |
| addGroupAndUser | |
| oraclePreinstall="oracle-rdbms-server-11gR2-preinstall.x86_64" | |
| if ! isInstalled $oraclePreinstall; then | |
| echo "Installing $oraclePreinstall ..." | |
| yum -y install oracle-rdbms-server-11gR2-preinstall.x86_64 | |
| # Reconfigure SSH because Oracle Preinstall will add some value to pam.d/*. | |
| configureSSH | |
| else | |
| echo "$oraclePreinstall already installed." | |
| fi | |
| createDirStructureAndSetupScripts | |
| savedDISPLAY=$DISPLAY | |
| unset DISPLAY | |
| installOracleDatabaseSoftware | |
| DISPLAY=$savedDISPLAY | |
| export DISPLAY | |
| if [[ -e $ORACLE_HOME/bin/dbca && -e $ORACLE_HOME/bin/netca ]]; then | |
| createDatabase | |
| configureOracleService | |
| fi | |
| if [[ -e $ORACLE_HOME/bin/dbca && -e $ORACLE_HOME/bin/netca ]]; then | |
| prepareTnsnamesSqlnet | |
| echo "==> Oracle database has been installed successfully!" | |
| echo "==> Now shut down Oracle ..." | |
| su - $ORACLE_U_USER -c "$ORACLE_HOME/bin/lsnrctl stop" | |
| su - $ORACLE_U_USER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" | |
| su - $ORACLE_U_USER -c "$ORACLE_HOME/bin/emctl stop dbconsole" | |
| rm -f /var/lock/subsys/oracle >/dev/null 2>&1 | |
| echo "--------------------------------------------------------------------------------------------" | |
| echo "IMPORTANT:" | |
| echo "Oracle will not be restarted automatically. So manually starting and shuting down are needed" | |
| echo "To start: service oracle start" | |
| echo "To shutdown: service oracle stop" | |
| echo "In case Oracle not being started correctly, check to make sure /etc/oratab has correct values" | |
| echo "including SID, Oracle Home Directory, and Y instead of N." | |
| echo "--------------------------------------------------------------------------------------------" | |
| else | |
| echo "==> !!!!!Failed to install Oracle database!!!!!" | |
| fi | |
| echo "==> TO DO: uncomment the following line to remove $ORACLE_INSTALL_DIR" | |
| rm -rf $ORACLE_INSTALL_DIR | |
| #------------------------------------------------------ | |
| # End of Program | |
| #------------------------------------------------------ | |
| echo "" | |
| echo "--------------------------------------------------------------------------------------------" | |
| echo "IMPORTANT:" | |
| echo "Oracle will not be restarted automatically. So manually starting and shuting down are needed" | |
| echo "To start: service oracle start" | |
| echo "To shutdown: service oracle stop" | |
| echo "In case Oracle not being started correctly, check to make sure /etc/oratab has correct values" | |
| echo "including SID, Oracle Home Directory, and Y instead of N." | |
| echo "--------------------------------------------------------------------------------------------" | |
| echo "" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # /etc/security/limits.conf | |
| # | |
| #Each line describes a limit for a user in the form: | |
| # | |
| #<domain> <type> <item> <value> | |
| # | |
| #Where: | |
| #<domain> can be: | |
| # - an user name | |
| # - a group name, with @group syntax | |
| # - the wildcard *, for default entry | |
| # - the wildcard %, can be also used with %group syntax, | |
| # for maxlogin limit | |
| # | |
| #<type> can have the two values: | |
| # - "soft" for enforcing the soft limits | |
| # - "hard" for enforcing hard limits | |
| # | |
| #<item> can be one of the following: | |
| # - core - limits the core file size (KB) | |
| # - data - max data size (KB) | |
| # - fsize - maximum filesize (KB) | |
| # - memlock - max locked-in-memory address space (KB) | |
| # - nofile - max number of open files | |
| # - rss - max resident set size (KB) | |
| # - stack - max stack size (KB) | |
| # - cpu - max CPU time (MIN) | |
| # - nproc - max number of processes | |
| # - as - address space limit (KB) | |
| # - maxlogins - max number of logins for this user | |
| # - maxsyslogins - max number of logins on the system | |
| # - priority - the priority to run user process with | |
| # - locks - max number of file locks the user can hold | |
| # - sigpending - max number of pending signals | |
| # - msgqueue - max memory used by POSIX message queues (bytes) | |
| # - nice - max nice priority allowed to raise to values: [-20, 19] | |
| # - rtprio - max realtime priority | |
| # | |
| #<domain> <type> <item> <value> | |
| # | |
| #* soft core 0 | |
| #* hard rss 10000 | |
| #@student hard nproc 20 | |
| #@faculty soft nproc 20 | |
| #@faculty hard nproc 50 | |
| #ftp hard nproc 0 | |
| #@student - maxlogins 4 | |
| # Added the following for Oracle 11g R2 by Yang Wang | |
| oracle soft nproc 2047 | |
| oracle hard nproc 16384 | |
| oracle soft nofile 1024 | |
| oracle hard nofile 65536 | |
| oracle hard stack 10240 | |
| # End of file |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ORACLE_DIR=/opt/app | |
| ORACLE_BASE=$ORACLE_DIR/oracle | |
| ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 | |
| ORACLE_INVENTORY=$ORACLE_DIR/oraInventory | |
| ORACLE_PASSWORD=password1 # for both dba and sys | |
| ORACLE_OPTION=INSTALL_DB_SWONLY | |
| ORACLE_LANGUAGE=en | |
| ORACLE_CHARSET=WE8ISO8859P15 | |
| ORACLE_EDITION=EE | |
| ORACLE_HOST_NAME=`hostname -s` | |
| ORACLE_SID=develop | |
| ORACLE_DBNAME=develop | |
| ORACLE_U_USER=oracle | |
| ORACLE_U_PASSWORD=marlo12 | |
| ORACLE_G_OINSTALL=oinstall | |
| ORACLE_G_DBA=dba | |
| ORACLE_INSTALL_DIR=$ORACLE_DIR/install | |
| ORACLE_SW_NAME=linux.x64_11gR2_database | |
| ORACLE_SW_DIR=/opt/init.d/software | |
| ORACLE_RSP_DIR=/opt/init.d/ora11gr2 | |
| JAVA_SW_NAME=jdk-7u65-linux-x64.tar.gz | |
| ORACLE_RSP_INSTALL=$ORACLE_RSP_DIR/template_11gR2_db_install.rsp | |
| ORACLE_RSP_NETCA=$ORACLE_RSP_DIR/template_11gR2_netca.rsp | |
| ORACLE_RSP_DBCA=$ORACLE_RSP_DIR/template_11gR2_dbca.rsp | |
| ORACLE_T_TNSNAMES=$ORACLE_RSP_DIR/template_tnsnames.ora | |
| ORACLE_T_SQLNET=$ORACLE_RSP_DIR/template_sqlnet.ora | |
| ORACLE_TNSNAMES=$ORACLE_HOME/network/admin/tnsnames.ora | |
| ORACLE_SQLNET=$ORACLE_HOME/network/admin/sqlnet.ora | |
| ORACLE_SERVICE_SCRIPT=$ORACLE_RSP_DIR/service_oracle.sh | |
| SYSTEM_U_USER=ywang | |
| SYSTEM_U_PASSWORD=marlo12 | |
| JAVA_HOME=/opt/jdk1.7.0_65 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # oracle: Start/Stop Oracle Database 11g R2 | |
| # | |
| # chkconfig: 345 90 10 | |
| # description: The Oracle Database Server is an RDBMS created by Oracle Corporation | |
| # | |
| # processname: oracle | |
| # | |
| # 1. save this file to /etc/init.d | |
| # 2. add it to services: sudo chkconfig --add service_oracle.sh | |
| # | |
| . /etc/rc.d/init.d/functions | |
| LOCKFILE=/var/lock/subsys/oracle | |
| ORACLE_DIR=/opt/app | |
| ORACLE_BASE=$ORACLE_DIR/oracle | |
| ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 | |
| ORACLE_INVENTORY=$ORACLE_BASE/oraInventory | |
| ORACLE_USER=oracle | |
| case "$1" in | |
| 'start') | |
| if [ -f $LOCKFILE ]; then | |
| echo $0 already running. | |
| exit 1 | |
| fi | |
| echo -n $"Starting Oracle Database:" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl start" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl start dbconsole" | |
| touch $LOCKFILE | |
| ;; | |
| 'stop') | |
| if [ ! -f $LOCKFILE ]; then | |
| echo $0 already stopping. | |
| exit 1 | |
| fi | |
| echo -n $"Stopping Oracle Database:" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl stop" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" | |
| su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl stop dbconsole" | |
| rm -f $LOCKFILE | |
| ;; | |
| 'restart') | |
| $0 stop | |
| $0 start | |
| ;; | |
| 'status') | |
| if [ -f $LOCKFILE ]; then | |
| echo $0 started. | |
| else | |
| echo $0 stopped. | |
| fi | |
| ;; | |
| *) | |
| echo "Usage: $0 [start|stop|status]" | |
| exit 1 | |
| esac | |
| exit 0 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Kernel sysctl configuration file for Red Hat Linux | |
| # | |
| # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and | |
| # sysctl.conf(5) for more details. | |
| # Controls IP packet forwarding | |
| net.ipv4.ip_forward = 0 | |
| # Controls source route verification | |
| net.ipv4.conf.default.rp_filter = 1 | |
| # Do not accept source routing | |
| net.ipv4.conf.default.accept_source_route = 0 | |
| # Controls the System Request debugging functionality of the kernel | |
| kernel.sysrq = 0 | |
| # Controls whether core dumps will append the PID to the core filename. | |
| # Useful for debugging multi-threaded applications. | |
| kernel.core_uses_pid = 1 | |
| # Controls the use of TCP syncookies | |
| net.ipv4.tcp_syncookies = 1 | |
| # Disable netfilter on bridges. | |
| net.bridge.bridge-nf-call-ip6tables = 0 | |
| net.bridge.bridge-nf-call-iptables = 0 | |
| net.bridge.bridge-nf-call-arptables = 0 | |
| # Controls the default maxmimum size of a mesage queue | |
| kernel.msgmnb = 65536 | |
| # Controls the maximum size of a message, in bytes | |
| kernel.msgmax = 65536 | |
| # Controls the maximum shared segment size, in bytes | |
| kernel.shmmax = 68719476736 | |
| # Controls the maximum number of shared memory segments, in pages | |
| kernel.shmall = 4294967296 | |
| # Added for Oracle | |
| fs.aio-max-nr = 1048576 | |
| fs.file-max = 6815744 | |
| kernel.shmmni = 4096 | |
| 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 = 1048576 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #------------------------------------------------------------------------------- | |
| # Do not change the following system generated value. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 | |
| #------------------------------------------------------------------------------- | |
| # The installation option can be one of the following | |
| # 1. INSTALL_DB_SWONLY | |
| # 2. INSTALL_DB_AND_CONFIG | |
| # 3. UPGRADE_DB | |
| #------------------------------------------------------------------------------- | |
| oracle.install.option=<%ORACLE_OPTION%> | |
| #------------------------------------------------------------------------------- | |
| # This variable holds the hostname of the system as set by the user. | |
| # 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=<%ORACLE_HOSTNAME%> | |
| #------------------------------------------------------------------------------- | |
| # Unix group to be set for the inventory directory. | |
| #------------------------------------------------------------------------------- | |
| UNIX_GROUP_NAME=<%ORACLE_G_OINSTALL%> | |
| #------------------------------------------------------------------------------- | |
| # Inventory location. | |
| #------------------------------------------------------------------------------- | |
| INVENTORY_LOCATION=<%ORACLE_INVENTORY%> | |
| #------------------------------------------------------------------------------- | |
| # 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 | |
| # | |
| # Example : SELECTED_LANGUAGES=en,fr,ja | |
| #------------------------------------------------------------------------------- | |
| SELECTED_LANGUAGES=<%ORACLE_LANGUAGE%> | |
| #------------------------------------------------------------------------------- | |
| # Complete path of the Oracle Home | |
| #------------------------------------------------------------------------------- | |
| ORACLE_HOME=<%ORACLE_HOME%> | |
| #------------------------------------------------------------------------------- | |
| # Complete path of the Oracle Base. | |
| #------------------------------------------------------------------------------- | |
| ORACLE_BASE=<%ORACLE_BASE%> | |
| #------------------------------------------------------------------------------- | |
| # 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=<%ORACLE_EDITION%> | |
| #------------------------------------------------------------------------------- | |
| # This property is considered only if InstallEdition is EE. | |
| # | |
| # true : Components mentioned as part of 'customComponents' property | |
| # are considered for install. | |
| # false : Value for 'customComponents' is not considered. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.isCustomInstall=false | |
| #------------------------------------------------------------------------------- | |
| # This property is considered only if 'IsCustomInstall' is set to true | |
| # | |
| # Description: List of Enterprise Edition Options you would like to install. | |
| # | |
| # The following choices are available. You may specify any | |
| # combination of these choices. The components you choose should | |
| # be specified in the form "internal-component-name:version" | |
| # Below is a list of components you may specify to install. | |
| # | |
| # oracle.oraolap:11.2.0.0.2 - Oracle OLAP | |
| # oracle.rdbms.dm:11.2.0.0.2 - Oracle Data Mining RDBMS Files | |
| # oracle.rdbms.dv:11.2.0.0.2 - Oracle Database Vault option | |
| # oracle.rdbms.lbac:11.2.0.0.2 - Oracle Label Security | |
| # oracle.rdbms.partitioning:11.2.0.0.2 - Oracle Partitioning | |
| # oracle.rdbms.rat:11.2.0.0.2 - Oracle Real Application Testing | |
| # oracle.clrintg.ode_net:11.2.0.0.2 - Oracle Database Extensions for .NET 1.x (Windows) | |
| # oracle.clrintg.ode_net_2:11.2.0.0.2 - Oracle Database Extensions for .NET 2.0 (Windows) | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.customComponents= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.DBA_GROUP=<%ORACLE_G_DBA%> | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.OPER_GROUP=oper | |
| #------------------------------------------------------------------------------- | |
| # This variable represents the cluster node names selected by the . | |
| # user for installation | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.CLUSTER_NODES= | |
| #------------------------------------------------------------------------------- | |
| # One of the following | |
| # - GENERAL_PURPOSE | |
| # - TRANSACTION_PROCESSING | |
| # - DATAWAREHOUSE | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.type=GENERAL_PURPOSE | |
| #------------------------------------------------------------------------------- | |
| # Global Database Name | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.globalDBName= | |
| #------------------------------------------------------------------------------- | |
| # The Starter Database SID | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.SID= | |
| #------------------------------------------------------------------------------- | |
| # 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=<%ORACLE_CHARSET%> | |
| #------------------------------------------------------------------------------- | |
| # Specify the total memory allocation for the database. (in MB) | |
| # Value 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=40 | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.memoryLimit= | |
| oracle.install.db.config.starterdb.memoryOption=false | |
| #------------------------------------------------------------------------------- | |
| # This variable controls whether to load Example Schemas onto | |
| # the starter database or not. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.installExampleSchemas=false | |
| #------------------------------------------------------------------------------- | |
| # This include enabling audit settings, configuring password | |
| # profiles and revoking some grants to public. These settings | |
| # are provided by default. You may choose to disable all. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.enableSecuritySettings=true | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.password.ALL= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.password.SYS= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.password.SYSTEM= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.password.SYSMAN= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.password.DBSNMP= | |
| #------------------------------------------------------------------------------- | |
| # Can be one of the following | |
| # 1. GRID_CONTROL | |
| # 2. DB_CONTROL | |
| # | |
| oracle.install.db.config.starterdb.control=DB_CONTROL | |
| #------------------------------------------------------------------------------- | |
| # Determines the Management Service to use if Grid Control | |
| # is selected to manage the database. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= | |
| #------------------------------------------------------------------------------- | |
| # Determines whether to receive email notification for | |
| # critical alerts when using DB control. | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.dbcontrol.emailAddress= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.dbcontrol.SMTPServer= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.automatedBackup.enable=false | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.automatedBackup.osuid= | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.automatedBackup.ospwd= | |
| #------------------------------------------------------------------------------- | |
| # Can be one of the following | |
| # - FILE_SYSTEM_STORAGE | |
| # - ASM_STORAGE | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.storageType= | |
| #------------------------------------------------------------------------------- | |
| # Database file location: | |
| # 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= | |
| #------------------------------------------------------------------------------- | |
| # Backup and recovery location | |
| # | |
| # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= | |
| #------------------------------------------------------------------------------- | |
| # Name of ASM disk group to be used for storage. | |
| # | |
| # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE | |
| #------------------------------------------------------------------------------- | |
| oracle.install.db.config.asm.diskGroup= | |
| #------------------------------------------------------------------------------- | |
| # 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=metalink | |
| #------------------------------------------------------------------------------ | |
| MYORACLESUPPORT_USERNAME= | |
| #------------------------------------------------------------------------------ | |
| # Specify the My Oracle Support Account Username password. | |
| # | |
| # Example : MYORACLESUPPORT_PASSWORD=password | |
| #------------------------------------------------------------------------------ | |
| MYORACLESUPPORT_PASSWORD= | |
| #------------------------------------------------------------------------------ | |
| # 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=false | |
| #------------------------------------------------------------------------------ | |
| # Specify whether user wants to give any proxy details for connection. | |
| # 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= |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ############################################################################## | |
| ## ## | |
| ## DBCA response file ## | |
| ## ------------------ ## | |
| ## Copyright 1998, 2007, 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 : "<value>" ## | |
| ## Boolean : True or False ## | |
| ## Number : <numeric value> ## | |
| ## StringList : {"<value1>","<value2>"} ## | |
| ## ## | |
| ## Examples : ## | |
| ## 1. dbca -progress_only -responseFile <response file> ## | |
| ## Display a progress bar depicting progress of database creation ## | |
| ## process. ## | |
| ## ## | |
| ## 2. dbca -silent -responseFile <response file> ## | |
| ## Creates database silently. No user interface is displayed. ## | |
| ## ## | |
| ## 3. dbca -silent -createDatabase -cloneTemplate ## | |
| ## -responseFile <response file> ## | |
| ## Creates database silently with clone template. The template in ## | |
| ## responsefile is a clone template. ## | |
| ## ## | |
| ## 4. dbca -silent -deleteDatabase -responseFile <response file> ## | |
| ## 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 : "11.1.0" | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| RESPONSEFILE_VERSION = "11.2.0" | |
| #----------------------------------------------------------------------------- | |
| # Name : OPERATION_TYPE | |
| # Datatype : String | |
| # Description : Type of operation | |
| # Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) | |
| # 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 : <db_name>.<db_domain> - when database domain isn't NULL | |
| # <db_name> - when database domain is NULL | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| GDBNAME = "orcl11g.us.oracle.com" | |
| #----------------------------------------------------------------------------- | |
| # 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 : 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 : 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 : SID | |
| # Datatype : String | |
| # Description : System identifier (SID) of the database | |
| # Valid values : Check Oracle11g Administrator's Guide | |
| # Default value : <db_name> specified in GDBNAME | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| SID = "<%ORACLE_SID%>" | |
| #----------------------------------------------------------------------------- | |
| # 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 Oracle11g Administrator's Guide | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| #SYSPASSWORD = "password" | |
| #----------------------------------------------------------------------------- | |
| # Name : SYSTEMPASSWORD | |
| # Datatype : String | |
| # Description : Password for SYSTEM user | |
| # Valid values : Check Oracle11g Administrator's Guide | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| #SYSTEMPASSWORD = "password" | |
| #----------------------------------------------------------------------------- | |
| # Name : EMCONFIGURATION | |
| # Datatype : String | |
| # Description : Enterprise Manager Configuration Type | |
| # Valid values : CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE | |
| # Default value : NONE | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #EMCONFIGURATION = "NONE" | |
| #----------------------------------------------------------------------------- | |
| # Name : DISABLESECURITYCONFIGURATION | |
| # Datatype : String | |
| # Description : Database Security Settings | |
| # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE | |
| # Default value : NONE | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #DISABLESECURITYCONFIGURATION = "NONE" | |
| #----------------------------------------------------------------------------- | |
| # Name : SYSMANPASSWORD | |
| # Datatype : String | |
| # Description : Password for SYSMAN user | |
| # Valid values : Check Oracle11g 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 Oracle11g 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 or NOEMAIL are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #HOSTUSERNAME = | |
| #----------------------------------------------------------------------------- | |
| # Name : HOSTUSERPASSWORD | |
| # Datatype : String | |
| # Description : Host user password for EM backup job | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOEMAIL are 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 or NOEMAIL are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #BACKUPSCHEDULE= | |
| #----------------------------------------------------------------------------- | |
| # Name : SMTPSERVER | |
| # Datatype : String | |
| # Description : Outgoing mail (SMTP) server for email notifications | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #SMTPSERVER = | |
| #----------------------------------------------------------------------------- | |
| # Name : EMAILADDRESS | |
| # Datatype : String | |
| # Description : Email address for email notifications | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #EMAILADDRESS = | |
| #----------------------------------------------------------------------------- | |
| # Name : DVOWNERNAME | |
| # Datatype : String | |
| # Description : DataVault Owner | |
| # Valid values : Check Oracle11g 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 Oracle11g 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 Oracle11g Administrator's Guide | |
| # Default value : None | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #DVACCOUNTMANAGERNAME = "" | |
| #----------------------------------------------------------------------------- | |
| # Name : DVACCOUNTMANAGERPASSWORD | |
| # Datatype : String | |
| # Description : Password for DataVault Account Manager | |
| # Valid values : Check Oracle11g Administrator's Guide | |
| # Default value : None | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #DVACCOUNTMANAGERPASSWORD = "" | |
| #----------------------------------------------------------------------------- | |
| # 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 Oracle11g 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 Oracle11g 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 <variable>=<value>. 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 : 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 <host>:<port>:<sid> | |
| # 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 : <db_name>.<db_domain> - when database domain isn't NULL | |
| # <db_name> - when database domain is NULL | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| GDBNAME = "orcl11.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 : DISABLESECURITYCONFIGURATION | |
| # Datatype : String | |
| # Description : Database Security Settings | |
| # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE | |
| # Default value : NONE | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #DISABLESECURITYCONFIGURATION = "NONE" | |
| #----------------------------------------------------------------------------- | |
| # 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|NOBACKUP|NOEMAIL|NONE | |
| # Default value : NONE | |
| # Mandatory : No | |
| #----------------------------------------------------------------------------- | |
| #EMCONFIGURATION = "NONE" | |
| #----------------------------------------------------------------------------- | |
| # Name : SYSMANPASSWORD | |
| # Datatype : String | |
| # Description : Password for SYSMAN user | |
| # Valid values : Check Oracle11g 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 Oracle11g 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 or NOEMAIL are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #HOSTUSERNAME = | |
| #----------------------------------------------------------------------------- | |
| # Name : HOSTUSERPASSWORD | |
| # Datatype : String | |
| # Description : Host user password for EM backup job | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOEMAIL are 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 or NOEMAIL are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #BACKUPSCHEDULE= | |
| #----------------------------------------------------------------------------- | |
| # Name : SMTPSERVER | |
| # Datatype : String | |
| # Description : Outgoing mail (SMTP) server for email notifications | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #SMTPSERVER = | |
| #----------------------------------------------------------------------------- | |
| # Name : EMAILADDRESS | |
| # Datatype : String | |
| # Description : Email address for email notifications | |
| # Default value : None | |
| # Mandatory : Yes, if ALL or NOBACKUP are specified for EMCONFIGURATION | |
| #----------------------------------------------------------------------------- | |
| #EMAILADDRESS = | |
| #-----------------------*** 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 : <db_unique_name> | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| DB_UNIQUE_NAME = "orcl11g.us.oracle.com" | |
| #----------------------------------------------------------------------------- | |
| # Name : INSTANCENAME | |
| # Datatype : String | |
| # Description : RAC instance name to be added | |
| # Valid values : Check Oracle11g Administrator's Guide | |
| # Default value : <sid_prefix>+<highest_current_thread+1> | |
| # 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" | |
| #-----------------------*** 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 : <db_unique_name> | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| DB_UNIQUE_NAME = "orcl11g.us.oracle.com" | |
| #----------------------------------------------------------------------------- | |
| # Name : INSTANCENAME | |
| # Datatype : String | |
| # Description : RAC instance name to be deleted | |
| # Valid values : Check Oracle11g Administrator's Guide | |
| # Default value : None | |
| # Mandatory : Yes | |
| #----------------------------------------------------------------------------- | |
| INSTANCENAME = "orcl11g" | |
| #----------------------------------------------------------------------------- | |
| # 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 ***------------------------ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ############################################################### | |
| ## Copyright(c) Oracle Corporation 2002. 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 Oracle11g ## | |
| ## server which is similar to what would be created by the ## | |
| ## NetCA during typical Oracle11g install. It also documents ## | |
| ## all of the NetCA response files variables so you can ## | |
| ## create your own response file to configure Oracle Net ## | |
| ## during an install the way you wish. ## | |
| ## ## | |
| ############################################################### | |
| [GENERAL] | |
| RESPONSEFILE_VERSION="11.2" | |
| 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=""/oracle11gHome/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;Oracle11g database's service name | |
| # A typical install sets Oracle11g 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"} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| names.directory_path = (TNSNAMES) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <%ORACLE_SID%> = | |
| (DESCRIPTION = | |
| (ADDRESS = (PROTOCOL = TCP)(HOST = <%ORACLE_HOSTNAME%>)(PORT = 1521)) | |
| (CONNECT_DATA = | |
| (SERVER = DEDICATED) | |
| (SERVICE_NAME = <%ORACLE_SID%>) | |
| ) | |
| ) |
Thanks for the scripts, it would be better if there is some documentation about how to execute in steps , please do if possible , it helps a lot
I'm happy that it's useful.
Please see the README.md for details: https://github.com/wy8162/docker/blob/master/README.md .
Actually, it is simple: copy all the files from init.d\ora11gr2 to your machine; modify oracle_constants.sh, limits.conf.oracle if necessary and then run installoracle11gr2.sh. It should work.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
All files for installing Oracle 11gR2 silently.