ORACLE DATABASE INSTALATION ON OEL
WITH SCREEN SHOT
Step 1 = cat /etc/hosts
=================================================================
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
[root@localhost ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.56.181 saivm1.srkinfo.com saivm1
After Changing the hostname the content of the file as bellow
----------------------------------------------------------------------------
[root@localhost ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=saivm1.srkinfo.com
=======================================================================
Step 2 Required Directory Creation
=======================================================================
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 777 /u01/app
Step 3 Just copy and past as Root user (KERNEL PARAMETERS)
grep -q ip_local_port_range /etc/sysctl.conf
if [ $? -ne 0 ]; then
echo "" >> /etc/sysctl.conf
echo "# Oracle parameters" >> /etc/sysctl.conf
echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
echo "kernel.shmmax = 4294967295" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "fs.file-max = 65536" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65000" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 262144" >> /etc/sysctl.conf
echo "fs.aio-max-nr=1048576" >> /etc/sysctl.conf
sysctl -p >> /dev/null
fi
Step 4
grep -q ip_local_port_range /etc/sysctl.conf
if [ $? -ne 0 ]; then
echo "" >> /etc/sysctl.conf
echo "# Oracle parameters" >> /etc/sysctl.conf
echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
echo "kernel.shmmax = 4294967295" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "fs.file-max = 65536" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65000" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 262144" >> /etc/sysctl.conf
echo "fs.aio-max-nr=1048576" >> /etc/sysctl.conf
sysctl -p >> /dev/null
Fi
Step 5 Just copy and past as Root user
===================================================================
grep -q oracle /etc/profile
if [ $? -ne 0 ]; then
echo "" >> /etc/profile
echo "if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then " >> /etc/profile
echo " if [ \$SHELL = \"/bin/ksh\" ]; then" >> /etc/profile
echo " ulimit -p 16384" >> /etc/profile
echo " ulimit -n 65536" >> /etc/profile
echo " else" >> /etc/profile
echo " ulimit -u 16384 -n 65536" >> /etc/profile
echo " fi" >> /etc/profile
echo "fi" >> /etc/profile
Fi
===================================================================
Step 6 Just copy and past as Root user
===================================================================
grep -q pam_limits /etc/pam.d/login
if [ $? -ne 0 ]; then
echo "session required /lib/security/pam_limits.so" >> /etc/pam.d/login
fi
login as oracle user create directory and verify
[root@saivm1 ~]# su - oracle
[oracle@saivm1 ~]$ mkdir software
Again login as root user you can find where software is there and copy the database where you want
[root@saivm1 ~]# cp -r /media/sf_datastore/11gR20/database/ /home/oracle/software
To change group and owner ship execute following command as "root"
--------------------------------------------------------------------------------
[root@saivm1 ~]# chown -R oracle:oinstall /home/oracle/software/
[root@saivm1 ~]# chmod -R 775 /home/oracle/software/database/
After copy you can verify the database folder has copied into software folder of oracle
but the owner & group are 'root' only, Actually it supposed to be owner as "oracle" and group as "oinstall" to changed the above picture
------------------------------------------------------------------------------------------------------------
REMEMBER you should be in oracle terminal / user
[oracle@saivm1 ~]$ ll software/
total 4
drwxr-x--- 8 root root 4096 Jan 31 20:52 database
************************************************************************************* Start Installing Software as "oracle" user
*************************************************************************************
copy & paste the following command
/home/oracle/software/database/runInstaller &
ORACLE DATABASE INSTALATION STARTED OBSERVE THE GUI
f you need oracle support create an oracle account and give. and no need oracle support unmark the securites support
If you want to next updates give the username and password and
No needed skip software updates
Choose the Create and configure a database option. Or, you also have the option of choosing to only install the database software, but then you must create a database in an additional step after the software is installed. If you are currently using a previous version of Oracle Database, choose Upgrade an existing database. After you have chosen an option, click Next
· Desktop Class—This installation class is most appropriate for laptop or desktop computers. It includes a starter database and requires minimal configuration.
· Server Class—This installation class is for servers, such as you would find in a data center, or used to support enterprise-level applications. Choose this installation class if you need access to advanced configuration options.
· Software location is northing but database home location where uyou want to install software give the location
· Database edition Enterprise Edition:—This installation type is the full-featured Oracle Database product that provides data management for enterprise-level applications. It is intended for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments.
- Standard Edition:—This installation type is suitable for workgroup or department-level applications, and for small to medium-sized enterprises. It provides core relational database management services and options and includes an integrated set of management tools, replication, Web features, and facilities for building business-critical applications.
- Standard One Edition:—This installation type is suitable for workgroup, department, or web applications. It provides core relational database management services for single-server environments or highly distributed branch environments. Oracle Standard Edition One includes all the facilities necessary to build business-critical applications.
- Personal Edition: (Microsoft Windows operating systems only)—This installation type installs the same software as the Enterprise Edition, but supports only a single-user, development and deployment environment.
· Character set which is based on the operating system language settings, or Unicode
·osdbaGroup :Specify the operating system DBA group. Host computer users in this group have administrative privileges on the database. This group is typically named
· Global database is northing but database name what you want give
l Inventory directory
If this is the first time you are installing any Oracle software on this computer, then the Create Inventory Directory window appears. You must specify a local directory for the inventory, which OUI uses to keep track of all Oracle software installed on the computer. This information is used while applying patches or upgrading an existing installation, and while deinstalling Oracle software. Note that this directory is different from the Oracle home directory. The recommended value for the inventory directory is Oracle_base/../oraInventory, or one level above the Oracle base directory, in the oraInventory subdirectory. If your Oracle base directory is /u01/app/oracle, then the Oracle inventory directory defaults to /u01/app/oraInventory.
It is the last step what ever your giving its showing one screen please check this atleast ones
START THE INSTALING A SOFTWARE
Database installing is started
(Optional) Click Password Management to unlock user accounts to make the accounts accessible to users.
The SYS and SYSTEM accounts are unlocked by default.
In the Execute Configuration Scripts window, you are prompted to open a new terminal window, and to run scripts as the root user.
After you run the scripts, return to this window and click OK
You use Oracle Enterprise Manager Database Control to perform common database administration tasks. The URL and port information for Database Control can be found after installation in theOracle_home/install/portlist.ini file.
