docker-oracle-rac

Oracle 12.2 RAC on Docker

Description

Docker Host Information (on GCE)


Operating System	Centos Linux 7.x
OSType_Architecture	Linux_86_64
Kernel Version	3.10.0-693.5.2.el7.x86_64
CPUs	4
Memory	16GB

Network infomation

Name	Address IP	Type IP	Interface
storage	192.168.100.20	Public IP	eth0
rac1	192.168.100.10	Public IP	eth0
rac1-vip	192.168.100.12	Virtual IP (vip)	-
rac1.priv	10.10.10.10	Private IP	eth1
rac2	192.168.100.11	Public IP	eth0
rac2-vip	192.168.100.13	Virtual IP (vip)	-
rac2.priv	10.10.10.11	Private IP	eth1
scan1.vip	192.168.100.14	SCAN IP	-
scan2.vip	192.168.100.15	SCAN IP	-
scan3.vip	192.168.100.16	SCAN IP	-

Storage infomation

Diskgroup name	use	asm device path	redundancy	size(GB
VOTE	ocr and voting disk	/u01/asmdisks/asm-crs01,/u01/asmdisks/asm-crs02,/u01/asmdisks/asm-crs03	normal	2
DATA	Database files	/u01/asmdisks/asm-data01,/u01/asmdisks/ams-data02	external	40
FRA	flash recovery area	/u01/asmdisks/asm-fra01	external	20

Username	Password
oracle	oracle
grid	oracle
root	oracle

Setup

1. Create swap

dd if=/dev/zero of=/swapfile bs=16384 count=1M
mkswap /swapfile
echo "/swapfile none swap sw 0 0" >> /etc/fstab
chmod 600 /swapfile
swapon -a

2. Install docker

curl -fsSL https://get.docker.com/ | sh

3. enable docker service

systemctl start docker
systemctl enable docker

4. Create asm disks

mkdir -p /depo/asm/

dd if=/dev/zero of=/depo/asm/asm-data01 bs=1024k count=20000
dd if=/dev/zero of=/depo/asm/asm-data02 bs=1024k count=20000
dd if=/dev/zero of=/depo/asm/asm-fra01 bs=1024k count=20000
dd if=/dev/zero of=/depo/asm/asm-crs01 bs=1024k count=2000
dd if=/dev/zero of=/depo/asm/asm-crs02 bs=1024k count=2000
dd if=/dev/zero of=/depo/asm/asm-crs03 bs=1024k count=2000

5. Create /depo/12.2/ path and download Oracle 12c Release 2 (12.2) Clusterware and Database software and locate them on /depo/12.2/

# mkdir -p /depo/12.2/
# ls -al /depo/12.2/
total 6297260
-rw-r--r--. 1 root root 3453696911 Feb 24  2017 linuxx64_12201_database.zip
-rw-r--r--. 1 root root 2994687209 Oct 16 20:07 linuxx64_12201_grid_home.zip

6. Create Docker Network for RAC and NFS&DNS Containers

docker network create --driver=bridge \
--subnet=192.168.100.0/24 --gateway=192.168.100.1 \
--ip-range=192.168.100.128/25 pub 

docker network create --driver=bridge \
--subnet=10.10.10.0/24 --gateway=10.10.10.1 \
--ip-range=10.10.10.128/25 priv

7. Start NFS&DNS Server Container

docker run \
--detach \
--privileged \
-v /sys/fs/cgroup:/sys/fs/cgroup:ro \
--volume=/depo/asm/:/asmdisks \
-e TZ=Europe/Istanbul \
--name nfs \
--hostname nfs.example.com \
--net pub \
--ip 192.168.100.20 \
melihsavdert/docker-nfs-dns-server

8. Start two containers (rac1 and rac2) for RAC installation (some ports have been opened for OEM13c installation in the future)

docker run --rm \
--privileged \
--detach \
--name rac1 \
-h rac1.example.com \
--net pub \
--add-host nfs:192.168.100.20 \
--ip 192.168.100.10 \
-p 1521:1521 -p 9803:9803 -p 1158:1158 \
-p 5500:5500 -p 7803:7803 -p 7102:7102 \
--shm-size 2048m \
-e TZ=Europe/Istanbul \
-v /sys/fs/cgroup:/sys/fs/cgroup:ro \
--volume /depo:/software \
--volume /boot:/boot \
melihsavdert/docker-oracle-rac

docker run --rm \
--privileged \
--detach \
--name rac2 \
-h rac2.example.com \
--net pub \
--add-host nfs:192.168.100.20 \
--ip 192.168.100.11 \
-p 1522:1521 -p 9804:9803 -p 1159:1158 \
-p 5501:5500 -p 7804:7803 -p 7103:7102 \
--shm-size 2048m \
-e TZ=Europe/Istanbul \
-v /sys/fs/cgroup:/sys/fs/cgroup:ro \
--volume /depo:/software \
--volume /boot:/boot \
melihsavdert/docker-oracle-rac

9. Connect the private network to the RAC cluster containers.

docker network connect --ip 10.10.10.10 priv rac1
docker network connect --ip 10.10.10.11 priv rac2

10. Configure DNS for RAC cluster containers

docker exec -it rac1 cp /etc/resolv.conf /tmp/resolv.conf && \
docker exec -it rac1 sed -i '/search/s/$/ example.com\nnameserver 192.168.100.20/' /tmp/resolv.conf && \
docker exec -it rac1 cp -f /tmp/resolv.conf /etc/resolv.conf 

docker exec -it rac2 cp /etc/resolv.conf /tmp/resolv.conf && \
docker exec -it rac2 sed -i '/search/s/$/ example.com\nnameserver 192.168.100.20/' /tmp/resolv.conf && \
docker exec -it rac2 cp -f /tmp/resolv.conf /etc/resolv.conf

11. Mount NFS server for RAC cluster containers and give permissions

docker exec -it rac1 mount /u01/asmdisks/ && \
docker exec -it rac1 chown -R grid:asmadmin /u01/asmdisks/ && \
docker exec -it rac1 chmod -R 777 /u01/asmdisks/ 

docker exec -it rac2 mount /u01/asmdisks/ && \
docker exec -it rac2 chown -R grid:asmadmin /u01/asmdisks/ && \
docker exec -it rac2 chmod -R 777 /u01/asmdisks/

12. Edit /etc/hosts file each nodes as follows

docker exec -it rac1 vi /etc/hosts
docker exec -it rac2 vi /etc/hosts

# Public
192.168.100.10 rac1.example.com rac1
192.168.100.11 rac2.example.com rac2
# Private
#10.10.10.10 rac1-priv.example.com rac1-priv
#10.10.10.11 rac2-priv.example.com rac2-priv
# Virtual
#192.168.100.12 rac1-vip.example.com rac1-vip
#192.168.100.13 rac2-vip.example.com rac2-vip
# SCAN
#192.168.100.14 rac-scan.example.com rac-scan
#192.168.100.15 rac-scan.example.com rac-scan
#192.168.100.16 rac-scan.example.com rac-scan

13. Check DNS is healthy each nodes

$ docker exec -it rac1 nslookup rac-scan
Server:		192.168.100.20
Address:	192.168.100.20#53

Name:	rac-scan.example.com
Address: 192.168.100.16
Name:	rac-scan.example.com
Address: 192.168.100.15
Name:	rac-scan.example.com
Address: 192.168.100.14

$ docker exec -it rac2 nslookup rac-scan
Server:		192.168.100.20
Address:	192.168.100.20#53

Name:	rac-scan.example.com
Address: 192.168.100.15
Name:	rac-scan.example.com
Address: 192.168.100.16
Name:	rac-scan.example.com
Address: 192.168.100.14

14. Copy Oracle Database and Grid Infrastructure software inside the rac1 container

docker exec -it rac1 su - oracle -c ' \
unzip -q /software/12.2/linuxx64_12201_database.zip -d /u01/software/'

docker exec -it rac1 su - grid -c ' \
unzip -q /software/12.2/linuxx64_12201_grid_home.zip -d /u01/app/12.2.0.1/grid/'

15. Install the cvuqdisk package on each cluster nodes

docker exec -it rac1 rpm -Uvh /u01/app/12.2.0.1/grid/cv/rpm/cvuqdisk*
docker exec -it rac1 scp /u01/app/12.2.0.1/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm [email protected]:/root
docker exec -it rac2 rpm -Uvh /root/cvuqdisk*

16. Edit grid user .bash_profile for ORACLE_SID as follows

docker exec -it rac1 su - grid -c ' \
echo -e "export ORACLE_SID=+ASM1" >> /home/grid/.bash_profile && source /home/grid/.bash_profile'

docker exec -it rac2 su - grid -c ' \
echo -e "export ORACLE_SID=+ASM2" >> /home/grid/.bash_profile && source /home/grid/.bash_profile'

17. Use the cluvfy stage -pre crsinst command with either the -file, -n, -flex, or -upgrade parameters to check the specified nodes before installing or upgrading Oracle Clusterware.

docker exec -it rac1 su - grid -c ' /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre crsinst -fixupnoexec -n rac1,rac2 -verbose'

18. Configure the Grid Infrastructure by running the following as the "grid" user.

docker exec -it rac1 su - grid -c ' \
/u01/app/12.2.0.1/grid/gridSetup.sh -silent \
-ignorePrereqFailure \
-responseFile /u01/app/12.2.0.1/grid/install/response/gridsetup.rsp \
INVENTORY_LOCATION=/u01/app/oraInventory \
oracle.install.option=CRS_CONFIG \
ORACLE_BASE=/u01/app/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSOPER=asmoper \
oracle.install.asm.OSASM=asmadmin \
oracle.install.crs.config.gpnp.scanName=rac-scan \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.ClusterConfiguration=STANDALONE \
oracle.install.crs.config.configureAsExtendedCluster=false \
oracle.install.crs.config.clusterName=rac \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.crs.config.clusterNodes=rac1.example.com:rac1-vip.example.com:HUB,rac2.example.com:rac2-vip.example.com:HUB \
oracle.install.crs.config.networkInterfaceList=eth0:192.168.100.0:1,eth1:10.10.10.0:5 \
oracle.install.asm.configureGIMRDataDG=false \
oracle.install.asm.storageOption=ASM \
oracle.install.asmOnNAS.configureGIMRDataDG=false \
oracle.install.asm.SYSASMPassword=oracle \
oracle.install.asm.diskGroup.name=DATA \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.install.asm.diskGroup.AUSize=4 \
oracle.install.asm.diskGroup.disks=/u01/asmdisks/asm-data01,/u01/asmdisks/asm-data02 \
oracle.install.asm.diskGroup.diskDiscoveryString=/u01/asmdisks/asm* \
oracle.install.asm.monitorPassword=oracle \
oracle.install.asm.configureAFD=false \
oracle.install.crs.configureRHPS=false \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.config.managementOption=NONE \
oracle.install.config.omsPort=0 \
oracle.install.crs.rootconfig.executeRootScript=false \
-waitForCompletion'

19. Execute the root script each nodes

As a root user, execute the following script(s):
	1. /u01/app/12.2.0.1/grid/root.sh

docker exec -it rac1 /u01/app/12.2.0.1/grid/root.sh
docker exec -it rac2 /u01/app/12.2.0.1/grid/root.sh

20. As install user, execute the following command to complete the configuration

docker exec -it rac1 su - grid -c ' \
/u01/app/12.2.0.1/grid/gridSetup.sh -executeConfigTools -silent \
-ignorePrereqFailure \
-responseFile /u01/app/12.2.0.1/grid/install/response/gridsetup.rsp \
INVENTORY_LOCATION=/u01/app/oraInventory \
oracle.install.option=CRS_CONFIG \
ORACLE_BASE=/u01/app/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSOPER=asmoper \
oracle.install.asm.OSASM=asmadmin \
oracle.install.crs.config.gpnp.scanName=rac-scan \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.ClusterConfiguration=STANDALONE \
oracle.install.crs.config.configureAsExtendedCluster=false \
oracle.install.crs.config.clusterName=rac \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.crs.config.clusterNodes=rac1.example.com:rac1-vip.example.com:HUB,rac2.example.com:rac2-vip.example.com:HUB \
oracle.install.crs.config.networkInterfaceList=eth0:192.168.100.0:1,eth1:10.10.10.0:5 \
oracle.install.asm.configureGIMRDataDG=false \
oracle.install.asm.storageOption=ASM \
oracle.install.asmOnNAS.configureGIMRDataDG=false \
oracle.install.asm.SYSASMPassword=oracle \
oracle.install.asm.diskGroup.name=DATA \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.install.asm.diskGroup.AUSize=4 \
oracle.install.asm.diskGroup.disks=/u01/asmdisks/asm-data01,/u01/asmdisks/asm-data02 \
oracle.install.asm.diskGroup.diskDiscoveryString=/u01/asmdisks/asm* \
oracle.install.asm.monitorPassword=oracle \
oracle.install.asm.configureAFD=false \
oracle.install.crs.configureRHPS=false \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.config.managementOption=NONE \
oracle.install.config.omsPort=0 \
oracle.install.crs.rootconfig.executeRootScript=false \
-waitForCompletion'

21. Check status of grid software

docker exec -it rac1 su - grid -c ' crsctl check cluster -all'
docker exec -it rac1 su - grid -c ' crs_stat -t'
docker exec -it rac1 su - grid -c ' crsctl stat res -t'

22. Create FRA disk group for Fast Recovery Area

docker exec -it rac1 su - grid -c ' \
asmca -silent -createDiskGroup \
       -diskGroupName FRA \
           -disk '/u01/asmdisks/asm-fra01*' \
       -redundancy EXTERNAL \
      -au_size 4'

23. Edit oracle user .bash_profile for ORACLE_SID and ORACLE_UNQNAME as follows

docker exec -it rac1 su - oracle -c ' \
echo -e "
export ORACLE_UNQNAME=RAC\n\
export ORACLE_SID=RAC1\n\
" >> /home/oracle/.bash_profile'

docker exec -it rac2 su - oracle -c ' \
echo -e "
export ORACLE_UNQNAME=RAC\n\
export ORACLE_SID=RAC2\n\
" >> /home/oracle/.bash_profile'

24. Install the Database Software with softwareonly option by running the following as the "oracle" user.

docker exec -it rac1 su - oracle -c ' \
/u01/software/database/runInstaller -silent -ignoreSysPrereqs -ignorePrereqFailure \
-responseFile /u01/software/database/response/db_install.rsp   \
oracle.install.option=INSTALL_DB_SWONLY \
SELECTED_LANGUAGES=en \
UNIX_GROUP_NAME=oinstall \
ORACLE_BASE=$ORACLE_BASE \
ORACLE_HOME=$ORACLE_HOME \
INVENTORY_LOCATION=/u01/app/oraInventory \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSOPER_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
oracle.install.db.CLUSTER_NODES=rac1,rac2 \
oracle.install.db.isRACOneInstall=false \
oracle.install.db.rac.serverpoolCardinality=0 \
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
oracle.install.db.ConfigureAsContainerDB=false \
oracle.install.db.config.starterdb.memoryOption=false \
oracle.install.db.config.starterdb.installExampleSchemas=false \
oracle.install.db.config.starterdb.managementOption=DEFAULT \
oracle.install.db.config.starterdb.omsPort=0 \
oracle.install.db.config.starterdb.enableRecovery=false \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true \
-waitForCompletion'

25. Execute the root script each nodes

As a root user, execute the following script(s):
	1. /u01/app/oracle/product/12.2.0.1/dbhome_1/root.sh

docker exec -it rac1 /u01/app/oracle/product/12.2.0.1/dbhome_1/root.sh
docker exec -it rac2 /u01/app/oracle/product/12.2.0.1/dbhome_1/root.sh

26. If you want you can delete database software file

docker exec -it rac1 rm -rf /u01/software/database

27. Use the cluvfy stage -pre dbcfg command to check the specified nodes before configuring an Oracle RAC database to verify whether your system meets all of the criteria for creating a database or for making a database configuration change.

docker exec -it rac1 su - oracle -c ' /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre dbcfg -fixup -n rac1,rac2 -d $ORACLE_HOME -verbose'

28. Create a container database named RAC with one pluggable database named PDB1:

docker exec -it rac1 su - oracle -c ' \
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
 -gdbName RAC \
 -SysPassword oracle \
 -createAsContainerDatabase true \
    -numberofPDBs 1 \
    -pdbName PDB1 \
    -pdbAdminUserName pdba \
    -pdbAdminPassword oracle \
 -SystemPassword oracle \
 -emConfiguration none  \
 -redoLogFileSize 384 \
 -recoveryAreaDestination +FRA \
 -storageType ASM \
   -asmsnmpPassword oracle \
   -asmSysPassword oracle  \
   -diskGroupName +DATA \
 -listeners LISTENER \
-totalMemory 4096 \
 -registerWithDirService false \
 -characterSet AL32UTF8 \
 -nationalCharacterSet AL16UTF16 \
 -databaseType MULTIPURPOSE \
 -nodelist rac1,rac2'

29. Check status of Cluster and Databases

$ docker exec -it rac1 su - grid -c 'crsctl stat res -t'
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.chad
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       rac1                     169.254.89.177 10.10
                                                             .10.10,STABLE
ora.asm
      1        ONLINE  ONLINE       rac1                     Started,STABLE
      2        ONLINE  ONLINE       rac2                     Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac1                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       rac1                     Open,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac.db
      1        ONLINE  ONLINE       rac1                     Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             .1/dbhome_1,STABLE
      2        ONLINE  ONLINE       rac2                     Open,HOME=/u01/app/o
                                                             racle/product/12.2.0
                                                             .1/dbhome_1,STABLE
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac2.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rac1                     STABLE
--------------------------------------------------------------------------------

$ docker exec -it rac1 su - grid -c 'crs_stat -t'
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1        
ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....AF.lsnr ora....er.type OFFLINE   OFFLINE               
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2        
ora....N2.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N3.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.chad       ora.chad.type  ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1        
ora.mgmtdb     ora....db.type ONLINE    ONLINE    rac1        
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora.qosmserver ora....er.type ONLINE    ONLINE    rac1        
ora.rac.db     ora....se.type ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2        
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    rac1        
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    rac1

I have checked GIMR configuration database and some other components with:

$ docker exec -it rac1 su - grid -c 'srvctl config mgmtdb'

Database unique name: _mgmtdb
Database name: 
Oracle home: <CRS home>
Oracle user: grid
Spfile: +DATA/_MGMTDB/PARAMETERFILE/spfile.270.961447821
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: GIMR_DSCREP_10
PDB service: GIMR_DSCREP_10
Cluster name: rac
Database instance: -MGMTDB

$ docker exec -it rac1 su - grid -c 'srvctl status database -d RAC'
Instance RAC1 is running on node rac1
Instance RAC2 is running on node rac2

$ docker exec -it rac1 su - grid -c 'srvctl config database -d RAC'
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: +DATA/RAC/PARAMETERFILE/spfile.298.961450881
Password file: +DATA/RAC/PASSWORD/pwdrac.282.961450333
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: FRA,DATA
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: dba
Database instances: RAC1,RAC2
Configured nodes: rac1,rac2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed

$ docker exec -it rac1 su - grid -c 'lsnrctl status'
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 30-NOV-2017 21:54:30

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                30-NOV-2017 20:29:11
Uptime                    0 days 1 hr. 25 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.2.0.1/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.10)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.12)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_FRA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "5f38a9ffc2956d8ee0530a64a8c03204" has 1 instance(s).
  Instance "RAC1", status READY, has 1 handler(s) for this service...
