Manually Install Oracle OEM agent 13c

I’m on the process of deploying Oracle Enterprise Manager 13c on my new company since there is no proper monitoring currently setup. though at server level they are using solarwind.

when i’m trying to deploy oracle agent linux using the gui, i got some weird error, so i decided to go manual installation. ‚ÄĒ>

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

Rename/Upgrade and Relocate EM 12C R3 repository Database

Last week i need to upgrade one of our database, a database for our EM 12C R3.
currently database is running on the same server as EM. and its name is TEST01 ūüôā

Current :
DB NAME : TEST01
Version : 11.1.0.7.15
Server : prodoem12c
Target :
DB NAME : POEMC
Version : 11.2.0.3.7
Server : lnx00xyz-poemc (its a VCS clustered server)

Continue reading

Unable to initialize Oracle call interface

Today i installed a new Oracle Software 11.2.0.3 on our existing production database running 11.1.0.7
the problem is so simple but sometime we forgot the basic things..

PROBLEM : Unable to start sqlplus after installing new ORACLE_HOME

Note : this is my 2nd ORACLE HOME
Continue reading

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

SEVERE:OUI-10133:Invalid staging area. There are no top level components for Linux available for installation in this staging area.

Encountered the error during silent install of 11.1.0.6 on linux.

./runInstaller -silent \
-responseFile /dbTEST01/installer/database/response/enterprise.rsp \
FROM_LOCATION=/dbTEST01/installer/database/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

ERROR:

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 10795 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1012 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-11-07_11-33-33PM. Please wait ...[oracle@lnxdg01 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/installActions2011-11-07_11-33-33PM.log
.................................................................................................... 100% Done.

SEVERE:OUI-10133:Invalid staging area. There are no top level components for Linux available for installation in this staging area.

to fix the problem i corrected the location of products.xml

FROM:

/dbTEST01/installer/database/stage/products.xml

TO:

/dbTEST01/installer/database/source/db/Disk1/stage/products.xml

after making the changes the installation went smoothly.

./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

thanks!

bai

Installing Oracle Database Software on Linux

Install Required Linux Packages for Oracle

i’ll be using CentOS 5.5 distro for this installation
cd /media/cdrom/CentOS
rpm -Uvh binutils-2.*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh libaio-0.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh make-3.*
rpm -Uvh unixODBC-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh elfutils-libelf-devel-0.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh unixODBC-devel-2.*
rpm -Uvh sysstat-7.*

Operating System Configuration
> kernel requirement for 11g is 2.6.18
root@localhost app]# uname -rm
2.6.18-194.el5 x86_64

>RAM minimum of 1G
root@localhost app]# cat /proc/meminfo | grep MemTotal
MemTotal:       509404 kB
[root@localhost app]# cat /proc/meminfo | grep SwapTotal
SwapTotal:     1048568 kB
If you have less than 1GB of memory (between your RAM and SWAP), you can add temporary swap space by creating a temporary swap file. This way you do not have to use a raw device or even more drastic, rebuild your system.
As root, make a file that will act as additional swap space, let’s say about 1000MB:
# dd if=/dev/zero of=tempswap bs=1k count=1000000
Now we should change the file permissions: ‚Ä®# chmod 600 tempswap
Finally we format the “partition” as swap and add it to the swap space: ‚Ä®# mke2fs tempswap‚Ä®# mkswap tempswap‚Ä®# swapon tempswap
[root@localhost app]#  dd if=/dev/zero of=tempswap bs=1k count=1000000
1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 9.16479 seconds, 112 MB/s
[root@localhost app]# chmod 600 tempswap
[root@localhost app]# mke2fs tempswap
mke2fs 1.39 (29-May-2006)
tempswap is not a block special device.
Proceed anyway? (y,n) y
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
125184 inodes, 250000 blocks
12500 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=260046848
8 block groups
32768 blocks per group, 32768 fragments per group
15648 inodes per group
Superblock backups stored on blocks:
    32768, 98304, 163840, 229376

Writing inode tables: done                            
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 35 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@localhost app]# mkswap tempswap
Setting up swapspace version 1, size = 1023995 kB
[root@localhost app]# swapon tempswap

> edit sysctl.conf
# +———————————————————+
# | KERNEL PARAMETERS FOR ORACLE                         |
# +———————————————————+
# | Configure the kernel parameters for all Oracle Linux    |
# | servers by setting shared memory and semaphores,        |
# | setting the maximum amount of file handles, setting the |
# | networking parameters, and finally setting the IP local |
# | port range.                                             |
# +———————————————————+

# +———————————————————+
# | SHARED MEMORY                                           |
# +———————————————————+
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152

# +———————————————————+
# | SEMAPHORES                                              |
# | ———-¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† |
# |                                                         |
# | SEMMSL_value  SEMMNS_value  SEMOPM_value  SEMMNI_value  |
# |                                                         |
# +———————————————————+
kernel.sem = 250 32000 100 128

# +———————————————————+
# | FILE HANDLES                                            |
# ———————————————————-+
fs.file-max = 102696

# +———————————————————+
# | LOCAL IP RANGE                                          |
# ———————————————————-+
net.ipv4.ip_local_port_range = 1024 65000

# +———————————————————+
# | NETWORKING                                              |
# ———————————————————-+
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

>configure oracle shell limits
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <<EOF
# Added for Oracle Shell Limits
session    required     /lib/security/pam_limits.so
session    required     pam_limits.so
EOF

Update the default shell startup file for the “oracle” UNIX account.

