- Database: Oracle 10g R2 (10.2.0.1.0)
- Operating System: Red Hat Enterprise Linux 4 (Nahant Update 8) or Oracle Linux Release 4 Update 8 (32-bit Architecture).
- Will work with Red Hat Enterprise Linux 4.* or Oracle Linux Release 4.*
- See also http://docs.oracle.com/cd/B19306_01/ins ... 60/toc.htm for complete Oracle® Database Installation Guide 10g Release 2 (10.2) for Linux x86
- Follow the procedure in Installing Red Hat Linux 4 for Oracle 10g R2 (32-bit) (http://www.oracle-forums.com/installing ... 2-t25.html) for installing the Operating System.
- Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86 (32 Bit) - http://www.oracle.com/technetwork/datab ... 97986.html
Directions:
1. All files are in the .zip format. There is an unzip utility for this platform here (http://updates.oracle.com/unzips/unzips.html) if you need one.
2. Installation guides and general Oracle Database 10g documentation can be found here (http://www.oracle.com/technetwork/datab ... index.html).
3. Review the certification matrix for this product here (http://www.oracle.com/technetwork/index ... 87287.html).
- Check Memory (RAM) and swap space requirement
Oracle recommends:
> At least 1024 MB of physical RAM
> For RAM Between 1024 MB and 2048 MB, Swap space is 1.5 times the size of RAM.
> For RAM Between 2049 MB and 8192 MB, Swap space is Equal to the size of RAM
> For More than 8192 MB of RAM, Swap space is 0.75 times the size of RAM
- Check Additional Hardware Requirements
> 400 MB of disk space in the /tmp directory. Adjust the size if needed or delete unnecessary files. Oracle Universal Installer (OUI) requires up to 400 MB of free space in the /tmp directory
> Between 1.5 GB and 3.5 GB of disk space for the Oracle software, depending on the installation type
> 1.2 GB of disk space for a preconfigured database that uses file system storage (optional)
- Validate that the system meets these requirements
> Check the physical RAM size: [oracle@oracle10g ~]$ grep MemTotal /proc/meminfo
> Check the configured swap space: [oracle@oracle10g ~]$ grep SwapTotal /proc/meminfo
> Check disk space available in the /tmp directory: [oracle@oracle10g ~]$ df -k /tmp
> Check the amount of free disk space on the system: [oracle@oracle10g ~]$ df -h
*** Below is the approximate disk space requirements for software files for each installation type.
> Check whether the system architecture can run the software: [oracle@oracle10g ~]$ grep "model name" /proc/cpuinfoInstallation Type Requirement for Software Files (GB)
Enterprise Edition 1.5
Standard Edition 1.5
Custom (maximum) 1.5
- Check the Software Requirements[oracle@oracle10g ~]$ grep "model name" /proc/cpuinfo
model name : AMD Phenom(tm) II N620 Dual-Core Processor
- Verify that the following software is installed on the system
> Operating system: [oracle@oracle10g ~]$ cat /etc/issue
*** In this tutorial, I used Enterprise Linux Enterprise Linux AS release 4 (October Update 8)
> Kernel version: [oracle@oracle10g ~]$ uname -r
*** I used 2.6.9-89.0.0.0.1.ELsmp. Oracle recommends at least version 2.4.21-27.EL for this OS version.
- Check the Software Packages (RPMs)
- The following packages (or later versions) must be installed:
For Red Hat Enterprise Linux 4.0,
binutils-2.15.92.0.2-13.EL4
compat-db-4.1.25-9
compat-libstdc++-296-2.96-132.7.2
control-center-2.8.0-12
gcc-3.4.3-22.1.EL4
gcc-c++-3.4.3-22.1.EL44
glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
setarch-1.6-1
libaio-0.3.105-2
- To check for the packages currently installed,
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \
binutils compat-db compat-libstdc++ control-center gcc gcc-c++ glibc glibc-common gnome-libs \
libstdc++ libstdc++-devel make pdksh sysstat xscreensaver setarch libaio
- Ensure that all required packages are installed before proceeding. Otherwise the OUI prerequisite check will fail.[oracle@oracle10g ~]$ rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \
> binutils compat-db compat-libstdc++ control-center gcc gcc-c++ glibc glibc-common gnome-libs \
> libstdc++ libstdc++-devel make pdksh sysstat xscreensaver setarch libaio
binutils-2.15.92.0.2-25 (i386)
compat-db-4.1.25-9 (i386)
control-center-2.8.0-12.rhel4.5 (i386)
gcc-3.4.6-11.0.1 (i386)
gcc-c++-3.4.6-11.0.1 (i386)
glibc-2.3.4-2.43 (i686)
glibc-common-2.3.4-2.43 (i386)
gnome-libs-1.4.1.2.90-44.2 (i386)
libstdc++-3.4.6-11.0.1 (i386)
libstdc++-devel-3.4.6-11.0.1 (i386)
make-3.80-7.EL4 (i386)
pdksh-5.2.14-30.6 (i386)
sysstat-5.0.5-25.el4 (i386)
xscreensaver-4.18-5.rhel4.14.0.1 (i386)
setarch-1.6-1 (i386)
libaio-0.3.105-2 (i386)
For the benefit of newbies, we will perform installation in Graphical User Interface (GUI) mode.
- Installing the Required Packages (RPMs)
- Once the basic installation of Guest Operating System is complete, install the following packages if not yet installed whilst logged in as the root user.
[root@localhost ~]# cd /media/cdrom/Enterprise/RPMS/ <<< Ensure that you change to correct media location.
[root@localhost RPMS]# rpm -Uvh binutils*
[root@localhost RPMS]# rpm -Uvh compat-db*
[root@localhost RPMS]# rpm -Uvh compat-libstdc++*
[root@localhost RPMS]# rpm -Uvh control-center*
[root@localhost RPMS]# rpm -Uvh gcc-*
[root@localhost RPMS]# rpm -Uvh gcc-c++*
[root@localhost RPMS]# rpm -Uvh glibc*
[root@localhost RPMS]# rpm -Uvh glibc-common*
[root@localhost RPMS]# rpm -Uvh gnome*
[root@localhost RPMS]# rpm -Uvh libstdc++*
[root@localhost RPMS]# rpm -Uvh make*
[root@localhost RPMS]# rpm -Uvh pdksh*
[root@localhost RPMS]# rpm -Uvh sysstat*
[root@localhost RPMS]# rpm -Uvh xscreensaver*
[root@localhost RPMS]# rpm -Uvh setarch*
[root@localhost RPMS]# rpm -Uvh libaio*
- Perform the Oracle Installation Preinstallation Tasks
- Configure Name Resolution
> Perform the following steps whilst logged into Guest Operating System as the root user.
> The /etc/hosts file must contain an entry for the fully qualified host name and for localhost.
> Fully qualified host name should be listed BEFORE the short-cut alias127.0.0.1 localhost.localdomain localhost
192.168.218.150 oracle10g.localdomain oracle10g
[oracle@oracle10g]$ cat /etc/hosts | grep `eval hostname`
- Verify that the host name has been set[oracle@oracle10g]$ cat /etc/hosts | grep `eval hostname`
192.168.218.150 oracle10g.localdomain oracle10g
> [oracle@oracle10g ~]$ hostname
- Verify that the domain name has not been set dynamically. This should not return any results.[oracle@oracle10g ~]$ hostname
oracle10g.localdomain
[oracle@oracle10g ~]$ domainname
- Configure Kernel Parameters[oracle@oracle10g ~]$ domainname
(none)
> Add or edit the following lines to the /etc/sysctl.conf file to set the recommended value for kernel parameters.
> Run the following command as root to reload the current value of kernel parameterskernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
/sbin/sysctl -p
> Increase the shell limits. Add the following lines to the /etc/security/limits.conf file.
> Add or edit the following line in the /etc/pam.d/login file, if it does not already exist.oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
- Create the Required Operating System Groups and Userssession required /lib/security/pam_limits.so
session required pam_limits.so
The following operating system groups and user are required if you are installing Oracle Database:
> The OSDBA group (dba): [root@oracle10g ~]# groupadd dba
*** It identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege).
> The OSOPER group (oper): [root@oracle10g ~]# groupadd oper
*** This is an optional group. A group of operating system users having limited set of database administrative privileges (the SYSOPER privilege)
> The Oracle Inventory group (oinstall): [root@oracle10g ~]# groupadd oinstall
*** This group owns the Oracle inventory, which is a catalog of all Oracle software installed on the system.
> The Oracle software owner user (typically, oracle): [root@oracle10g ~]# useradd -g oinstall -G dba oracle
*** This user owns all of the software installed during the installation. This user must have the Oracle Inventory group as its primary group. It must also have the OSDBA and OSOPER groups as secondary groups.
> Change the password for Oracle software owner: [root@oracle10g ~]# passwd oracle
- Create the directories in which the Oracle software will be installed.
> Oracle Base Directory: [root@oracle10g ~]# mkdir -p /u01/app/oracle
> Oracle Inventory Directory: [root@oracle10g ~]# mkdir -p /u01/app/oracle/oraInventory
> Oracle Home Directory: [root@oracle10g ~]# mkdir -p /u01/app/oracle/product/10.2.0/db_1
> Database File Directory: (Optional): [root@oracle10g ~]# mkdir -p /u01/oradata
> Recovery File Directory (flash recovery area) (Optional): [root@oracle10g ~]# mkdir -p /u01/flash_recovery_area
> Installation Location: [root@oracle10g ~]# mkdir -p /u01/staging
- Ensure that the above Locations are owned by oracle.
[root@oracle10g ~]# chown -R oracle:oinstall /u01
> Login as the oracle user and add the following lines at the end of the .bash_profile file.
[oracle@oracle10g ~]$ vi ~/.bash_profile
- Install the Oracle Database SoftwareTMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL10G; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
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/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
> In this guide, we will just install x86 Oracle 10g Release 2 Database Software.
- As oracle user, upload the Oracle Database 10g installer (10201_database_linux32.zip) via FTP client.
> [oracle@oracle10g ~]$ cd /u01/staging/
> [oracle@oracle10g staging]$ unzip 10201_database_linux32.zip
- Log in to VMware as oracle user.
> Change directory to unzipped installer
[oracle@oracle10g ~]$ cd /u01/staging/database/
> The Oracle Universal Installer (OUI) enables you to install, upgrade, or uninstall database components. It uses java-based engines thus presents the same interface and installation choices regardless of the platform on which you use it. In this case, we are installing Oracle Database 10g on Linux platform. The OUI supports web-based installation, non-interactive installation, automatic dependency detention, multiple Oracle Homes, partial uninstallation and multiple languages.
> Start Oracle Universal Installer and install the software. Enter the following command:
[oracle@oracle10g database]$ ./runInstaller
There are two methods that you can use to install Oracle Database 10g. Select the installation method that you want to use and any required information, then click Next.
@ Basic Installation
Select this installation method if you want to quickly install Oracle Database 10g. This installation method requires minimal user input. It installs the software, and optionally creates a general-purpose database with the SAMPLE schema and the EXAMPLE tablespace, using the information that you specify on this screen. For information about the values that you must specify, see Completing a Basic Installation.
Note: If you do not specify all of the required information, the Installer displays the Advanced installation screens. It uses the values that you have specified as the default values on the appropriate screens.
@ Advanced Installation
Select this installation method if you want to complete any of the following tasks:
@ Perform a custom software installation, or choose a different database configuration
@ Install Oracle Real Application Clusters
@ Upgrade an existing database
@ Select a database character set or different product languages
@ Create a database on a different file system from the software
@ Configure Automatic Storage Management (ASM) or use raw devices for database storage
@ Specify different passwords for administrative schemas
@ Configure automated backups or Oracle Enterprise Manager notifications
*** Installation Types
You can choose one of the following installation types:
@ Enterprise Edition
This installation type is designed for enterprise-level applications. It is engineered for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments. If you select this installation type, all separately licensable Enterprise Edition options are installed.
@ Standard Edition
This installation type is designed for department or workgroup level applications, or for small-to-medium sized enterprises (SMEs). It is engineered to provide core relational database management services and options. If you select this installation type, you must purchase additional licenses if you want to install extra Enterprise Edition options.
@ Personal Edition (Windows Operating Systems Only) This installation type installs the same software as the Enterprise Edition installation type, but supports only a single user development and deployment environment that requires full compatibility with Enterprise Edition and Standard Edition.
- On "Installation Method",
> Basic Installation: Checked it (default)
> Oracle Home Location: /u01/app/oracle/product/10.2.0/db_1
> Installation Type: Enterprise Edition
> UNIX DBA Group: oinstall or dba
> Create Starter Databases: Unchecked
> Global Database Name: Disabled
> Database password: Disabled
> Advanced Installation: Unchecked
> Click Next
*** The two options are Basic Installation: Perform full Oracle Database 10g installation with standard configuration options requiring minimal input. This option uses file system for storage, and a single password for all database accounts; Advanced Installation: Allow advanced selections such as different passwords for the SYS, SYSTEM, SYSMAN, and DBSNMP accounts, database character set, product languages, automated backups, custom installation, and alternative storage options such as Automatic Storage Management.
See figure below.
- Specify Inventory directory and credentials:
> Leave the default value for Inventory directory and credentials.
> Enter the full path of the inventory directory: /u01/app/oracle/oraInventory (default)
> Specify Operating System group name: oinstall (default)
> Click Next
*** Since this is first installation in this host, we need to specify a directory for installer files. This file is called "inventory directory". Within the inventory directory, the installer automatically sets up sub-directories for each product to contain inventory data and will consume typically 150 Kilobytes per product.
*** You need also to specify the Operating System Group that has write permission to the above inventory directory (recommended). You can leave the field blank if you want to perform the above operations as Superuser.
See figure below.
> Open a new terminal
> su -
> [root@oracle10g ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
> Click Continue[root@oracle10g ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete
- Installation Prerequisite Checks
Before installation, Oracle Universal Installer checks the environment to see whether it meets the requirements for successful installation. Early detection of problems with the system setup reduces the chances of users encountering problems during installation; for instance, problems with insufficient disk space, missing patches, inappropriate hardware, etc.
This screen shows the name, type, and status for all prerequisite checks designed for the installation. Automatic checks are run first, followed by optional and manual checks. You may not disable automatic checks; run optional checks at your discretion; manual checks must be verified by filling in the selection box. As each check runs, a progress bar is shown, and test details (expected results, actual results, error messages, instructions, etc.) are displayed in the details window. To stop all prerequisite checks, click Stop.
Once the prerequisite checker finishes running all checks, it displays a status summary indicating the number of checks that failed and the number that require verification. A check may require verification if a warning was produced during execution or a manual check was not confirmed by the user. You must manually verify all warning and manual checks by filling in the selection box. Once you confirm a check, you are taken to the next check to be confirmed. Click a prerequisite check to view its corresponding details, including recommended user actions.
To retry failed, skipped (stopped by user), and warning checks, click Retry.
Note: For manual checks, the selection boxes must be filled in manually.
To continue without retrying, click Next.
- Let the Oracle Universal Installer performs the Product-Specific Prerequisite Checks.
> Review and fix if there are issues found before proceeding to the next step.
> Proceed to the next step if the overall check result is: Passed
*** The installer verifies that your environment meets all of the minimum requirements for installing and configuring the products that you have chosen to install. You must manually verify and confirm items that are flagged with warnings and items that require manual checks. For details about performing these checks, click and review the details in the box at the bottom of the window.
The Summary screen presents a summary of the options you selected during the installation process. Depending on your installation, the information might include the following:
*** Global Settings
@ Source: The centralized location where components have been placed for installations. To change the Source, you must go back to the File Locations page.
@ Oracle Home: The location of the Oracle home where you want to install your product. To change the Oracle home, you must go back to the File Locations page.
@ Appltop: The location of the APPL_TOP directory where you want to install your product. To change the APPL_TOP directory, you must go back to the File Locations page.
@ Installation Type: A pre-defined component set that automatically selects which components and dependency groups to install. To change the Installation Type, you must go back to the Installation Types page.
*** New Languages Added: This lists the languages you have chosen for running the Oracle product. To install new languages, you need to run the setup in AddLangs mode.
@ Refer to Internationalization and Installation Translations Support for more information.
*** Space Requirements: The disk space required to install the product. The space requirement appears in a different color if the disk space available is less that what is required.
Note: The space requirements shown on the Summary page may be slightly different than the actual space the component occupies on the installation disk. This is due to differences in disk configurations. For example, the space required on one hard drive might differ from the space required on another hard drive that uses a different block size or that is managed by a different file system.
*** New Installations: Products to be installed for the first time on the system.
*** Upgrades: Products to be upgraded to a higher version.
*** Reinstallations: OUI deinstalls earlier versions of the product first before starting the installation.
*** De-Installations: Products to be removed as part of this installation because no other products depend on them.
*** Already Installed: Products that are already installed. OUI does not install these products.
@ Note: If there is a disk space shortage and you click Install, a warning dialog appears. If you click No, the space information is refreshed.
When you have checked your choices, click Install to continue. The Install screen appears.
If other disks are required, OUI will prompt you for another disk during the Install phase.
- The Summary window is displayed. Please review then click on Install.
> Open a new terminal window
> Login as root: [oracle@oracle10g ~]# su -
> Run the scripts
> [root@oracle10g ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
> [root@oracle10g ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
[root@oracle10g ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
> Just press "ENTER" key when prompted for full pathname of the local bin directory.[root@oracle10g ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete
> Depending on the oracle user's default shell, add or edit the below lines to the default shell start-up file
> [oracle@oracle10g ~]$ vi ~/.bash_profile
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
-- End of Oracle 10g Database Installation --
Configuration Details:
[oracle@oracle10g]$ cat $ORACLE_HOME/install/readme.txt
oracle@oracle10g]$ cat $ORACLE_HOME/install/portlist.ini[oracle@oracle10g]$ cat $ORACLE_HOME/install/readme.txt
Enterprise Manager Database Control URL - (ORCL10G) :
http://oracle10g.localdomain:1158/em
The iSQL*Plus URL is:
http://oracle10g.localdomain:5560/isqlplus
The iSQL*Plus DBA URL is:
http://oracle10g.localdomain:5560/isqlplus/dba
- Post-Installation Tasks[oracle@oracle10g]$ $ORACLE_HOME/install/portlist.ini
iSQL*Plus HTTP port number =5560
Enterprise Manager Console HTTP Port (ORCL10G) = 1158
Enterprise Manager Agent Port (ORCL10G) = 3938
> You may now start creating a new Oracle 10g Database.
Creating Oracle 10g Database Using DBCA
Follow this: http://www.oracle-forums.com/creating-o ... a-t28.html
Creating Oracle 10g Database Manually on Linux
Follow this: http://www.oracle-forums.com/creating-o ... x-t46.html