2016 - Oracle RAC 11g2 - install RAC
The Slovak original of this document: 2016 - Oracle RAC 11g2 - install RAC (slovensky).
================================================================================================================
Instalacia OracleDB 11g2 - Oracle RDBM (Oracle RAC)
================================================================================================================
Oracle Database Software (RAC 192.0.2.8)
--------------------------------------------------------------------------------------------------------
- ORACLE_BASE: /data/u01/app/oracle
- ORACLE_HOME: /data/u01/app/oracle/db11204
- Owner: oracle (Primary Group: oinstall, Secondary Group: asmdba, dba)
- Permissions: 755
- Oracle Inventory Location: /data/u01/app/oraInventory
- Database Name: clsdb
- Listener: opdb (TCP:1525)
--------------------------------------------------------------------------------------------------------
================================================================================================================
[1] Instalacia Oracle RDBM (Database Software)
================================================================================================================
[1.1] Instalacia Oracle Database Software
--------------------------------------------------------------------------------------------------------
An X server has to be running on the PC the installation is driven from.
--------------------------------------------------------------------------------------------------------
# su - oracle
# cd /data/install/database/
# ./runInstaller
--------------------------------------------------------------------------------------------------------
Configure Security Updates
--------------------------
Email : oraadmin@domena.sk
I wish to receive security updates via My Oracle Support : uncheck/nezaskrtnut/nevyplnat
--------------------------------------------------------------------------------------------------------
Connection Failed
-----------------
Connection Method: Proxy
I want to remain uninformed of critical security issues in my configuration: check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Download Software Updates
-------------------------
Skip software updates : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Installation Option
-------------------
Install database software only : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Grid Installation Options
-------------------------
Oracle Real Application Cluster database installation : check/zaskrtnut
Select nodes (in addition to the local node) in the cluster where the installer should install Oracle RAC:
Check: oradb01
Check: oradb02
SSH Connectivity
----------------
Select both Oracle nodes, fill in the values below and press "Setup", then "Test"
OS Username : oracle
OS Password : Ora.password.123
User home is shared by the selected nodes : UNCHECK
Reuse private and public keys existing in the user home : CHECK
--------------------------------------------------------------------------------------------------------
Product Languages
-----------------
Selected Languages : English
--------------------------------------------------------------------------------------------------------
Database Edition
----------------
Standard Edition (4,6 GB) : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Installation Location
---------------------
Oracle Base : /data/u01/app/oracle
Software Location : /data/u01/app/oracle/db11204
--------------------------------------------------------------------------------------------------------
Operating System Groups
-----------------------
Database Administrator (OSDBA) Group : dba
Database Operator (OSOPER) Group (Optional) : oinstall
--------------------------------------------------------------------------------------------------------
Summary
-------
Install : klik
--------------------------------------------------------------------------------------------------------
Instalacia
----------
Towards the end the installer asked for these scripts to be run as root on both Oracle nodes.
--------------------------------------------------------------------------------------------------------
Spustenie skriptu "root.sh" pod uzivatelom "root" na vsetkych Oracle Nodoch (ORADB01, ORADB02)
--------------------------------------------------------------------------------------------------------
ORADB01# /data/u01/app/oracle/db11204/root.sh
ORADB02# /data/u01/app/oracle/db11204/root.sh
--------------------------------------------------------------------------------------------------------
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /data/u01/app/oracle/db11204
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
--------------------------------------------------------------------------------------------------------
================================================================================================================
[2] Creating a new Oracle listener (TCP:1525) named "CLSDB" for the new database (DB: CLSDB)
================================================================================================================
[2.1] Start the Oracle Net Configuration Assistant
--------------------------------------------------------------------------------------------------------
An X server has to be running on the PC the installation is driven from.
--------------------------------------------------------------------------------------------------------
ORADB01# su - oracle
ORADB01# netca
--------------------------------------------------------------------------------------------------------
Select the type of Oracle Net Services configuration:
-----------------------------------------------------
Cluster configuration : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Choose the configuration you would like to do:
----------------------------------------------
Listener configuration : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Select what you want to do:
---------------------------
Add : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Listener name:
--------------
Listener name : CLSDB
--------------------------------------------------------------------------------------------------------
Selected Protocols:
-------------------
Selected Protocols : TCP
--------------------------------------------------------------------------------------------------------
TCP port selection:
-------------------
Use another port number : 1525
--------------------------------------------------------------------------------------------------------
Would you like to configure another listener?
---------------------------------------------
No : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
================================================================================================================
[3] Creating the new ASM groups for the new database (DB: CLSDB)
================================================================================================================
[3.1] Spustime Oracle ASM konfiguracneho asistenta (Oracle ASM Configuration Assistant)
--------------------------------------------------------------------------------------------------------
An X server has to be running on the PC the installation is driven from.
--------------------------------------------------------------------------------------------------------
ORADB01# su - grid
ORADB01# asmca
--------------------------------------------------------------------------------------------------------
Zalozka "Disk Groups":
----------------------
Create: klik
--------------------------------------------------------------------------------------------------------
Create Disk Group
-----------------
Disk Group Name : DATA
Redundancy : External (None)
Select Member Disks :
+--------------------------------------------------------------------------------+
| Disk Path | Header Status | Disk Name | Size (MB) | Quorum |
+--------------------------------------------------------------------------------+
| ORCL:ASMDISK2 | PROVISIONED | | 102399 | NotChecked |
| ORCL:ASMDISK3 | PROVISIONED | | 102399 | NotChecked |
+--------------------------------------------------------------------------------+
Create Disk Group
-----------------
Disk Group Name : FRA
Redundancy : External (None)
Select Member Disks :
+--------------------------------------------------------------------------------+
| Disk Path | Header Status | Disk Name | Size (MB) | Quorum |
+--------------------------------------------------------------------------------+
| ORCL:ASMDISK4 | PROVISIONED | | 204799 | NotChecked |
+--------------------------------------------------------------------------------+
Create Disk Group
-----------------
Disk Group Name : ONTRLG
Redundancy : External (None)
Select Member Disks :
+--------------------------------------------------------------------------------+
| Disk Path | Header Status | Disk Name | Size (MB) | Quorum |
+--------------------------------------------------------------------------------+
| ORCL:ASMDISK5 | PROVISIONED | | 20479 | NotChecked |
+--------------------------------------------------------------------------------+
================================================================================================================
[4] Vytvorenie novej databazy (DB: CLSDB)
================================================================================================================
[4.1] Spustime Oracle databazoveho konfiguracneho asistenta (Oracle Database Configuration Assistant)
--------------------------------------------------------------------------------------------------------
An X server has to be running on the PC the installation is driven from.
--------------------------------------------------------------------------------------------------------
ORADB01# su - oracle
ORADB01# dbca
--------------------------------------------------------------------------------------------------------
Create database
---------------
Select the database type that you would like to create or administer : Oracle Real Application Clusters (RAC) database
--------------------------------------------------------------------------------------------------------
Operations
----------
Create a Database : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Database Templates
------------------
Custom Database : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Database Identification
-----------------------
Configuration Type : Admin-Managed: check/zaskrtnut
Global Database Name : clsdb.domena.sk
SID Prefix : clsdb
Select the nodes on which you wany to create the cluster database : oradb01, oradb02
--------------------------------------------------------------------------------------------------------
Management Options
------------------
Configure Enterprise Manager : check/zaskrtnut
Configure Database Control for local management : check/zaskrtnut
Enable Daily Disk Backup to Recovery Area : uncheck/nezaskrtnut
--------------------------------------------------------------------------------------------------------
Database Credentials
--------------------
Use the Same Administrative Password for All Accounts : check/zaskrtnut
Password : dbPassword123
--------------------------------------------------------------------------------------------------------
Database File Locations
-----------------------
Use Oracle-Managed Files : check/zaskrtnut
Database Area : +DATA
(If clicking "Browse" shows no ASM groups, the setuid bit has to be set on the "oracle" binary -> /data/u01/app/grid11204/bin/oracle)
REF: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=186207167629801&id=1177483.1&_afrWindowMode=0&_adf.ctrl-state=989is2rso_408
# cd <Grid_Home>/bin
# chmod 6751 oracle
# ls -l oracle
--------------------------------------------------------------------------------------------------------
ASM Credentials
---------------
Specify ASMSNMP password specific to ASM : Asm.password.123
--------------------------------------------------------------------------------------------------------
Recovery Configuration
----------------------
Specify Fast Recovery Area : check/zaskrtnut
Fast Recovery Area : +FRA
Enable Archiving : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Initialization Parameters
-------------------------
Zalozka Memory
--------------
Typical : check/zaskrtnut
Memory Size (SGA and PGA) : 6307 MB
Percentage : 80 %
Use Automatic Memory Management : uncheck/nezaskrtnut
--------------------------------------------------------------------------------------------------------
Zalozka Sizing
--------------
Block Size : 8192 Bytes
Processes : 350
--------------------------------------------------------------------------------------------------------
Zalozka Character Sets
----------------------
Use Unicode (AL32UTF8) : check/zaskrtnut
National Character Set : UTF8 - Unicode 3.0 UTF-8 Universal character ser, CESU-8 compliant
Default Language : American
Default Territory : United States
--------------------------------------------------------------------------------------------------------
Zalozka Connection Mode
-----------------------
Dedicated Server Mode : check/zaskrtnut
--------------------------------------------------------------------------------------------------------
Database Storage
----------------
The defaults were used; nothing was changed.
--------------------------------------------------------------------------------------------------------
Creation Options
----------------
Create Database : check/zaskrtnut
Generate Database Creation Scripts : check/zaskrtnut
Destination Directory : /data/u01/app/oracle/admin/clsdb/scripts
--------------------------------------------------------------------------------------------------------
Klik Finish
--------------------------------------------------------------------------------------------------------
================================================================================================================
[5] Overenie stavu novo vytvorenej databazy "CLSDB"
================================================================================================================
[5.1] Checking the state of the newly created database "CLSDB" with "srvctl"
--------------------------------------------------------------------------------------------------------
ORADB01# su - oracle
ORADB01# srvctl config database -d clsdb
--------------------------------------------------------------------------------------------------------
Database unique name: clsdb
Database name: clsdb
Oracle home: /data/u01/app/oracle/db11204
Oracle user: oracle
Spfile: +DATA/clsdb/spfileclsdb.ora
Domain: domena.sk
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: clsdb
Database instances: clsdb1,clsdb2
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
--------------------------------------------------------------------------------------------------------
================================================================================================================
[5] Prostredie uzivatela "oracle"
================================================================================================================
[5.1] Create a BASH profile (~/.bash_profile) for the user "oracle" on the first Oracle node (ORADB01)
--------------------------------------------------------------------------------------------------------
ORADB01# vi /home/oracle/.bash_profile
--------------------------------------------------------------------------------------------------------
# Settings specific to the user "oracle"
umask 022
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=oradb01.domena.sk; export ORACLE_HOSTNAME
ORACLE_UNQNAME=clsdb; export ORACLE_UNQNAME
ORACLE_BASE=/data/u01/app/oracle; export ORACLE_BASE
ORACLE_SID=clsdb1; export ORACLE_SID
ORACLE_HOME=/data/u01/app/oracle/db11204; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
GRID_HOME=/data/u01/app/grid11204; export GRID_HOME
DB_HOME=$ORACLE_BASE/db11204; export DB_HOME
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
BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
alias sql='sqlplus / as sysdba'
alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'
--------------------------------------------------------------------------------------------------------
[5.2] Pre uzivatela "oracle" upravime BASH profil (~/.bash_profile) na druhom Oracle node (ORADB02)
--------------------------------------------------------------------------------------------------------
ORADB02# vi /home/oracle/.bash_profile
--------------------------------------------------------------------------------------------------------
...
ORACLE_HOSTNAME=oradb02.domena.sk; export ORACLE_HOSTNAME
ORACLE_SID=clsdb2; export ORACLE_SID
...
--------------------------------------------------------------------------------------------------------
[5.3] Create the file of Oracle GRID environment variables for the user "oracle" on the first Oracle node (ORADB01)
--------------------------------------------------------------------------------------------------------
ORADB01# vi /home/oracle/grid_env
--------------------------------------------------------------------------------------------------------
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_HOME=$GRID_HOME; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$BASE_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
--------------------------------------------------------------------------------------------------------
[5.4] Create the file of Oracle GRID environment variables for the user "oracle" on the second Oracle node (ORADB02)
--------------------------------------------------------------------------------------------------------
ORADB02# vi /home/oracle/grid_env
--------------------------------------------------------------------------------------------------------
ORACLE_SID=+ASM2; export ORACLE_SID
...
--------------------------------------------------------------------------------------------------------
[5.5] Create the file of Oracle DB environment variables for the user "oracle" on the first Oracle node (ORADB01)
--------------------------------------------------------------------------------------------------------
ORADB01# vi /home/oracle/db_env
--------------------------------------------------------------------------------------------------------
ORACLE_SID=clsdb1; export ORACLE_SID
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$BASE_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
--------------------------------------------------------------------------------------------------------
[5.6] Create the file of Oracle DB environment variables for the user "oracle" on the second Oracle node (ORADB02)
--------------------------------------------------------------------------------------------------------
ORADB02# vi /home/oracle/db_env
--------------------------------------------------------------------------------------------------------
ORACLE_SID=clsdb2; export ORACLE_SID
...
--------------------------------------------------------------------------------------------------------
[5.7] Otestovanie prostredi Oracle GRID (grid_env) a Oracle DB (db_env)
--------------------------------------------------------------------------------------------------------
# su - oracle
# echo $ORACLE_HOME
/data/u01/app/oracle/db11204
# grid_env
# echo $ORACLE_HOME
/data/u01/app/grid11204
# db_env
# echo $ORACLE_HOME
/data/u01/app/oracle/db11204
--------------------------------------------------------------------------------------------------------
================================================================================================================
[6] Prostredie uzivatela "grid"
================================================================================================================
[6.1] Create a BASH profile (~/.bash_profile) for the user "grid" on the first Oracle node (ORADB01)
--------------------------------------------------------------------------------------------------------
ORADB01# vi /home/grid/.bash_profile
--------------------------------------------------------------------------------------------------------
# Settings specific to the user "grid"
umask 022
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
if [ $USER = “grid” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
# Grid Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=oradb01.domena.sk; export ORACLE_HOSTNAME
ORACLE_UNQNAME=clsdb; export ORACLE_UNQNAME
ORACLE_BASE=/data/u01/app/grid; export ORACLE_BASE
GRID_HOME=/data/u01/app/grid11204; export GRID_HOME
ORACLE_HOME=$GRID_HOME; export ORACLE_HOME
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
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
BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH
alias sql='sqlplus / as sysasm'
--------------------------------------------------------------------------------------------------------
[6.2] Create a BASH profile (~/.bash_profile) for the user "grid" on the second Oracle node (ORADB02)
--------------------------------------------------------------------------------------------------------
ORADB02# vi /home/grid/.bash_profile
--------------------------------------------------------------------------------------------------------
ORACLE_HOSTNAME=oradb02.domena.sk; export ORACLE_HOSTNAME
ORACLE_SID=+ASM2; export ORACLE_SID
--------------------------------------------------------------------------------------------------------