For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file by running the following command:
cat >> /etc/profile <<EOF
if [ \$USER = “oracle” ]; then
¬†¬†¬† if [ \$SHELL = “/bin/ksh” ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
    umask 022
fi
EOF
For the C shell (csh or tcsh), add the following lines to the /etc/csh.login file by running the following command:
cat >> /etc/csh.login <<EOF
if ( \$USER == “oracle” ) then
    limit maxproc 16384
    limit descriptors 65536
endif
EOF

Network Configuration
edit /etc/hosts
# that require network functionality will fail.
127.0.0.1            localhost.localdomain     localhost
172.16.130.130        lnxdg01.bai.com            lnxdg01

Create “oracle” User and Directories
> create group and oracle user
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asm
groupadd -g 506 asmdba
useradd -m -u 501 -g oinstall -G dba,oper,asm -d /home/oracle -s /bin/bash -c “Oracle Software Owner” oracle
id oracle

> check nobody id
[root@localhost tmp]# id nobody
uid=99(nobody) gid=99(nobody) groups=99(nobody)

> create oracle base directory
mkdir -p /opt/app/oracle
chown -R oracle:oinstall /opt/app
chmod -R 775 /opt/app

>configure oracle user
edit bash profile.
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

alias ls=”ls -FA”
alias s=”screen -DRRS iPad -t iPad”

export JAVA_HOME=/usr/local/java

# User specific environment and startup programs
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_PATH=$ORACLE_BASE/dba_scripts/common/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_SID=TESTDB

export PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/dba_scripts/common/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS”
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
Disk Configuration

[root@localhost oracle]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won’t be recoverable.

The number of cylinders for this disk is set to 2610.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e   extended
p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-2610, default 2610):
Using default value 2610

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@localhost oracle]# mkfs.ext3 -b 4096 /dev/sdb1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
2621440 inodes, 5241198 blocks
262059 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
160 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000

Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 34 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@localhost oracle]# mkdir /u01
[root@localhost oracle]# echo “/dev/sdb1¬†¬† /u01¬†¬† ext3¬†¬† defaults¬†¬† 1 1” >> /etc/fstab
[root@localhost oracle]# mount /u01
[root@localhost oracle]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       19G  3.8G   14G  22% /
/dev/sda1              99M   13M   82M  14% /boot
tmpfs                 249M     0  249M   0% /dev/shm
/dev/sdb1              20G  173M   19G   1% /u01

Download the Oracle Database Software

go to otn.oracle.com and download the software.

Install the Oracle Database Software

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.

n_configurationOption defines if you want to configure ASM or create a database with DBCA as part of the install. Use the value “3″ install the software only.
FROM_LOCATION defines the location of the products.xml file and may
have to be set with 11.1.0.6. That’s because for some platforms, the value of that variable is not set correctly in the default response files.
For more details about all the variables you can use as part of the runInstaller command, you can view the content of the response files located in $DISTRIB/response
Once you’ve decided what values you want to use to install the software, you can run runInstallerin silent mode WITHOUTchanging the content of the response file. Below is the command you can run to install the 11.1 database server Enterprise Edition:
–> for 10.2.0.1
$ 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

$ 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

Once the software installed, you can create the oraInst.loc file if it’s the first Oracle software you install on the server. To proceed, connect as root and navigate to the newly created Oracle Inventory:
# cd /opt/app/oraInventory
# ./orainstRoot.sh
Then run the root.sh script from the ORACLE_HOME you’ve created. Connect as root and run:
# cd /opt/app/oracle/product/10.2.0/db_1
# ./root.sh

Configure Oracle Networking
Here are some sample listener.ora files:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = test01.bai.com)
      (SID_NAME = test01)
      (ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1)
    )
  )

INBOUND_CONNECT_TIMEOUT_LISTENER = 0

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lnxdg01.bai.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

start listener

Create the Oracle Database

in my installation DB is directory is /db<DBname> so i just created a link to /u01 > /dbTEST01
>10.2.0.1
$ dbca -silent                           \
       -createDatabase                   \
       -templateName General_Purpose.dbc     \
       -gdbName TEST01                     \
       -sid TEST01                         \
       -SysPassword change_on_install    \
       -SystemPassword manager           \
       -emConfiguration NONE             \
       -datafileDestination /dbTEST01/u04/oradata \
       -storageType FS                   \
       -characterSet WE8ISO8859P15       \
       -memoryPercentage 40

> files system
dbca -silent                           \
       -createDatabase                   \
       -templateName General_Purpose.dbc     \
       -gdbName TEST01                     \
       -sid TEST01                         \
       -SysPassword change_on_install    \
       -SystemPassword manager           \
       -emConfiguration NONE             \
       -datafileDestination /dbTEST01/oradata \
       -redoLogFileSize 100              \
       -storageType FS                   \
       -characterSet WE8ISO8859P15       \
       -totalMemory 500

>asm
$ dbca -silent                             \
       -createDatabase                     \
       -templateName General_Purpose.dbc       \
       -gdbName TEST01                       \
       -sid TEST01                           \
       -SysPassword change_on_install      \
       -SystemPassword manager             \
       -emConfiguration NONE               \
       -redoLogFileSize 100                \
       -storageType ASM                    \
         -asmSysPassword change_on_install \
         -diskGroupName DGDATA             \
       -characterSet WE8ISO8859P15         \
       -totalMemory 500

Post-Installation Tasks

recompile invalid objects using utlrp.sql
@?/rdbms/admin/utlrp.sql

DONE