Oracle 12.2 RAC on Docker
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
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
-
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
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
curl -fsSL https://get.docker.com/ | sh
systemctl start docker
systemctl enable docker
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;
CON_ID
CON_NAME
OPEN MODE
RESTRICTED
2
PDB$SEED
READ ONLY
NO
3
PDB1
READ WRITE
NO