oem12c, db12c and you! - rmoug td2014 edition
DESCRIPTION
Presentation on Oracle Enterprise Manager 12c and Database 12c that was presented at RMOUG Training Days 2014. This slide deck expands on the topic.TRANSCRIPT
![Page 2: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/2.jpg)
• Douglasville, Georgia
• Senior Technical Consultant
• IOUG, ODTUG, GOUSER and RMOUG BOD
• Expert OEM12c (2013)/Practical ODA (2014)
• Twitter: @dbasolved• Blog: http://dbasolved.com
• Email: [email protected]
Bobby Curtis
![Page 3: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/3.jpg)
Agenda
• Database 12c
• Enterprise Manager Express 12c
• Oracle Enterprise Manager 12c
![Page 4: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/4.jpg)
Agenda
• Database 12c
• Enterprise Manager Express 12c
• Oracle Enterprise Manager 12c
![Page 5: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/5.jpg)
Database 12c • Beta: Late
2012/early 2013• Production: June 27, 2013
• Benefits: • 500+ new features
• Database Types• Traditional Database
• Container Database• MultiTenant
![Page 6: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/6.jpg)
Multitenant DatabasesConsolidating using Oracle Database 12c
![Page 7: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/7.jpg)
Migrate to Multitenant DatabasesMigration Tools available in Oracle Database 12c (CDB)
![Page 8: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/8.jpg)
Agenda
• Database 12c
• Enterprise Manager Express 12c
• Oracle Enterprise Manager 12c
![Page 9: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/9.jpg)
Enterprise Manager Express 12cIntegrated, GUI Management Tool for AdministrationIntegrated
Install
• Pre-Configured/Installed with DB
• Inside the DB (XDB)• Lightweight (no MW
parts)• Supports Single
Instance, RAC, EE
Small Footprint
• Approx. 20 MB• Minimal CPU,
Memory overhead• All rendering in
browser• DB Server only runs
SQL
Comprehensive
Administration• Basic Admin
support• Storage• Security• Configuration
• Performance Tools• Advanced
Diagnostics• Advanced
Turning• Run along side of
OEM12c
![Page 10: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/10.jpg)
Enterprise Manager Express 12c
• Any Database user can log in
• Default Port: 5500• exec DBMS_XDB_CONFIG.SETHTTPPORT(<port_number>);
![Page 11: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/11.jpg)
Agenda
• Database 12c
• Enterprise Manager Express 12c
• Oracle Enterprise Manager 12c
![Page 12: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/12.jpg)
Oracle Enterprise Manager 12cGUI Management Tool for Administration
Large Footprint
• Approx. 50–100 GB• Requires its own
machine(s)• Min. 8GB Mem.• Min. 4 Cores.
Comprehensive
Administration
• Advanced Admin support• Full stack
• Advanced diag and turning
• Create CDB/PDBs • Run along side of EM
Express 12c
![Page 13: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/13.jpg)
Oracle Enterprise Manager 12cSpecific Documentations
• Locations of documents related to OEM
• No specific information on Plug-In itself (404 error)
• OEM information mixed with DB12c docs
• Documents Related to OEM with DB12c:• Oracle Database Security Guide 12c Release 1 (12.1) E17607-22
• Oracle Database Administrator Guide 12c Release 1 (12.1) E17636-20
![Page 14: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/14.jpg)
Upgrade through OEM12cdeployment procedure
• Upgrade to 12.1.0.1
• 10.2.0.5• 11.1.0.7• 11.2.0.2 or
later
• Need to have binaries installed on host
• Software Library
• Verified by reviewing oratab file
• Migrate to PDB
![Page 15: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/15.jpg)
Provision as Pluggable DatabaseOEM12c approach • In OEM12cR2Up1 (12.1.0.2)
![Page 16: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/16.jpg)
Provision a Pluggable DatabaseCommand Line Option
./emcli create_pluggable_database -cdbTargetName="bc12c.acme.com" -cdbTargetType="oracle_database" -cdbHostCreds="NC_HOST_ORACLE" -cdbTargetCreds="NC_BC12C.AC_2013-08-26-110644”-pdbName="bcpdb2" -sourceType="DEFAULT" -pdbAdminCreds="PDBADMIN" -newPDBFileLocation="/oracle/app/oradata/"
• New in OEM12cR3 (12.1.0.3)
![Page 17: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/17.jpg)
Database Securityusers
• Common Users• Prefix: C##• Container Database
• _COMMON_USER_PREFIX
• Local Users• Pluggable Database
• Access Pluggable
![Page 18: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/18.jpg)
Database SecurityRoles
• Common Roles• Prefix: C##• Container Database
• Local Roles• Pluggable Database
• Access Pluggable
![Page 19: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/19.jpg)
Database AdministrationSwitching between Containers
![Page 20: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/20.jpg)
Database AdministrationOpen/Close PDBs
![Page 21: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/21.jpg)
Database AdministrationOpen/Close PDBs
alter pluggable database BCPDB2 openFri Jan 31 22:41:08 2014Opening pdb BCPDB2 (4) with no Resource Manager plan activePluggable database BCPDB2 opened read writeCompleted: alter pluggable database BCPDB2 open
![Page 22: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/22.jpg)
Database AdministrationManage Storage (Tablespaces) • CDB Level
• Must be common user (C##)
• All tablespaces listed (CDB & PDB)
• PDB Level• Local User• Only
tablespaces for PDB listed
• Tablespaces in Read-Only appear (no check mark)
• PDB closed, no tablespaces listed
![Page 23: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/23.jpg)
• Integrated view of performance• Runs from CDB level• New tab: PDB
Database AdministrationPerformance Management
![Page 24: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/24.jpg)
• All performance tools work as usually• Container Name added• Runs from CDB level
Database AdministrationPerformance Management
![Page 25: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/25.jpg)
Resource Management• Admin Privileges
• Plans• CDB
• Affects PDBs
• PDB• Affects users/groups
• Resources• CPU• Parallel Queuing
![Page 26: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/26.jpg)
Resource ManagementContainer Database
• Four Default Plans
• Create Your Own Plans
• Generate DDL for Resource Plans
• Activate/Deactivate
![Page 27: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/27.jpg)
Resource ManagementContainer Database
• Activate Plan
• Adjust resources• Default applied to all PDBs
• Add/Remove selected PDBs
• Review ASH Analytics (helps tune plan)
![Page 28: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/28.jpg)
Resource ManagementPluggable Database
• Eleven Default Plans
• Create Your Own Plans
• Generate DDL for Resource Plans
• Activate/Deactivate
![Page 29: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/29.jpg)
Resource ManagementPluggable Database • Activate
Plan/Plan Switching
• Four tabs to modify
• General• Parallelism
• Thresholds
• Idle Time
• Resource Allocations
• Groups• Sub-plans
• No ASH Analytics
![Page 30: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/30.jpg)
Recovery ManagerBackup of Pluggable Database
![Page 31: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/31.jpg)
Recovery ManagerRecovery of Pluggable Database
![Page 32: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/32.jpg)
Inventory SearchesFind Pluggable Database
Enterprise -> Configuration -> Inventory and Usage Details-> Show: Databases
![Page 33: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/33.jpg)
Configuration SearchesFind Pluggable Database
1. Target Type: Pluggable Database2. Relationship: Host
![Page 34: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/34.jpg)
Take Away
• Overview of Database 12c
• EM Express can be used in conjunction with OEM12c
• EM12c enhances the manageability of DB12c
• How to search within OEM 12c for DB12c items
![Page 35: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/35.jpg)
![Page 36: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/36.jpg)
Twitter: @dbasolvedEmail: [email protected]
Thank You for Attending
Please fill out the evaluations.
http://www.enkitec.com
![Page 37: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/37.jpg)
• Douglasville, Georgia
• Senior Technical Consultant
• IOUG, ODTUG, GOUSER and RMOUG BOD
• Expert OEM12c (2013)/Practical ODA (2014)
• Twitter: @dbasolved• Blog: http://dbasolved.com
• Email: [email protected]
Bobby Curtis
![Page 38: OEM12c, DB12c and You! - RMOUG TD2014 Edition](https://reader036.vdocuments.us/reader036/viewer/2022062513/554f54deb4c905423f8b5482/html5/thumbnails/38.jpg)