12c ASM on EC2 with EM Express

My setup consisted of an EC2 instance that was configured using the "yum install oracle-rdbms-server-12cR1-preinstall" and already had the 12c database s/w installed (documented at the beginning here).

 

### install ###

-check if oracleasm exists
[ec2-user@EC2 app]$ rpm -qa | grep oracleasm

-check host
[ec2-user@EC2 app]$ uname -a
Linux EC2  2.6.32-431.17.1.el6.x86_64 #1 SMP Fri Apr 11 17:27:00 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux

-download the appropriate ASMLIB files from oracle
https://search.oracle.com/search/search?start=1&search_p_main_operator=all&q=ASMLib

-copy them to server
[ec2-user@EC2 app]$ ls -lrt *.rpm
-rw-r--r--. 1 ec2-user ec2-user 74984 Feb 17 11:06 oracleasm-support-2.1.8-1.el6.x86_64.rpm
-rw-r--r--. 1 ec2-user ec2-user 13300 Feb 17 11:07 oracleasmlib-2.0.4-1.el6.x86_64.rpm

-do some updates
[ec2-user@EC2 app]$ sudo yum install kmod-oracleasm
Loaded plugins: amazon-id, rhui-lb, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package kmod-oracleasm.x86_64 0:2.0.8-4.el6_6 will be installed
--> Processing Dependency: kernel(get_user_pages_fast) = 0xa2046a95 for package: kmod-oracleasm-2.0.8-4.el6_6.x86_64
--> Processing Dependency: kernel >= 2.6.32-504.el6 for package: kmod-oracleasm-2.0.8-4.el6_6.x86_64
--> Running transaction check
---> Package kernel.x86_64 0:2.6.32-504.8.1.el6 will be installed
--> Processing Dependency: kernel-firmware >= 2.6.32-504.8.1.el6 for package: kernel-2.6.32-504.8.1.el6.x86_64
--> Running transaction check
---> Package kernel-firmware.noarch 0:2.6.32-431.17.1.el6 will be updated
---> Package kernel-firmware.noarch 0:2.6.32-504.8.1.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================
 Package                         Arch                   Version                               Repository                  Size
===============================================================================================================================
Installing:
 kmod-oracleasm                  x86_64                 2.0.8-4.el6_6                         ol6_latest                  35 k
Installing for dependencies:
 kernel                          x86_64                 2.6.32-504.8.1.el6                    ol6_latest                  29 M
Updating for dependencies:
 kernel-firmware                 noarch                 2.6.32-504.8.1.el6                    ol6_latest                  14 M

Transaction Summary
===============================================================================================================================
Install       2 Package(s)
Upgrade       1 Package(s)

Total download size: 44 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): kernel-2.6.32-504.8.1.el6.x86_64.rpm                                                             |  29 MB     00:00
(2/3): kernel-firmware-2.6.32-504.8.1.el6.noarch.rpm                                                    |  14 MB     00:00
(3/3): kmod-oracleasm-2.0.8-4.el6_6.x86_64.rpm                                                          |  35 kB     00:00
-------------------------------------------------------------------------------------------------------------------------------
Total                                                                                           32 MB/s |  44 MB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Updating   : kernel-firmware-2.6.32-504.8.1.el6.noarch                                                                   1/4
  Installing : kernel-2.6.32-504.8.1.el6.x86_64                                                                            2/4
  Installing : kmod-oracleasm-2.0.8-4.el6_6.x86_64                                                                         3/4
  Cleanup    : kernel-firmware-2.6.32-431.17.1.el6.noarch                                                                  4/4
  Verifying  : kernel-firmware-2.6.32-504.8.1.el6.noarch                                                                                             1/4
  Verifying  : kernel-2.6.32-504.8.1.el6.x86_64                                                                                                      2/4
  Verifying  : kmod-oracleasm-2.0.8-4.el6_6.x86_64                                                                                                   3/4
  Verifying  : kernel-firmware-2.6.32-431.17.1.el6.noarch                                                                                            4/4

Installed:
  kmod-oracleasm.x86_64 0:2.0.8-4.el6_6

