Installing Oracle 12c in Silent mode

As i prepare for my oracle 12c upgrade… done some testing on oracle 12C.

 
./runInstaller oracle.install.option=INSTALL_DB_SWONLY \
    ORACLE_BASE=/opt/app/oracle \
    ORACLE_HOME=/opt/app/oracle/product/12.1.0.1/dbhome_1 \
    UNIX_GROUP_NAME=dba \
    oracle.install.db.DBA_GROUP=dba \
    oracle.install.db.OPER_GROUP=dba \
    oracle.install.db.BACKUPDBA_GROUP=dba \
    oracle.install.db.DGDBA_GROUP=dba \
    oracle.install.db.KMDBA_GROUP=dba \
    FROM_LOCATION=../stage/products.xml \
    INVENTORY_LOCATION=/opt/app/oracle/oraIventory \
    SELECTED_LANGUAGES=en \
    oracle.install.db.InstallEdition=EE \
    DECLINE_SECURITY_UPDATES=true  -silent -ignoreSysPrereqs -ignorePrereq -waitForCompletion

Continue reading

Advertisements

oracle 11.2.0.2 silent install

just another day at my work, my boss ask me to install a database software 11.2.0.2.
i don’t have the privilege of using GUI installer since the server reside in the other side of the world.
so decided to use silent install.

unlike with other version of oracle the 11.2.0.2 installer is different.
for 10.2

$ runInstaller -silent                                 \
      -responseFile $DISTRIB/response/enterprise.rsp   \
       ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1 \
       ORACLE_HOME_NAME=ORADB102_Home10                 \
       n_configurationOption=3

for 11.1

$ runInstaller -silent                                 \
      -responseFile $DISTRIB/response/enterprise.rsp   \
       FROM_LOCATION=$DISTRIB/stage/products.xml       \
       ORACLE_BASE=/opt/app/oracle                     \
       ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1 \
       ORACLE_HOME_NAME=ORADB111_Home1                 \
       n_configurationOption=3

but for 11.2.02

./runInstaller -silent \
-ignoreSysPrereqs \
-ignorePrereq \
-responseFile /backup/software/11gR2/database/response/db_install.rsp \
ORACLE_BASE=/opt/app/oracle \
ORACLE_HOME=/opt/app/oracle/product/11.2.0.2/db_1 \
ORACLE_HOME_NAME=OraDbHome11202 \
oracle.install.option=INSTALL_DB_SWONLY \
oracle.install.db.InstallEdition=EE \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
DECLINE_SECURITY_UPDATES=true \
'-ignoreInternalDriverError'

the installation….

lnxora01:pexb $ ./runInstaller -silent \
> -ignoreSysPrereqs \
> -ignorePrereq \
> 
> ORACLE_BASE=/opt/app/oracle \
> 
> ORACLE_HOME_NAME=OraDbHome11202 \
> oracle.install.option=INSTALL_DB_SWONLY \
> oracle.install.db.InstallEdition=EE \
> oracle.install.db.DBA_GROUP=dba \
> oracle.install.db.OPER_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
> DECLINE_SECURITY_UPDATES=true \
> '-ignoreInternalDriverError'
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 5604 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 17407 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-01-25_07-08-21AM. Please wait ...lnxora01:pexb $

the warning below shows up since my User home and ORACLE_BASE is same and can be ignored.

[WARNING] [INS-32008] Oracle base location cant be same as the user home directory.
   CAUSE: The specified Oracle base is same as the user home directory.
   ACTION: Provide an Oracle base location other than the user home directory.

You can find the log of this install session at:

/opt/app/oraInventory/logs/installActions2012-01-25_07-08-21AM.log

if you tailed the alert log…

 
INFO: Completed validating state 
INFO: Terminating all background operations
INFO: Terminated all background operations
INFO: Successfully executed the flow in SILENT mode
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is 0
INFO: Shutdown Oracle Database 11g Release 2 Installer
INFO: Unloading Setup Driver

now it’s time to execute the root.sh. for me need to wait until our UNIX admin arrives.

 
As a root user, execute the following script(s):
        1. /opt/app/oracle/product/11.2.0.2/db_1/root.sh

Successfully Setup Software.

thanks!

bai

silent install of 11.1.0.6 on Linux.

