oem12c overview for dba - · pdf file2010 oracle ace director of the year by oracle magazine...
Post on 09-Mar-2018
217 Views
Preview:
TRANSCRIPT
Francisco Munoz Alvarez LAOUC, CLOUG & NZOUG President
IOUC LA Spokesperson 8/9/10g/11g OCP, RAC OCE, AS OCA, E-Business OCP, SQL/PLSQL OCA, Oracle 7 OCM
Oracle 7, 11GR2 & OVM 3.1 Beta Tester
ITIL Certified
2010 Oracle Ace Director of the year by Oracle Magazine
OEM12c Overview for DBA
DBIS - Copyright 2010 2
Born here Grow up here
Got Married Here Mature
here Now Living here
1. Introduction to OEM12C 2. How to Install
3. Troubleshooting 4. Tips
5. Licensing Information
AGENDA
Introduction
Complete Cloud Lifecycle Management
Applications and Business Services
Platform as a Service
Infrastructure as a Service
Plan
Setup
Build
Test
Deploy
Monitor
Manage
Meter & Charge
Optimize
DBaaS MWaaS
Plan and Setup the Cloud Environment
• Discover IT assets
• Plan capacity and consolidation
• Setup cloud services
• Define access rules and controls
PLAN & SETUP
Package Multi-tier Enterprise Applications
Capture Complete
Application Topology Package Into
Single Assembly Deploy Self-Service
Metadata
OVM
HTTP
OVM
HTTP
OVM
WLS
OVM
DB
Ora
cle
En
terp
ris
e M
an
ag
er
Oracle Virtual Assembly Builder
Upload to Software
Library
BUILT
Test Applications End-to-End Automate Application, Middleware and Database Testing
Testing Application Changes
Testing Infrastructure Changes
Test Data and Lab Management
Oracle Functional Testing
Oracle Load Testing
Oracle Test Manager
SQL Performance Analyzer
Application Replay
Data Discovery and Modeling
Data Subsetting
Database Replay
Data Masking
Production Workload Synthetic Workload Test Data Management
TEST
Self-Service Access
• Infrastructure-as-a-Service (IaaS)
– x86 and SPARC
• Platform-as-a-Service (PaaS)
– Database (DBaaS), Java,….
– Physical and virtual environment support
• Out-of-box Portal and APIs
Self-Service Freedom, Professional Control
DEPLOY
Monitor and Manage Cloud Operations
• Track resource flux, tenants, policy violations, etc
• Monitor requests and failures
• Manage resource and capacity utilization
• Automatic, policy driven elasticity
MONITOR & MANAGE
Meter, Charge and Optimize Cloud Services
• Application-to-Disk resource metering
• Chargeback/Showback
• Oracle Billing and Revenue Management (BRM) Integration
• Optimize performance, capacity, QoS, costs…
METER -CHARGE & OPERATIONS
RELIABILITY PERFORMANCE
SECURITY
SUPPORT
Fusion Applications Management
• Application discovery, modeling and monitoring
• Integrated business-IT view
• Performance, configuration and lifecycle management
Deep, Integrated, Business-Driven
Middleware Management
• Deep and integrated application performance management – Middleware diagnostics advisor
– Automatic metric correlation
– Multi-domain log viewer
– Routing topology
• Provisioning Automation – Domain scale up, scale-out
– App deploy, undeploy
New Automation to Lower TCO
Database Management
• Advance Performance Diagnostics – Real-Time ADDM
– Compare Period ADDM
– Active Session History (ASH) Analytics
• Mass Database Upgrade Automation
• Minimal Downtime Patching
Extending Database Self-Management Leadership
Engineered Systems Management
• Integrated hardware and software management
– Hardware schematics and alerts
– Integrated and deep software management
– Hardware and software topology, configuration management
• Proactive support – “Phone home”
– Health checks
– Patch and best practices advisory
• Exadata and Exalogic
My Oracle Support Integration
Proactive Support
My Oracle Support
Performance Management
Provisioning & Patching
Problem Diagnosis
Databases Hardware Middleware
Applications
Problem/SR Management
Configuration Management
Knowledge Management
Problem/SR Management
Configuration Management
Knowledge Management
• Proactive Patch Advisory
• Certification Checks – End-of-life advisory
• Upgrade Planning and Automation
• Hardware Telemetry and Phone Home
New Massively Scalable Framework
• Better performance and scalability
• Self-update
• Enhanced security
• New web 2.0 user interface
• Powerful configuration management
Robust, Extensible, Secure
Host 2
Web Logic Fusion Apps
Host 1
Plug-Ins (Database, FMW, Fusion Apps, . .) Agent
DB Plug-In
FMW Plug-In
Agent
Au
to-P
ush
Oracle Enterprise Manager
Security
Task Automation
Monitoring
Configuration Management
Database Web Logic
FMW Plug-In
FA Plug-In M
an
ag
em
en
t S
erv
ices
My Oracle Support
Installing OEM12c
When Installing OEM12c
• Read Installation Manual carefully
• Check environment minimum requirements
• Check if environment is certified by Oracle (Hardware/OS)
• Install OEM12c (12.1.0.1) with the bundle Patch 1
• When running RunInstaller set the correct Host Name to be used
./runInstaller ORACLE_HOSTNAME=example.com
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
Installing OEM 12c
OEM 12c
DEMO
Troubleshooting
Stuck on Configuration Requeriments
Where to find it
Solution
Remove Previous DB Control Schema
Troubleshooting - Solution
Change Hostname or IP Address
1) Set $ORACLE_HOSTNAME to the old hostname: [oracle]$ export ORACLE_HOSTNAME=oc-oracle-prod.com 2) De-configure the old DB Console by running the following command: [oracle]$ $ORACLE_HOME/bin/emca-deconfig dbcontrol db STARTED EMCA at Jul 20, 2012 10:27:25 AM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: COLD Do you wish to continue? [yes(Y)/no(N)]: Y log4j:WARN No appenders could be found for logger (emSDK.config). log4j:WARN Please initialize the log4j system properly. Jul 20, 2012 10:27:38 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/COLD/emca_2012_07_20_10_27_24.log. Jul 20, 2012 10:27:38 AM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Enterprise Manager configuration completed successfully FINISHED EMCA at Jul 20, 2012 10:27:53 AM [oracle]$
Change Hostname or IP Address (Cont.)
3) Un-set $ORACLE_HOSTNAME in the environment, in other words, set $ORACLE_HOSTNAME to the new hostname: [oracle]$ export ORACLE_HOSTNAME=oracle-prod.com 4) Configure the new DB Console: [oracle]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate STARTED EMCA at Jul 20, 2012 10:28:49 AM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: COLD Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.3/db_1 ]: Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME................ /u01/app/oracle/product/11.2.0.3/db_1 Local hostname ................ col-oracle-prod.lakros.com Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.3/db_1 Listener port number ................ 1521 Database SID ................ COLD Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- WARNING : While repository is dropped the database will be put in quiesce mode. ---------------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y
Change Hostname or IP Address (Cont.)
Jul 20, 2012 10:29:34 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/COLDFX/emca_2012_07_20_10_28_49.log. Jul 20, 2012 10:29:35 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Dropping the EM repository (this may take a while) ... Jul 20, 2012 10:31:10 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully dropped Jul 20, 2012 10:31:11 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Jul 20, 2012 10:37:48 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Jul 20, 2012 10:37:52 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Jul 20, 2012 10:39:32 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Jul 20, 2012 10:39:37 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Jul 20, 2012 10:40:03 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Database Control secured successfully. Jul 20, 2012 10:40:03 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Jul 20, 2012 10:40:32 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Jul 20, 2012 10:40:32 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://col-oracle-prod.lakros.com:5500/em Jul 20, 2012 10:40:36 AM oracle.sysman.emcp.EMDBPostConfig invoke WARNING: ************************ WARNING ************************ Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0.3/db_1/oracle-prod.com_COLD/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. *********************************************************** Enterprise Manager configuration completed successfully FINISHED EMCA at Jul 20, 2012 10:40:36 AM [oracle@col-oracle-prod bin]$
Change Hostname or IP Address (Cont.)
If using Oracle RAC you need to replace the step s 2 and 4 for: [oracle]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -cluster [oracle]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate -cluster
Some Tips
Status, Start and Stop Scripts
[oracle@RVRWPDOEMT01 ~]$ cat startOEM12c.sh export OMS_HOME=/u01/app/oracle/OEM12C/oms export AGENT_HOME=/u01/app/oracle/OEM12C/agent/core/12.1.0.1.0 $OMS_HOME/bin/emctl start oms $AGENT_HOME/bin/emctl start agent [oracle@RVRWPDOEMT01 ~]$ [oracle@RVRWPDOEMT01 ~]$ cat statusOEM12c.sh export AGENT_HOME=/u01/app/oracle/OEM12C/agent/core/12.1.0.1.0 $AGENT_HOME/bin/emctl status agent [oracle@RVRWPDOEMT01 ~]$ [oracle@RVRWPDOEMT01 ~]$ cat stopOEM12c.sh export ORACLE_HOME=/u01/app/oracle/product/11.2.3/db_1 export OMS_HOME=/u01/app/oracle/OEM12C/oms export AGENT_HOME=/u01/app/oracle/OEM12C/agent/core/12.1.0.1.0 $OMS_HOME/bin/emctl stop oms -all $AGENT_HOME/bin/emctl stop agent [oracle@RVRWPDOEMT01 ~]$
Backup of Admin Server
Licensing
OEM12c Licensing What us included for free
OEM12c Licensing What you need to pay for
OEM12c Licensing Prices and Package Changes with OEM12c
OEM12c Licensing Prices and Package Changes with OEM12c
OEM12c Licensing New Products with OEM12c
OEM12c Licensing OEM Licensable Products
OEM12c Licensing OEM Licensable Products
OEM12c Licensing OEM Licensable Products
OEM12c Licensing OEM Licensable Products
OEM12c Licensing OEM DB Packs
OEM12c Licensing OEM DB Packs
OEM12c Licensing OEM DB Packs
OEM12c Licensing OEM DB Packs
OEM12c Licensing OEM DB Packs
OEM12c Licensing OEM DB Packs
Questions?
Thank you !
top related