Dependency Installed:
  kernel.x86_64 0:2.6.32-504.8.1.el6

Dependency Updated:
  kernel-firmware.noarch 0:2.6.32-504.8.1.el6

Complete!

-install oracleasm support and lib
[ec2-user@EC2 app]$ sudo rpm -Uvh oracleasm-support-2.1.8-1.el6.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracleasm-support      ########################################### [100%]

[ec2-user@EC2 app]$ sudo rpm -Uvh oracleasmlib-2.0.4-1.el6.x86_64.rpm
Preparing...                ########################################### [100%]
   1:oracleasmlib           ########################################### [100%]

[ec2-user@EC2 app]$  rpm -qa | grep oracleasm
oracleasm-support-2.1.8-1.el6.x86_64
oracleasmlib-2.0.4-1.el6.x86_64

[ec2-user@EC2 app]$ sudo  rpm -q -i oracleasmlib
Name        : oracleasmlib                 Relocations: (not relocatable)
Version     : 2.0.4                             Vendor: Oracle Corporation
Release     : 1.el6                         Build Date: Mon 26 Mar 2012 04:22:44 PM EDT
Install Date: Wed 18 Feb 2015 04:31:22 AM EST      Build Host: ca-build44.us.oracle.com
Group       : System Environment/Kernel     Source RPM: oracleasmlib-2.0.4-1.el6.src.rpm
Size        : 27192                            License: Oracle Corporation
Signature   : RSA/8, Mon 26 Mar 2012 04:22:51 PM EDT, Key ID 72f97b74ec551f03
Packager    : Joel Becker 
URL         : http://oss.oracle.com/
Summary     : The Oracle Automatic Storage Management library userspace code.
Description :
The Oracle userspace library for Oracle Automatic Storage Management

-create 2 new disks
-add new EBS volumes through the AWS console and attach to instance (xvdf & xvdg)

[ec2-user@EC2 app]$ lsblk
NAME  MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda1 202:1    0  10G  0 disk /
xvdb  202:16   0  20G  0 disk /data
xvdc  202:32   0  20G  0 disk /app
xvdf  202:80   0  10G  0 disk
xvdg  202:96   0  10G  0 disk

[ec2-user@EC2 app]$ sudo fdisk /dev/xvdf
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x6d8115d3.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1305, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-1305, default 1305):
Using default value 1305

Command (m for help): p

Disk /dev/xvdf: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x6d8115d3

    Device Boot      Start         End      Blocks   Id  System
/dev/xvdf1               1        1305    10482381   83  Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[ec2-user@EC2 app]$ sudo fdisk /dev/xvdg
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x3c3e4e23.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1305, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-1305, default 1305):
Using default value 1305

Command (m for help): p

Disk /dev/xvdg: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x3c3e4e23

    Device Boot      Start         End      Blocks   Id  System
/dev/xvdg1               1        1305    10482381   83  Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[ec2-user@EC2 ~]$ sudo /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting  without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface [oracle]: oracle
Default group to own the driver interface [oinstall]: oinstall
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]

[ec2-user@EC2 ~]$ sudo /etc/init.d/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes

-create 2 ASM disks
[ec2-user@EC2 ~]$ sudo oracleasm createdisk ASM1 /dev/xvdf1
Writing disk header: done
Instantiating disk: done
[ec2-user@EC2 ~]$ sudo oracleasm createdisk ASM2 /dev/xvdg1
Writing disk header: done
Instantiating disk: done
[ec2-user@EC2 ~]$ sudo oracleasm listdisks
ASM1
ASM2
[ec2-user@EC2 ~]$ sudo oracleasm querydisk /dev/xvdf1
Device "/dev/xvdf1" is marked an ASM disk with the label "ASM1"

-make directory
[oracle@EC2 software]$ pwd
/app/software
[oracle@EC2 software]$ mkdir 12cGrid
[oracle@EC2 software]$ cd 12cGrid
[oracle@EC2 12cGrid]$ pwd
/app/software/12cGrid

-unzip grid software
[oracle@EC2 app]$ unzip linuxamd64_12102_grid_1of2.zip -d /app/software/12cGrid
[oracle@EC2 app]$ unzip linuxamd64_12102_grid_2of2.zip -d /app/software/12cGrid