Service "RAC" has 1 instance(s).
  Instance "RAC1", status READY, has 1 handler(s) for this service...
Service "RACXDB" has 1 instance(s).
  Instance "RAC1", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "RAC1", status READY, has 1 handler(s) for this service...
The command completed successfully

docker exec -it rac1 su - grid -c 'srvctl status diskgroup -diskgroup FRA'
docker exec -it rac1 su - grid -c 'srvctl status diskgroup -diskgroup DATA'
docker exec -it rac1 su - grid -c 'crsctl query css votedisk'

docker exec -it rac1 su - oracle -c 'sqlplus / as sysdba'

SQL> select name, cdb from v$database;

NAME	CDB
RAC	YES

SQL> show pdbs

CON_ID	CON_NAME	OPEN MODE	RESTRICTED
2	PDB$SEED	READ ONLY	NO
3	PDB1	READ WRITE	NO

Name		Name	Last commit message	Last commit date
Latest commit History 33 Commits
Dockerfile		Dockerfile
README.md		README.md

msavdert/docker-oracle-rac12c

Folders and files

Latest commit

History

Repository files navigation

docker-oracle-rac

Description

Setup

1. Create swap

2. Install docker

3. enable docker service

4. Create asm disks

5. Create /depo/12.2/ path and download Oracle 12c Release 2 (12.2) Clusterware and Database software and locate them on /depo/12.2/