just another notes on silent install on linux.

To install the 11.1 database, and assuming you use the default oracle user, oinstall and dba groups, the variables you need to set are the following:
ORACLE_BASE defines the ORACLE_BASE value that is now mandatory with 11.1
ORACLE_HOME defines the location of the software you want to install;
ORACLE_HOME_NAME defines a name for the ORACLE_HOME and helps to avoid inadvertently deleting an ORACLE_HOME.

./runInstaller -silent \
-responseFile /dbTEST01/installer/database/response/enterprise.rsp \
FROM_LOCATION=/dbTEST01/installer/database/source/db/Disk1/stage/products.xml \
ORACLE_BASE=/opt/app/oracle                     \
ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1 \
ORACLE_HOME_NAME=ORADB111_Home1 \
n_configurationOption=3

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 8513 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1023 MB    Passed
Preparing to launch Oracle Universal Installer from /logs/silentInstall2011-11-08_12-01-06AM. Please wait ...[oracle@lnxdg02 database]$ Oracle Universal Installer, Version 11.1.0.6.0 Production
Copyright (C) 1999, 2007, Oracle. All rights reserved.

You can find the log of this install session at:
 /opt/app/oracle/oraInventory/logs/logs/silentInstall2011-11-08_12-01-06AM.log
.................................................................................................... 100% Done.


Loading Product Information
................................................................................................................ 100% Done.

Starting execution of Prerequisites...
Total No of checks: 14

Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of enterprise-4,enterprise-5,redhat-4,redhat-5,SuSE-10,asianux-2,asianux-3
Actual Result: redhat-5
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.81; found make-1:3.81-3.el5-x86_64. Passed
Checking for binutils-2.17.50.0.6; found binutils-2.17.50.0.6-14.el5-x86_64.    Passed
Checking for gcc-4.1.1; found gcc-4.1.2-48.el5-x86_64.  Passed
Checking for libaio-0.3.106-i386; found libaio-0.3.106-5-i386.  Passed
Checking for libaio-0.3.106-x86_64; found libaio-0.3.106-5-x86_64.      Passed
Checking for libaio-devel-0.3.106; found libaio-devel-0.3.106-5-i386.   Passed
Checking for libstdc++-4.1.1-i386; found libstdc++-4.1.2-48.el5-i386.   Passed
Checking for libstdc++-4.1.1-x86_64; found libstdc++-4.1.2-48.el5-x86_64.       Passed
Checking for libstdc++-devel-4.1.1; found libstdc++-devel-4.1.2-48.el5-x86_64.  Passed
Checking for sysstat-7.0.0; found sysstat-7.0.2-3.el5-x86_64.   Passed
Checking for libgcc-4.1.1-i386; found libgcc-4.1.2-48.el5-i386. Passed
Checking for libgcc-4.1.1-x86_64; found libgcc-4.1.2-48.el5-x86_64.     Passed
Checking for elfutils-libelf-0.125; found elfutils-libelf-0.137-3.el5-i386.     Passed
Checking for elfutils-libelf-devel-0.125; found elfutils-libelf-devel-0.137-3.el5-x86_64.       Passed
Checking for glibc-common-2.5; found glibc-common-2.5-49-x86_64.        Passed
Checking for glibc-devel-2.5-i386; found glibc-devel-2.5-49-i386.       Passed
Checking for glibc-devel-2.5-x86_64; found glibc-devel-2.5-49-x86_64.   Passed
Checking for gcc-c++-4.1.1; found gcc-c++-4.1.2-48.el5-x86_64.  Passed
Checking for compat-libstdc++-33-3.2.3-i386; found compat-libstdc++-33-3.2.3-61-i386.   Passed
Checking for compat-libstdc++-33-3.2.3-x86_64; found compat-libstdc++-33-3.2.3-61-x86_64.       Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.      Passed
Checking for semmns=32000; found semmns=32000.  Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for semmni=128; found semmni=128.      Passed
Checking for shmmax=536870912; found shmmax=536870912.  Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=2097152.      Passed
Checking for file-max=65536; found file-max=102696.     Passed
Checking for VERSION=2.6.18; found VERSION=2.6.18-194.el5.      Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=1024 - 65000.  Passed
Checking for rmem_default=4194304; found rmem_default=4194304.  Passed
Checking for rmem_max=4194304; found rmem_max=4194304.  Passed
Checking for wmem_default=262144; found wmem_default=262144.    Passed
Checking for wmem_max=262144; found wmem_max=262144.    Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: ATLEAST=2.5-12 
Actual Result: 2.5-49
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 496MB
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The system does not have sufficient physical memory to perform the install.
Recommendation: Increase the amount of physical memory available to your system before continuing with the installation.