[oracle@EC2 grid]$ cd /app/software/12cGrid/grid
[oracle@EC2 grid]$ ls -lrt
total 44
-rwxr-xr-x.  1 oracle oinstall  500 Feb  6  2013 welcome.html
-rwxr-xr-x.  1 oracle oinstall 5085 Dec 20  2013 runcluvfy.sh
-rwxr-xr-x.  1 oracle oinstall 8534 Jul  7  2014 runInstaller
drwxr-xr-x.  2 oracle oinstall 4096 Jul  7  2014 rpm
drwxrwxr-x.  2 oracle oinstall 4096 Jul  7  2014 sshsetup
drwxrwxr-x.  2 oracle oinstall 4096 Jul  7  2014 response
drwxr-xr-x. 14 oracle oinstall 4096 Jul  7  2014 stage
drwxr-xr-x.  4 oracle oinstall 4096 Feb 18 05:35 install

[oracle@EC2 grid]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 415 MB.   Actual 4133 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1199 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-02-18_06-01-29AM. Please wait ...



-select configure grid for standalone



-choose your language


-select both disks


-specify passwords


-add OEM settings


-specify groups


-specify install location (approx 7GB needed)


-leave root unchecked (will be done in separate terminal)


-review and check


-review summary


-install running






-run root commands in another window



[ec2-user@EC2 grid]$ sudo ./root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /app/oracle/product/12.1.0/grid

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.
Using configuration parameter file: /app/oracle/product/12.1.0/grid/crs/install/crsconfig_params

LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node EC2 successfully pinned.
2015/02/18 07:11:54 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'

EC2     2015/02/18 07:12:15     /app/oracle/product/12.1.0/grid/cdata/EC2/backup_20150218_071215.olr     0 

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'EC2'
CRS-2673: Attempting to stop 'ora.evmd' on 'EC2'
CRS-2677: Stop of 'ora.evmd' on 'EC2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'EC2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2015/02/18 07:16:06 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

-install continues


-completed


-check processes
[oracle@EC2 grid]$ ps -ef | grep pmon
oracle     303  2675  0 07:21 pts/2    00:00:00 grep pmon
oracle   32396     1  0 07:20 ?        00:00:00 asm_pmon_+ASM

[oracle@EC2 ~]$ ps -ef | grep tns
oracle   32085     1  0 07:19 ?        00:00:00 /app/oracle/product/12.1.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit

-check listener
[oracle@EC2 ~]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-FEB-2015 08:29:53

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=EC2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                18-FEB-2015 07:19:08
Uptime                    0 days 1 hr. 10 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/12.1.0/grid/network/admin/listener.ora
Listener Log File         /app/oracle/diag/tnslsnr/EC2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EC2.eu-west-1.compute.internal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully

-setup environment
[oracle@EC2 ~]$ cat set_asm.env
export ORACLE_BASE=/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/grid;
export ORACLE_SID=+ASM;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

