Useful EMCLI commands for Pluggable Database-As-A-Service

This is a quick note on some useful EMCLI commands for enabling and managing Pluggable Database-as-a-Service (PDBaaS).

Get Paas Zone details
emcli get_paas_zone_detail -name="DBA_Test_Zone"

  Name                            DBA_Test_Zone
  Named Credentials               NC_HOST_2012-10-20-160312
  Number of Hosts                 5
  Roles                           CLOUD_DBA
  Maximum Memory Allocation (%)   90
  Maximum CPU Utilization (%)     80

Update PaaS zone placement policy constraints
emcli update_paas_zone -name="DBA_Test_Zone" -memory_utilization=99 -cpu_utilization=99
PaaS Infrastructure Zone "DBA_Test_Zone" updated successfully. 

Add host to PaaS Zone
emcli update_paas_zone -name="DBA_Test_Zone" -add_hosts="linuxhost3.example.com"
PaaS Infrastructure Zone "DBA_Test_Zone" updated successfully.

Find the members of a PaaS Zone
emcli get_system_members -name="DBA_Test_Zone" -type="self_service_zone"
Source Target Name  Member Target Name         Member Target Type  Level  Key Member
DBA_Test_Zone       Schema_Pool_11203          schaas_pool         1
DBA_Test_Zone       Schema_Pool_11202          schaas_pool         1
DBA_Test_Zone       aixhost1.example.com       host                1
DBA_Test_Zone       linuxhost1.example.com     host                1
DBA_Test_Zone       aixhost2.example.com       host                1
DBA_Test_Zone       aixhost3.example.com       host                1
DBA_Test_Zone       linuxhost2.example.com     host                1
DBA_Test_Zone       linuxhost3.example.com     host                1
DBA_Test_Zone       Single Instance AIX Pool   oracle_cloud_zone   1
                                                                                                                               
Create a PDB Pool
emcli create_pool -name="Pluggable DB Pool" -target_type="pdbaas_pool" -paas_zone="DBA_Test_Zone" -members="orclcdb" -description="Oracle Database 12c Pool for Pluggable Databases" -member_constraints="PLATFORM_CDB=226,TARGET_TYPE_CDB=oracle_database,VERSION_CDB=12.1.0.1.0"
Software Pool "Pluggable DB Pool" created successfully.

View the constraints for a PDBaaS pool
emcli get_pool_allowed_member_constraints -target_type=pdbaas_pool
Name                  Value                 Description

PLATFORM_CDB          197                   HP-UX Itanium
                      59                    HP-UX PA-RISC (64-bit)
                      212                   IBM AIX on POWER Systems (64-bit)
                      209                   IBM: Linux on System z
                      46                    Linux x86
                      226                   Linux x86-64
                      912                   Microsoft Windows (32-bit)
                      208                   Microsoft Windows Itanium (64-bit)
                      233                   Microsoft Windows x64 (64-bit)
                      23                    Oracle Solaris on SPARC (64-bit)
                      267                   Oracle Solaris on x86-64 (64-bit)

TARGET_TYPE_CDB       rac_database          Cluster Database
                      oracle_database       Database Instance

VERSION_CDB           12.1.0.1.0            12.1.0.1.0
                                                                                                                                                
Display details about the Pool
emcli get_pool_detail -name="Pluggable DB Pool" -target_type=pdbaas_pool

  Name                            Pluggable DB Pool
  Target Type                     pdbaas_pool
  Description                     Oracle Database 12c Pool for Pluggable Databases
  Paas Infrastructure Zone        DBA_Test_Zone
  Number of Members               1
  Placement Constraints
  Member Constraints              PLATFORM_CDB : Linux x86-64 , TARGET_TYPE_CDB : Database Instance
                                   , VERSION_CDB : 12.1.0.1.0
Find all pluggable databases
emcli get_targets -target="oracle_pdb"
Status  Status           Target Type           Target Name
 ID
1       Up               oracle_pdb            racdb_CDBROOT
0       Down             oracle_pdb            racdb_RACPDB
0       Down             oracle_pdb            racdb_RAC_PDB1
0       Down             oracle_pdb            racdb_RAC_PDB2

Get a list of all Pluggable databases, pools, database clouds and PaaS zones
emcli get_targets -target="oracle_pdb;%pool;cloud;%zone"
Status  Status           Target Type           Target Name
 ID
-9      n/a              cloud                 Middleware and Database Cloud
-9      n/a              oracle_cloud_zone     DBAAS_Pool_AIX
-9      n/a              oracle_cloud_zone     DB12cPool
-9      n/a              oracle_cloud_zone     Dev 11203 Linux VM
1       Up               oracle_pdb            racdb_CDBROOT
0       Down             oracle_pdb            racdb_RACPDB
0       Down             oracle_pdb            racdb_RAC_PDB1
0       Down             oracle_pdb            racdb_RAC_PDB2
-9      n/a              pdbaas_pool           PDB Pool
-9      n/a              schaas_pool           DBAAS_SCHAAS
-9      n/a              schaas_pool           Dev 11203 AIX
-9      n/a              self_service_zone     Lab Zone (Linux)
-9      n/a              self_service_zone     Lab Zone (AIX)


Here is a list of more useful PDBaaS/DBaaS verbs 

PaaS Zone verbs
create_paas_zone      -- To Create a PaaS Infrastructure Zone
delete_paas_zone      -- To Delete a PaaS Infrastructure Zone
get_paas_zone_detail  -- To get PaaS Infrastructure Zone details
update_paas_zone      -- To Update a PaaS Infrastructure Zone

Software and Database Pool verbs
create_pool           -- To Create a Software Pool
delete_pool           -- To Delete a Software Pool
get_pool_allowed_member_constraints           -- To get possible member constraint values of a Software Pool based on its target type
get_pool_allowed_placement_constraints        -- To get the placement constraints of a Software Pool based on its target type
get_pool_capacity     -- To get Software Pool capacity
get_pool_detail       -- To get Software Pool details
get_pool_filtered_targets     -- To get the filtered targets for a Software Pool based on the criteria passed
update_pool           -- To Update a Software Pool

Quota verbs
create_dbaas_quota    -- To Create Database Quota for a SSA User Role
delete_dbaas_quota    -- To Delete the Database Quota setup for a SSA User Role
get_dbaas_quota       -- To List the Database Quota setup for all SSA User Roles
update_dbaas_quota    -- To Update the Database Quota for a SSA User Role

Profile verbs
create_dbprofile    -- Create Database Profile
delete_dbprofile    -- Delete Database Profile
describe_dbprofile_input    -- Describe Database Profile Input
list_dbprofiles     -- List Database Profiles

Comments

Post a Comment

Popular posts from this blog

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site . Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account Subscription to Oracle IaaS Service First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances. Note: Oracle uses the term "shape" to r...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum [root@matthew ~]# yum install xfsprogs Loaded plugins: refresh-packagekit Setting up Install Process public_ol6_UEKR3_latest | 1.2 kB 00:00 public_ol6_UEK_latest | 1.2 kB 00:00 public_ol6_UEK_latest/primary | 19 MB 00:02 public_ol6_UEK_latest 407/407 public_ol6_addons | 1.2 kB 00:00 public_ol6_addons/primary | 77 kB 00:00 public_ol6_addons 269/269 public_ol6_latest | 1.4 kB 00:00 public_ol6_latest/primary | 46 MB 00:05 public_ol6_latest 29302/29302 http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found" Trying other mirror. Resolving Dependencies --> Running transaction check ---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================...
Read more