========================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 992MB
Actual Result: 1012MB
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for DetectIfDHCPAssignedIP
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for CheckPathForOtherOracleHomes
Checking PATH environment variable...
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The installer has detected that the PATH environment variable includes other ORACLE_HOME locations in it.
Recommendation: Restart the installer after removing other ORACLE_HOME locations from PATH environment variable.

========================================================
Performing check for CheckTempDiskSpace
Checking for sufficient diskspace in TEMP location...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for CheckLdLibraryPath
Checking LD_LIBRARY_PATH environment variable...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for OracleBase
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for OracleHomeSpace
Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for DetectAnyInvalidASMHome
Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
Performing check for CompatibilityChecks_DB
Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed


Check complete: Passed
========================================================
PrereqChecks complete


Analyzing dependencies 
..................................................................................................... 100% Done.


-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /dbTEST01/installer/database/source/db/Disk1/stage/products.xml
    Oracle Base: /opt/app/oracle????????????????????????????????????????
    Oracle Home: /opt/app/oracle/product/11.1.0/db_1 (ORADB111_Home1)
    Installation Type: Enterprise Edition
Product Languages
   English
Space Requirements
   / Required 3.82GB (includes 226MB temporary) : Available 10.31GB
New Installations (126 products)
   Oracle Database 11g 11.1.0.6.0 
   Enterprise Edition Options 11.1.0.6.0 
   Oracle Partitioning 11.1.0.6.0 
   Oracle Spatial 11.1.0.6.0 
   Oracle OLAP 11.1.0.6.0 
   Oracle Database 11g 11.1.0.6.0 
   Oracle Text 11.1.0.6.0 
   Oracle Net Services 11.1.0.6.0 
   Oracle Enterprise Manager Console DB 11.1.0.5.0 
   Oracle Net Listener 11.1.0.6.0 
   HAS Files for DB 11.1.0.6.0 
   Oracle Call Interface (OCI) 11.1.0.6.0 
   Enterprise Manager Agent 10.2.0.3.1 
   Oracle Programmer 11.1.0.6.0 
   Oracle Database Gateway for ODBC 11.1.0.6.0 
   Oracle Advanced Security 11.1.0.6.0 
   Oracle JVM 11.1.0.6.0 
   Database Configuration and Upgrade Assistants 11.1.0.6.0 
   Oracle XML Development Kit 11.1.0.6.0 
   Generic Connectivity Common Files 11.1.0.6.0 
   Oracle Multimedia 11.1.0.6.0 
   Oracle Multimedia Locator 11.1.0.6.0 
   Oracle Internet Directory Client 11.1.0.6.0 
   Oracle Database Utilities 11.1.0.6.0 
   Secure Socket Layer 11.1.0.6.0 
   PL/SQL 11.1.0.6.0 
   Oracle Recovery Manager 11.1.0.6.0 
   Oracle Net 11.1.0.6.0 
   Oracle Notification Service 11.1.0.5.0 
   Assistant Common Files 11.1.0.6.0 
   Installation Common Files 11.1.0.6.0 
   Enterprise Manager plugin Common Files 11.1.0.5.0 
   Oracle LDAP administration 11.1.0.6.0 
   SQL*Plus 11.1.0.6.0 
   HAS Common Files 11.1.0.6.0 
   Oracle Help for the  Web 2.0.14.0.0 
   Oracle UIX 2.2.20.0.0 
   Precompiler Common Files 11.1.0.6.0 
   Oracle Clusterware RDBMS Files 11.1.0.6.0 
   Cluster Verification Utility Common Files 11.1.0.6.0 
   Oracle Wallet Manager 11.1.0.6.0 
   Oracle Security Developer Tools 11.1.0.6.0 
   XML Parser for Java 11.1.0.6.0 
   Enterprise Manager Minimal Integration 11.1.0.6.0 
   Oracle Database User Interface 2.2.13.0.0 
   SQL*Plus Files for Instant Client 11.1.0.6.0 
   Oracle ODBC Driver 11.1.0.6.0 
   Required Support Files 11.1.0.6.0 
   Database SQL Scripts 11.1.0.6.0 
   OLAP SQL Scripts 11.1.0.6.0 
   PL/SQL Embedded Gateway 11.1.0.6.0 
   Oracle Globalization Support 11.1.0.6.0 
   Character Set Migration Utility 11.1.0.6.0 
   Oracle Locale Builder 11.1.0.6.0 
   Secure Socket Layer 11.1.0.6.0 
   Oracle Java Client 11.1.0.6.0 
   Oracle JDBC/THIN Interfaces 11.1.0.6.0 
   Oracle Multimedia Client Option 11.1.0.6.0 
   Oracle Universal Connection Pool 11.1.0.6.0 
   Oracle Required Support Files 32 bit 11.1.0.6.0 
   Oracle Code Editor 1.2.1.0.0I 
   Oracle Ultra Search Server Rdbms 11.1.0.6.0 
   Oracle Help For Java 4.2.9.0.0 
   Oracle Containers for Java 11.1.0.6.0 
   JAccelerator (COMPANION) 11.1.0.6.0 
   Database Workspace Manager 11.1.0.6.0 
   SQLJ Runtime 11.1.0.6.0 
   Oracle Core Required Support Files 11.1.0.6.0 
   Platform Required Support Files 11.1.0.6.0 
   Oracle Ice Browser 5.2.3.6.0 
   Oracle Application Express 11.1.0.6.0 
   Oracle SQL Developer 11.1.0.6.0 
   Oracle JDBC Server Support Package 11.1.0.6.0 
   regexp 2.1.9.0.0 
   Enterprise Manager Common Files 10.2.0.3.1 
   Installation Plugin Files 11.1.0.6.0 
   Oracle JDBC/OCI Instant Client 11.1.0.6.0 
   XML Parser for Oracle JVM 11.1.0.6.0 
   Oracle XML Query 11.1.0.6.0 
   Oracle Message Gateway Common Files 11.1.0.6.0 
   Oracle Starter Database 11.1.0.6.0 
   Sample Schema Data 11.1.0.6.0 
   Precompiler Required Support Files 11.1.0.6.0 
   Parser Generator Required Support Files 11.1.0.6.0 
   Oracle Multimedia Locator RDBMS Files 11.1.0.6.0 
   Oracle Globalization Support 11.1.0.6.0 
   Oracle Multimedia Annotator 11.1.0.6.0 
   Oracle Multimedia Java Advanced Imaging 11.1.0.6.0 
   Oracle Database 11g Multimedia Files 11.1.0.6.0 
   Agent Required Support Files 10.2.0.3.1 
   Oracle 11g Warehouse Builder Server 11.1.0.6.0 
   Oracle Ultra Search Server 11.1.0.6.0 
   Oracle Ultra Search Middle-Tier 11.1.0.6.0 
   Oracle Ultra Search Common Files 11.1.0.6.0 
   Perl Interpreter 5.8.3.0.4 
   RDBMS Required Support Files 11.1.0.6.0 
   Oracle Display Fonts 9.0.2.0.0 
   RDBMS Required Support Files for Instant Client 11.1.0.6.0 
   Enterprise Manager Agent Core Files 10.2.0.3.1 
   Enterprise Manager Common Core Files 10.2.0.3.1 
   Enterprise Manager Grid Control Core Files 10.2.0.3.1 
   Enterprise Manager Database Plugin -- Agent Support 11.1.0.5.0 
   Enterprise Manager Database Plugin -- Management Service Support 11.1.0.5.0 
   Enterprise Manager Repository Core Files 10.2.0.3.1 
   Enterprise Manager Database Plugin -- Repository Support 11.1.0.5.0 
   Provisioning Advisor Framework 10.2.0.3.1 
   XDK Required Support Files 11.1.0.6.0 
   Oracle RAC Required Support Files-HAS 11.1.0.6.0 
   SQL*Plus Required Support Files 11.1.0.6.0 
   Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 
   Oracle Extended Windowing Toolkit 3.4.47.0.0 
   Oracle OLAP API 11.1.0.6.0 
   Oracle OLAP RDBMS Files 11.1.0.6.0 
   Oracle Data Mining RDBMS Files 11.1.0.6.0 
   Oracle Real Application Testing 11.1.0.6.0 
   Bali Share 1.1.18.0.0 
   Buildtools Common Files 11.1.0.6.0 
   Oracle Net Required Support Files 11.1.0.6.0 
   SSL Required Support Files for InstantClient 11.1.0.6.0 
   LDAP Required Support Files 11.1.0.6.0 
   Oracle ODBC Driverfor Instant Client 11.1.0.6.0 
   Oracle Configuration Manager 10.2.6.0.0 
   Oracle Universal Installer 11.1.0.6.0 
   Oracle One-Off Patch Installer 11.1.0.6.0 
   Oracle Ultra Search Server 11.1.0.6.0 
   Oracle Ultra Search Middle-Tier 11.1.0.6.0 
   Oracle Ultra Search Common Files 11.1.0.6.0 
   Perl Interpreter 5.8.3.0.4 
   RDBMS Required Support Files 11.1.0.6.0 
   Oracle Display Fonts 9.0.2.0.0 
   RDBMS Required Support Files for Instant Client 11.1.0.6.0 
   Enterprise Manager Agent Core Files 10.2.0.3.1 
   Enterprise Manager Common Core Files 10.2.0.3.1 
   Enterprise Manager Grid Control Core Files 10.2.0.3.1 
   Enterprise Manager Database Plugin -- Agent Support 11.1.0.5.0 
   Enterprise Manager Database Plugin -- Management Service Support 11.1.0.5.0 
   Enterprise Manager Repository Core Files 10.2.0.3.1 
   Enterprise Manager Database Plugin -- Repository Support 11.1.0.5.0 
   Provisioning Advisor Framework 10.2.0.3.1 
   XDK Required Support Files 11.1.0.6.0 
   Oracle RAC Required Support Files-HAS 11.1.0.6.0 
   SQL*Plus Required Support Files 11.1.0.6.0 
   Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 
   Oracle Extended Windowing Toolkit 3.4.47.0.0 
   Oracle OLAP API 11.1.0.6.0 
   Oracle OLAP RDBMS Files 11.1.0.6.0 
   Oracle Data Mining RDBMS Files 11.1.0.6.0 
   Oracle Real Application Testing 11.1.0.6.0 
   Bali Share 1.1.18.0.0 
   Buildtools Common Files 11.1.0.6.0 
   Oracle Net Required Support Files 11.1.0.6.0 
   SSL Required Support Files for InstantClient 11.1.0.6.0 
   LDAP Required Support Files 11.1.0.6.0 
   Oracle ODBC Driverfor Instant Client 11.1.0.6.0 
   Oracle Configuration Manager 10.2.6.0.0 
   Oracle Universal Installer 11.1.0.6.0 
   Oracle One-Off Patch Installer 11.1.0.6.0 
   Installer SDK Component 11.1.0.6.0 
   Sun JDK 1.5.0.11.0 
-----------------------------------------------------------------------------


Installation in progress (Tue Nov 08 00:01:33 SGT 2011)
...............................................................   6% Done.
...............................................................  12% Done.
...............................................................  19% Done.
...............................................................  25% Done.
...............................................................  31% Done.
...............................................................  38% Done.
...............................................................  44% Done.
...............................................................  51% Done.
...............................................................  57% Done.
...............................................................  63% Done.
...............................................................  70% Done.
...............................................................  76% Done.
...........................................                      81% Done.
Install successful

Linking in progress (Tue Nov 08 00:08:21 SGT 2011)
..                                                               81% Done.
Link successful

Setup in progress (Tue Nov 08 00:18:03 SGT 2011)
...................................                             100% Done.
Setup successful

End of install phases.(Tue Nov 08 00:18:39 SGT 2011)
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/opt/app/oracle/product/11.1.0/db_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts
    
The installation of Oracle Database 11g was successful.
Please check '/opt/app/oracle/oraInventory/logs/silentInstall2011-11-08_12-01-06AM.log' for more details.

Login as root and execute /opt/app/oracle/product/11.1.0/db_1/root.sh.

then your done.

thanks!
bai