-ASM+ checks
[oracle@EC2 ~]$ . ./set_asm.env
[oracle@EC2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 18 07:31:22 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> select INSTANCE_NAME, status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
+ASM             STARTED

SQL> exit

-crsctl checks
[oracle@EC2 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       EC2             STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       EC2             STABLE
ora.asm
               ONLINE  ONLINE       EC2             Started,STABLE
ora.ons
               OFFLINE OFFLINE      EC2             STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       EC2             STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       EC2             STABLE
--------------------------------------------------------------------------------

-asmcmd checks
[oracle@EC2 ~]$ asmcmd
ASMCMD> ls
DATA/

ASMCMD> ls -l
State    Type    Rebal  Name
MOUNTED  NORMAL  N      DATA/

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20472    20346                0           10173              0             N  DATA/

## 12c DBCA using ASM ##

[oracle@EC2 ~]$ . ./set_12c.env
[oracle@EC2 ~]$ cd $ORACLE_HOME
[oracle@EC2 12c]$ cd bin
[oracle@EC2 bin]$ ./dbca

-create database


-enter details


-validation checks


-review summary


-dbca in progress


-take note of results


-check pmon processes
[oracle@EC2 bin]$ ps -ef | grep pmon
oracle    2806     1  0 09:02 ?        00:00:00 ora_pmon_CDB12C
oracle   32396     1  0 07:20 ?        00:00:00 asm_pmon_+ASM

-check DB registered with listener
[oracle@EC2 bin]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-FEB-2015 09:07:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=EC2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                18-FEB-2015 07:19:08
Uptime                    0 days 1 hr. 48 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/12.1.0/grid/network/admin/listener.ora
Listener Log File         /app/oracle/diag/tnslsnr/EC2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EC2.eu-west-1.compute.internal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=EC2.eu-west-1.compute.internal)(PORT=5500))(Security=(my_wallet_directory=/app/oracle/admin/CDB12C/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "CDB12C" has 1 instance(s).
  Instance "CDB12C", status READY, has 1 handler(s) for this service...
Service "CDB12CXDB" has 1 instance(s).
  Instance "CDB12C", status READY, has 1 handler(s) for this service...
Service "pdb12c" has 1 instance(s).
  Instance "CDB12C", status READY, has 1 handler(s) for this service...
The command completed successfully

-login to database
[oracle@EC2 ~]$ export ORACLE_SID=CDB12C;
[oracle@EC2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 18 09:08:19 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> select cdb from v$database;

CDB
---
YES

SQL> show pdbs

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

SQL> select TABLESPACE_NAME, FILE_NAME from dba_data_files;

TABLESPACE_NAME FILE_NAME
--------------- ------------------------------------------------------------
SYSTEM          +DATA/CDB12C/DATAFILE/system.258.871980457
SYSAUX          +DATA/CDB12C/DATAFILE/sysaux.257.871980381
USERS           +DATA/CDB12C/DATAFILE/users.259.871980543
UNDOTBS1        +DATA/CDB12C/DATAFILE/undotbs1.260.871980543

SQL> select TABLESPACE_NAME, FILE_NAME from cdb_data_files;

TABLESPACE_NAME FILE_NAME
--------------- --------------------------------------------------------------------------------
SYSTEM          +DATA/CDB12C/DATAFILE/system.258.871980457
SYSAUX          +DATA/CDB12C/DATAFILE/sysaux.257.871980381
UNDOTBS1        +DATA/CDB12C/DATAFILE/undotbs1.260.871980543
USERS           +DATA/CDB12C/DATAFILE/users.259.871980543
SYSTEM          +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/system.274.871981391
SYSAUX          +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/sysaux.275.871981391
USERS           +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/users.277.871981449

SQL> SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME
  2  FROM DBA_PDBS p, CDB_DATA_FILES d
  3  WHERE p.PDB_ID = d.CON_ID
  4  ORDER BY p.PDB_ID;

PDB_ID PDB_NAME FILE_ID TABLESPACE FILE_NAME
------ -------- ------- ---------- --------------------------------------------------------------------------------
     3 PDB12C         8 SYSTEM     +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/system.274.871981391
     3 PDB12C        10 USERS      +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/users.277.871981449
     3 PDB12C         9 SYSAUX     +DATA/CDB12C/0F5E473EA1C90C3BE0534100000AC88E/DATAFILE/sysaux.275.871981391

SQL> exit

-To shutdown
[oracle@EC2 ~]$ . ./set_asm.env
[oracle@EC2 ~]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'EC2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'EC2'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'EC2' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'EC2'
CRS-2677: Stop of 'ora.evmd' on 'EC2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'EC2'
CRS-2677: Stop of 'ora.cssd' on 'EC2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'EC2' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[oracle@EC2 ~]$ ps -ef | grep pmon
oracle    4342  4084  0 09:53 pts/2    00:00:00 grep pmon
[oracle@EC2 ~]$ ps -ef | grep tns
oracle    4344  4084  0 09:53 pts/2    00:00:00 grep tns


## OEM ##

Note the URL: https://EC2:5500/em from the final DBCA screen

-Launch the AWS console, select Security Groups and add an inbound rule for 5500. 



-Save and launch the URL again



-Login with system