Oracle Enterprise Manager 12c Command-Line Interface

  • 2h 38m
  • Kellyn Pot’Vin, Ray Smith, Seth Miller
  • Apress
  • 2014

Oracle Enterprise Manager 12c Command-Line Interface shows how to use Enterprise Manager’s powerful scripting language to automate your database administration work and save time by scripting routine tasks, and then executing those scripts across collections of databases and instances in your environment. This book is chock full of ready-made scripting examples contributed by the authors and leading members of the community. For example, you'll find scripts and examples of commands to:

  • Remove an Enterprise Manager agent and its related targets
  • Quickly create administrator accounts that are fully-configured with pre-expired passwords and all needed roles
  • Invoke batch files to execute sequences of related commands with consistency against multiple targets
  • Batch create large groups of user logins with a single command
  • and more!

The Enterprise Manager Command Line Interface (EM CLI) is the administrator's key to unlocking the power of Enterprise Manager 12c (EM12c) with scalability, repeatability, and confidence. In previous versions, most administrators ventured into the command-line interface only with the assistance of Oracle Support. But now there are many features in EM12c that are accessible only from the command-line. This is far from a disadvantage! Enterprise Manager is now a powerful tool for automation in the hands of a skilled database administrator.

Enterprise Manager scripting offers potential for all administrators who manage Oracle’s enterprise-level products in their environment. You can automate from the smallest, single-instance configuration all the way up to a broadly distributed enterprise-level rollout having database instances strewn across broad geographical distributions. The power of the EM CLI returns the administrator to the golden age, where the entire environment, from database to application to infrastructure, can often be managed from this powerful command line tool secured by the robust Enterprise Manager framework.

  • Brings a golden-age of automation to Oracle Database administrators
  • Provides ready-made scripts contributed by leading members of the community
  • Covers advanced techniques involving Jython and Python

About the Authors

Kellyn Pot'Vin is a Consulting Member of Oracle’s Strategic Customer Program Team who is focused on Enterprise Manager. She offers expertise and support to customers on implementation of special projects involving Enterprise Manager and Ops Center products. She also provides valued direction within Oracle Corporation on the future development of Enterprise Manager. Kellyn is a talented and accomplished database administrator. She is a member of the Oak Table Network, an Oracle ACE Director, serves on the board of the Rocky Mountain Oracle User Group (RMOUG), was Director of RMOUG Training Days 2014, leads the database track for the Oracle Developer Tools User Group’s KSCOPE 2014 event, and speaks widely at industry events on topics relevant to database administration and Oracle technologies.

Seth Miller is an Oracle ACE and has been working with Oracle technologies since 2005. He has worked as a DBA in a number of industries, including health care, medical device manufacturing, and environmental science, and he now works as a consultant and an Oracle University Certified Instructor. Seth is a strong advocate for Oracle products and the Oracle community, serving as the IOUG Director of Volunteer Engagement, serving as the Vice President of the Twin Cities Oracle Users Group, engaging in social media conversations concerning Oracle technology, and participating in discussions on the Oracle-L mailing list. Seth is a regular speaker at the IOUG Collaborate and Oracle OpenWorld conferences, as well as a host of webinars for OTN. His blog, sethmiller.org, features posts related to Oracle and other technology. Enterprise Manager has found a special place in Seth’s heart as a means of lightening the load of the IT administrator, while at the same time empowering them.

Ray Smith is an Oracle ACE and a dedicated IOUG volunteer. He currently serves as the Executive Editor of the SELECT Journal and Best Practices booklet, along with the best job at IOUG—New Speaker Mentor for the COLLABORATE Conference. He is a regular speaker at COLLABORATE, Oracle Open World, and at regional user groups. Ray’s blog, http://oramanageability.wordpress.com, is dedicated to explaining the ins and outs of Oracle Enterprise Manager. He recently established the Northwest Oracle User Group ’Women in Technology’ scholarship at Portland State University. He is a proud member of the Oracle Enterprise Manager Customer Advisory Board and is an unapologetic advocate for OEM.

In this Book

  • Architecture
  • Installation and Security Framework and EM12c Release 4
  • Terminology and Basics
  • Working at the Command Line
  • Automation through Shell Scripts
  • Advanced Scripting
  • Using the Software Library and Oracle Extensibility Exchange
  • Sample EM CLI Scripts