Grid DBA

The Enterprise Manager Command Line Interface or EMCLI enables ease of use and automation for administrators. However, in order to install EMCLI you need to access the EM Console to download the jar file. A question on twitter about downloading EMCLI via command-line. There may be a couple of ways to accomplish it but the one that came to mind used the same technique as method 2 posted on this blog post by Pythian. curl --header 'Host: oemcc.example.com' --header 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:30.0) Gecko/20100101 Firefox/30.0' --header 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' --header 'Accept-Language: en-US,en;q=0.5' --header 'DNT: 1' --header 'Referer: https://oemcc.example.com/em/faces/core-uifwk-console-overview?_afrLoop=1867249808458041&_afrWindowMode=0&_afrWindowId=bb8yoxpcb_1' --header 'Cookie: ORA_SMP_EM_AUTH_68934127863622066490=JtCfT0nY2Dq3LMzT2S1V0...

Database-as-a-Service (DBaaS) has now become a buzzword in the IT industry. Organizations are starting to r ealize the benefits of database as a service thanks to the ubiquity of "The Cloud". Companies relying on Oracle databases for managing their data can also get on the DBaaS fast track thanks to Oracle Enterprise Manager Cloud Control 12c. Using EM12c you can enable self-service and rapid provisioning of Oracle databases and enjoy all the benefits (well most) of Cloud computing.  EM12c supports both IaaS and PaaS models. These are also tightly integrated with Oracle VM Server along with their engineered systems including Oracle Exadata Database Machine. Setting up and configuring DBaaS requires several steps. While these are well-documented , it seems like a daunting task for those who are unfamiliar with process. A list of steps required to setup DBaaS include the following: ■Create Roles and Users ■Setup Privilege Delegation ■Add Hosts ■Configure Software Lib...

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 (%)      8 0 Update PaaS zone placement policy constraints ...

Oracle Enterprise Manager Cloud Control 12c allows us to customize the page that self service users see when logging in instead of the usual EM Console login page. This is useful for Cloud Providers who offer private cloud services to their clients. With just a few small steps you can have your own customized login  page. Enable the SSA login page $ emctl set property -name oracle.sysman.ssa.logon.ssa_oms -value true Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation.   All rights reserved. SYSMAN password: Property oracle.sysman.ssa.logon.ssa_oms for oms oms.example.com:4889_Management_Service has been set to value true OMS restart is required to reflect the new property value Set a custom alternate text message for the Cloud Provider on the login page.  $ emctl set property -name oracle.sysman.ssa.logon.cloud_provider_alt_text -value "Nelson Cloud Provider" Oracle Enterprise Manag...

Note to self on how to upgrade EM Agents using EMCLI Find upgradeable agents: $ emcli get_upgradable_agents Upgradable Agents Agent Installed Version Version After Upgrade Platform Oracle Home ----- ----------------- --------------------- -------- ----------- oradba10t:3872 12.1.0.2.0 12.1.0.3.0 IBM AIX on POWER Systems (64-bit) /u02/oracle/agent12c/core/12.1.0.2.0 oradba11t:3872 12.1.0.2.0 12.1.0.3.0 IBM AIX on POWER Systems (64-bit) /u02/oracle/agent12c/core/12.1.0.2.0 $ vi /tmp/oradba_agents.txt $ cat /tmp/oradba_agents.txt oradba10t:3872 oradba11t:3872 Upgrade agents using an input file  $ emcli upgrade_agents -input_file="agents_file:/tmp/oradba_a...

My OEM environment consists of two management servers (OMS) for high availability ( level 3 HA ). We also have a SLB configured for the OMSs but they haven't been configured with the SLB virtual hostname. I know, this sounds very confusing but there's a difference. Essentially they act as individual OMSs since agents can only upload to one OMS and console is pointed to a single OMS. The load balancer is a F5 BIG-IP and all the configuration setting were done for using OEM. This whitepaper clearly describes how to do this.   After upgrading my OEM environment from 12.1.0.2.0 to 12.1.0.3.0 I decided to reconfigure the OMSs to use the SLB virtual hostname. Reconfiguring the SLB involves securing the OMSs with the virtual hostname of the SLB. [oracle@oms1[]-/u01/Oracle/Middleware/oms/bin >./emctl secure oms -host oemcc.example.com -secure_port 4899 -slb_port 4889 -slb_console_port 443 Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 20...