How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6
by Ginny Henningsen; updated by Michele Casey
How to simplify the installation of Oracle Database 12c or 11g on Oracle Linux 6 by installing the oracle-rdbms-server-12cR1-preinstall
or oracle-rdbms-server-11gR2-preinstall
RPM package, which automatically performs a number of tasks, such as installing required software packages, resolving package dependencies, and modifying kernel parameters.
http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
As root perform pre-installation script that also creates user:group oracle:oinstall
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo
# vi public-yum-ol6.repo
# yum install oracle-rdbms-server-11gR2-preinstall
# cd /home
# mkdir OraDB11g
# chown oracle:oinstall OraDB11g
# cd OraDB11g
# unzip linux.x64_11gR2_database_1of2.zip
# unzip linux.x64_11gR2_database_2of2.zip
# yum -y install unixODBC-devel
As root activate user oracle by setting password
# passwd oracle
As root modify hosts file otherwise listener won’t work.
# vi /etc/hosts
host-ip oraclehost.domain oraclehost
Log in as the user oracle. Change directory to the database directory and enter the following command to run the Oracle Universal Installer:
# cd /home/OraDB11g/database
# ./runInstaller
no email
no security updates [Yes]
(*) database software only
(*) Single instance database installation
Language := English
(*) Enterprise Edition
Oracle base [/home/oracle/app/oracle]
Oracle home [/home/oracle/app/oracle/product/11.2.0/dbhome_1]
Oracle inventory [/home/oracle/app.oraInventory]
Oracle invetory groupname [oinstall]
OSDBA DBA Group [dba]
OSOPER Operator Group [oninstall]
Installer asks to run two installation scripts as root
[root@burung oracle]# /home/oracle/app/oraInventory/orainstRoot.sh
[root@burung oracle]# /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
Create user specific environment and startup programs
vi .bash_profile
PATH=$PATH:$HOME/bin:$HOME/app/oracle/product/11.2.0/dbhome_1/bin/
export PATH
export ORACLE_BASE=$HOME/app/oracle
export ORACLE_HOME=$HOME/app/oracle/product/11.2.0/dbhome_1
Start Oracle Listener
[oracle@burung ~]# lsnrctl start
[oracle@burung ~]# lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-JUL-2013 14:36:53
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 22-JUL-2013 14:36:33
Uptime 0 days 0 hr. 0 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/burung/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=burung.mcint.local)(PORT=1521)))
The listener supports no services
The command completed successfully
As user oracle create a database. You need to login oracle owned GUI/VNC session!!
(start GUI duurt lang voordat de GUI tevoorschijn komt)
(Follow Oracle for dummies)
# dbca
Now you can start sqlplus
# export ORACLE_SID=sid
# sqlplus / as sysdba
startup
..
..
shutdown
# lsnrctl stop LISTENER
Enterprise manager is at: https://localhost:1158/em, but nobody cares anyway.
# emctl start
...
..
# emctl stop