OBIA 11.1.1.9.1 Installation
As a part of OBIA installation first we will see the prerequisites
Hardware
Requirements
Hard Disk Space (minimum) : 160 GB
RAM :
8GB
Processor (Minimum) :
i3
Software
Requirements
Operating System :
Oracle Enterprise Linux (Oel6.6)
OS Bit :
x86-64bit
JDK version :
7.01_64 (6.3 and above)
Oracle Database (installed) : 11.2.0.4
Repository Creation Utility (RCU) :11.1.1.7.0
OBIEE :
11.1.1.7.0
Web logic server (upgrade10. 3.5 to 10.3.6) :10.3.6
Oracle Data Integrator (ODI) :11.1.1.7.0
RCU for OBIA :
11.1.1.9.1
OBIA :
11.1.1.9.1
Host
Node Credentials
Hostname : oracleobiee.com
Host IP :your system IP
Root user name :
root
Root user password :
Oracle12$
DB,RCU, OBIEE,ODI,OBIA installed Username :oica
Password :
Oracle12$
Mount point :/opt
My softwares are located in
opt/softwares/ followed by respective names
ex:
opt/softwares/database for oracle DB 11.2.0.4 etc
First check Oracle certification matrix link
Then
You need to install JAVA(jdk 7.01_64 version)
I am not covering how to install jdk
Step2:
Installation of oracle Database 11.2.0.4
Oracle Database 11g Release 2 (11.2.0.4) software on
Oracle Linux 6.6
Make sure
your Linux server meets the minimum hardware requirements:
- 1GB of RAM (plus appropriately sized swap space)
- 4.5GB of disk space for the software installation
- 1GB of disk space for your /tmp directory
The The following
Operating system (OS) packages (or later versions) must be installed for Oracle
Linux 6, Red Hat Enterprise Linux 6, and Asianux Server 4
binutils-2.20.51.0.2-5.11.el6
(x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6
(x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6
(x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6
(x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6
(x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
|
For other details refer following oracle document.
http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1161
Prerequisties
Create an user(say oica) which he going install
oracle 11g(11.2.0.4) software on linux 6.6 of x86_64 bit version.
Create a group dba if not exist and assign user to
this dba group.
Create a oinstall group and assign user to this
group.
In single step creating user,group and assigining
user to group with user default directory
#useradd –g dba –G oinstall –m oica –d /opt/
Above command will create 2 groups dba(-g primary
group) & oinstall(-G secondary group) and assign to user(-m)oica with
default directory(-d option) /opt/ where /opt is mount point .
Now create a directory structure for database
installation after login as user(oica)
$mkdir –p /opt/app/oracle/product/11.2.0.4/db_home
Change owner ships
#chown -R oica:oinstall /opt
#chmod -R 775 /opt
Now download the oracle database software(11.2.0.4)
which is compatiable for linux 6.6 version of x86_64 bit version from my oracle
support(MOS).
Unzip the software and put it in a directory located
in /opt/softwares/database.
In the root user type xhost +
#xhost +
o/p access control disabled, clients can connect
from any host
now in the same terminal login as user to install
database(say oica in our case) and go to the directory where database unzipped
software is there.
#su – oica
Password:Oracle12$
$cd /opt/softwares/database
Step1:
# yum install
oracle-rdbms-server-11gR2-preinstall
#xhost +
access controls disabled clients can connect from any host
Now same terminal login as your respective user
#su - oica
go to /opt/softwares/database/oui/bin
Now run runinstaller.sh file
$./runinstaller.sh
After checking prerequisites it open GUI wizard
window as follows
Un Check the check box I wish to receive security
updates via my oracle support then
Click on
yes button.
Click on next button
Step2:
Next the following screen will appear
Click the radio button skip software updates and
Click on next button.
Step3:
The following screen will appear
In this either you can select create and configure a
database or install database software only( I have selected this option because
I want create database using dbconfiguration assistant (dbca) later.
Then click on next button.
Step4:
The following screen will appear
Because Iam installing on single server that is why
I have selected single instance database installation.
Then click on next button.
Step5:
The following screen will appear.
I have selected us English as well as English (UK)
Then click on next button.
Step6:
The following screen will appear
Select enterprise Edition (4.7GB)
And click on next button
Step7:
The following screen will appear.
Click on browse button select appropriate oracle
base location in our case it is
/opt/app/oracle
And software location as
/opt/app/oracle/product/11.2.0.4
Then click on next button
Step8:
The following screen will appear.
Browse the oraInventory location.my inventory is
located in “/uo1/app/oraInventory”
Select orainventory group name as oinstall/dba
click on next button.
Step9:
The following screen will appear.
Select DBA (OSDBA) as dba
And Database operator (OSOPER) as dba
Step10:
The following screen will appear.
It will check prerequisite checks .if everything
meets the requirements click on next button.
Otherwise errors/ warnings will display we have to
resolve the errors we can ignore the warnings.
Step11:
The following screen will appear.
This is summary screen .if you want to save response
file click on save response file and save it in your specified location.
Then click on install button.
Step12:
The following screen will appear
In this step installation of oracle software product
will takes place.
After reaching 100%
It will go to the following screen to run/execute
root scripts
Step13:
The following screen will appear.
Open new terminal login as root/super user
Go to the above specified locations and run the
scripts
#cd /u01/app/oraInventory
#./orainstRoot.sh
And
#cd /opt/app/oracle/product/11.2.0.4/db_home
#./root.sh
That’s end the installation of oracle software.
Step14:
Login as a root user type xhost +
#xhost +
o/p access control disabled, clients can connect
from any host
now in the same terminal login as user to install database(say oica in our case) and go to the directory where oracle home resides i.e =/opt/app/oracle/product/11.2.0.4/db_home
$cd /opt/app/oracle/product/11.2.0.4/db_home
Now export the path
$export ORACLE_HOME=/opt/app/oracle/product/11.2.0.4/db_home
Now go to bin
$cd bin
Now type dbca
$./dbca
It will open a wizard window screen as follows
This is database configuration Assistant welcome
screen
Click on next button.
The following screen will appear.
Select create Database option then click on next
button.
Step15:
The following screen will appear.
Select datawarehouse radio button and click on next
button.
Step16:
The following screen will appear.
Give Global database name in our case it is “obia”
Automatically take sid also obia if not give same
name then click on next button.
Step17:
The following screen will appear.
Unselect
configure enterprise manager in Enterprise manager tab
Unselect enable automatic maintenance tasks in
Automatic maintenance tasks tab then click on next button.
Step18:
The following screen will appear.
Select same Administrative password for all accounts
Password as “manager” and confirm password as
“manger”
It will warning as password entered does not satisfy
oracle recommended click yes to continue.
Step19:
The following screen will appear
By using browse button locate the use common
location for all database files.
In our case it is /opt/app/oracle/dbfiles
Then click on next button.
Step20:
The following screen will appear.
Check the check box specify Fast Recovery Area as
default one
And click on next button
Step21:
The following screen will appear
Select sample schemas and don’t select anything in
the custom scripts tab click on next button
Step22:
The following screen will appear.
Step23:
The following screen will appear.
Click on next button.
Step24:
The following screen will appear.
Select create database option
Then click on finish button.
After this summary screen will(in this i didn't included because Iam not taken screen shot).
Click on next button
Then following screen will appear
Copying database files will takes after it reaches
100%
The following em screen will come.
If you want unlcock sample schemas go to password
management unlock required schemas and assign password and confirm password
click on exit then click on finish button.
No comments:
Post a Comment