6. Create Docker Network for RAC and NFS&DNS Containers

7. Start NFS&DNS Server Container

8. Start two containers (rac1 and rac2) for RAC installation (some ports have been opened for OEM13c installation in the future)

9. Connect the private network to the RAC cluster containers.

10. Configure DNS for RAC cluster containers

11. Mount NFS server for RAC cluster containers and give permissions

12. Edit /etc/hosts file each nodes as follows

13. Check DNS is healthy each nodes

14. Copy Oracle Database and Grid Infrastructure software inside the rac1 container

15. Install the cvuqdisk package on each cluster nodes

16. Edit grid user .bash_profile for ORACLE_SID as follows

17. Use the cluvfy stage -pre crsinst command with either the -file, -n, -flex, or -upgrade parameters to check the specified nodes before installing or upgrading Oracle Clusterware.

18. Configure the Grid Infrastructure by running the following as the "grid" user.

19. Execute the root script each nodes

20. As install user, execute the following command to complete the configuration

21. Check status of grid software

22. Create FRA disk group for Fast Recovery Area

23. Edit oracle user .bash_profile for ORACLE_SID and ORACLE_UNQNAME as follows

24. Install the Database Software with softwareonly option by running the following as the "oracle" user.

25. Execute the root script each nodes

26. If you want you can delete database software file

27. Use the cluvfy stage -pre dbcfg command to check the specified nodes before configuring an Oracle RAC database to verify whether your system meets all of the criteria for creating a database or for making a database configuration change.

28. Create a container database named RAC with one pluggable database named PDB1:

29. Check status of Cluster and Databases

I have checked GIMR configuration database and some other components with:

SQL> select name, cdb from v$database;

SQL> show pdbs

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Packages