Wednesday Apr 16, 2014

RMAN Backups using Cloud Control

Friends, a technical article was recently published on the Oracle Technical Network:

Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c

This detailed technical article explains the set up and scheduling of full and incremental RMAN Database backups for  thousands of databases using Enterprise Manager 12c, and how this is done more easily and efficiently than the older, more time-consuming, manual method of performing Unix shell scripting, RMAN scripting, and CRON jobs for each database to be backed up.

And with the Database Group Backup feature new to Enterprise Manager 12c, it can be even faster to set up RMAN backups for multiple databases - even if there are thousands - that are part of an Enterprise Manager Database Group (one kind of target group).


The article also highlights the advantages of using Pluggable Databases (PDBs) in Oracle Database 12c and backing them up using RMAN. RMAN cannot backup individual schemas, and it has always been difficult to perform point-in-time-recovery (PITR) at an individual schema level, since schemas can easily be distributed across multiple tablespaces. The advantage in using PDBs in a Container Database is that you can easily set up RMAN backups at the Container Database level, and yet perform PITR at the PDB level. This is a clear technical advantage of the Multi-tenant architecture of Oracle Database 12c.

The set up and scheduling of RMAN database backups forms a part of the Base Database Management features of Enterprise Manager that enables numerous customers to get familiar with the day-to-day use of Enterprise Manager 12c. The full list of Base Database Management features can be found in the Enterprise Manager Licensing Information guide here.

In fact I had personally introduced Enterprise Manager to one of India’s largest financial services organizations in India in 2007 for the purpose of their RMAN backups, they started using it for the first time, and today we are proud to say that they are an Enterprise Manager reference customer who have presented in OOW for the last 2 years. The following slide is from their recent OOW presentation.


One thing I forgot to include in the article (and yes, it is a long article) was on reporting of the RMAN backups. A few readers asked me that question after the article’s publication, both inside and outside Oracle.

I told them that if they were using an RMAN catalog, the catalog would have this information and could easily be queried. If they were not using a catalog, then this backup information would be stored in the control file, and they would have to query each database’s control file (using V$ views) to get the backup report. BI Publisher, installed as an add-on to Enterprise Manager, could be used for this purpose. However note that if BI Publisher is used to query information from a source other than the Enterprise Manager repository database, a license is payable for each database it accesses.

Read the full article at “Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c”, and enjoy the world of Oracle Enterprise Manager.

Regards,

Porus Homi Havewala (OCM 11g/10g).

Stay Connected:
Twitter | Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app


Monday Jan 27, 2014

IOUG Oracle EM SIG Techcast: Managing Oracle Enterprise Manager 12c with Oracle Clusterware


The Oracle Enterprise Manager Special Interest Group (SIG) is a growing body of IOUG members who manage or are interested in all aspects of Oracle Enterprise Manager. This IOUG SIG is managed by volunteers and supported by Oracle Enterprise Manager product managers and developers. The purpose of the SIG is to bring relevant information and education through webcasts, discussions and networking to users interested in learning more about the product, and to share user experiences.

On January 28th at 10 AM pacific time, Oracle Enterprise Manager SIG is hosting a webcast on "Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware". In this webcast, Leighton Nelson, Associate Principal Database Administrator/Oracle ACE will discusss the steps required to configure virtual host names and create an Oracle Clusterware resource for Oracle Enterprise Manager to provide seamless failover and improved high availability levels.


Register Now !

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Monday Nov 11, 2013

Implementing Service Level Agreements in Enterprise Manager 12c for Oracle Packaged Applications

Contributed by Eunjoo Lee, Product Manager, Oracle Enterprise Manager.

Service Level Management, or SLM, is a key tool in the proactive management of any Oracle Packaged Application (e.g., E-Business Suite, Siebel, PeopleSoft, JD Edwards E1, Fusion Apps, etc.). The benefits of SLM are that administrators can utilize representative Application transactions, which are constantly and automatically running behind the scenes, to verify that all of the key application and technology components of an Application are available and performing to expectations.

A single transaction can verify the availability and performance of the underlying Application Tech Stack in a much more efficient manner than by monitoring the same underlying targets individually.

In this article, we’ll be demonstrating SLM using Siebel Applications, but the same tools and processes apply to any of the Package Applications mentioned above. In this demonstration, we will log into the Siebel Application, navigate to the Contacts View, update a contact phone record, and then log-out.

This transaction exposes availability and performance metrics of multiple Siebel Servers, multiple Components and Component Groups, and the Siebel Database - in a single unified manner. We can then monitor and manage these transactions like any other target in EM 12c, including placing pro-active alerts on them if the transaction is either unavailable or is not performing to required levels. The first step in the SLM process is recording the Siebel transaction. The following screenwatch demonstrates how to record Siebel transaction using an EM tool called “OpenScript”. A completed recording is called a “Synthetic Transaction”.

The second step in the SLM process is uploading the Synthetic Transaction into EM 12c, and creating Generic Service Tests. We can create a Generic Service Test to execute our synthetic transactions at regular intervals to evaluate the performance of various business flows. As these transactions are running periodically, it is possible to monitor the performance of the Siebel Application by evaluating the performance of the synthetic transactions. The process of creating a Generic Service Test is detailed in the next screenwatch. EM 12c provides a guided workflow for all of the key creation steps, including configuring the Service Test, uploading of the Synthetic Test, determining the frequency of the Service Test, establishing beacons, and selecting performance and usage metrics, just to name a few.

The third and final step in the SLM process is the creation of Service Level Agreements (SLA). Service Level Agreements allow Administrators to utilize the previously created Service Tests to specify expected service levels for Application availability, performance, and usage. SLAs can be created for different time periods and for different Service Tests. This last screenwatch demonstrates the process of creating an SLA, as well as highlights the Dashboards and Reports that Administrators can use to monitor Service Test results.

Hopefully, this article provides you with a good start point for creating Service Level Agreements for your E-Business Suite, Siebel, PeopleSoft, JD Edwards E1, or Fusion Applications. Enterprise Manager Cloud Control 12c, with the Application Management Suites, represents a quick and easy way to implement Service Level Management capabilities at customer sites.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Monday Oct 28, 2013

EM CLI, diving in and beyond!

Doing more in less time… Isn’t that what we all strive to do?

With this in mind, I put together two screen watches on Oracle Enterprise Manager 12c command line interface, or EM CLI as it is also known.

There is a wealth of information on any topic that you choose to read about, from manual pages to coding documents…might I even say blog posts? In our busy lives it is so nice to just sit back with a short video, watch and learn enough to dive in.

Doing more in less time, is the essence of EM CLI. It enables you to script fundamental and complex administrative tasks in an elegant way, thanks to the Jython scripting language. Repetitive tasks can be scripted and reused again and again. Sure, a Graphical User Interface provides a more intuitive step by step approach to tasks, and it provides a way of quickly becoming familiar with a product and its many features, and it is definitely the way to go when viewing performance data and historical trending…but for repetitive and complex tasks, scripting is the way to go!

Lets us take the everyday task of creating an administrator.

Using EM CLI in interactive mode the command could look like this..

emcli>create_user(name='jan.doe', type='EXTERNAL_USER')

This command creates an administrator called jan.doe which is an externally authenticated user, possibly LDAP or SSO, defined by the EXTERNAL_USER tag. The create_user procedure takes many arguments; see the documentation for more information.

Now, where EM CLI really shines and shows power is in creating multiple users. Regardless of the number, tens or thousands, the effort is the same. With the use of a standard programming construct, a loop, you can place your create_user() procedure within it. Using a loop allows you to iterate through a previously created list, creating new users until the list is complete.

Using EM CLI in Script mode, your Jython loop would look something like this…

for user in list_of_users:

      create_user(name=user, expire=’true’, password=’welcome123’) 

This Jython code snippet iterates through a previously defined list of names, list_of_users, and iterates through the list, taking each name, user in this case, and creates an administrator sets the password to welcome123, but forces the user to reset it when they first login.

This is only one of over four hundred procedures created to expose Oracle Enterprise Manager 12c functionality in a powerful and programmatic way.

It is a few months since we released EM CLI with scripting option. We are seeing many users adapt to this fun and powerful way of using Oracle Enterprise Manager 12c.

What are the first steps?

Watch these screen watches, and dive in.

The first screen watch steps you through where and how to download and install and how to run your first few commands.


The Second screen watch steps you through a few scripts.

Next time, I am going to show you the basic building blocks to writing a Jython script to perform Oracle Enterprise Manager 12c administrative tasks.

Join this growing group of EM CLI users…. Dive in!

Thursday Oct 24, 2013

Oracle Enterprise Manager Partner Spotlight: Compasso

EVERY MONDAY at 2 PM Eastern Time (USA)

Join Compasso, one of Oracle's Enterprise Manager partners that is Specialized in Application Quality Management, for a series of presentations focused on Oracle end to end performance management.

The objective is to provide a comprehensive overview of Oracle's Enterprise Manager 12c software.  Attendees will learn how Oracle can provide a complete end to end management  solution, for not only for Oracle Databases, but also other aspects of the Oracle technology, such as Middleware and Oracle applications.  Key areas include:

1. Next-Generation Management Framework which cover:

  • Better performance and scalability
  • Modular, extensible architecture
  • Easier to manage and diagnose
  • Enhanced security
  • Web 2.0 UI
2. Enhanced Application-to-Disk Management
  • End-to-end application performance management
  • Fusion Applications management
  • Exadata and Exalogic management
3. Complete Lifecycle Management for Enterprise Private Cloud
  • Self-service provisioning
  • Policy based resource and workload management
  • Chargeback

There are two ways you can sign up:

1. Call Nicole Wakefield of Compasso at +1 (971) 245-5042
2. Email nwakefield@compasso.com.br with Subject Line of "Monday Enterprise Manager Presentations"

WebEx Conference details will be provided with your confirmation

For more information about partner opportunities with Enterprise Manager, including becoming Specialized, click here.

For more information about Compasso, click here.




Thursday Oct 17, 2013

IOUG SIG Webcast on October 30th : Performance Tuning your DB Cloud


The Oracle Enterprise Manager Special Interest Group (SIG) is a growing body of IOUG members who manage or are interested in all aspects of Oracle Enterprise Manager. This IOUG SIG is managed by volunteers and supported by Oracle Enterprise Manager product managers and developers. The purpose of the SIG is to bring relevant information and education through webcasts, discussions and networking to users interested in learning more about the product, and to share user experiences.

On October 30th at 10 AM pacific time, Oracle Enterprise Manager SIG is hosting a webcast on "Performance Tuning your DB Cloud in OEM 12c Cloud Control - 360 Degrees". In this webcast, Tariq Farooq , CEO, BrainSurface and Mike Ault, Oracle  will provide a tutorial on how to monitor and perform performance tuning of the Oracle database cloud environment.

You will learn how to leverage Oracle Enterprise Manager for tuning, trouble-shooting & monitoring your Oracle Database Cloud Ecosystem. The session covers lessons learned, tips/tricks, recommendations, best practices, gotchas and a whole lot more on how to effectively use Oracle Enterprise Manager Cloud Control 12c for quick, easy & intuitive performance tuning of your Oracle Database Cloud.

Session Objectives:
• Leveraging OEM12c Cloud Control for Oracle DB Tuning/Monitoring
• Limited Deep-Dive on AWR
• Oracle DB Cloud Performance Tuning
• Best Practices for DB Cloud Maintenance/Monitoring

Register Now !

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Wednesday Oct 02, 2013

Highlights from Oracle Enterprise Manager General Session featuring Oracle customers & ACEs

The Oracle Enterprise Manager General session at Oracle Open World 2013 highlighted the efforts of everyday heroes who are driving their IT organizations’ journeys to a more efficient and agile IT. These heroes shared their experiences in deploying and managing large-footprint Oracle stack environments encompassing Oracle Applications, Oracle Fusion Middleware, Oracle Database, and Oracle engineered systems. The session also covered Oracle Enterprise Manager’s own journey as a product in this context and also gave a sneak preview of what’s to come.

Here the is storify highlights from the general session.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Thursday Sep 19, 2013

IOUG Oracle Enterprise Manager SIG Panel Discussion at Oracle OpenWorld

Oracle Enterprise Manager Panel Discussion will be the final session on Sunday before the opening keynote. It will also serve as the EM special interest group (SIG) meeting.  It will be a great  opportunity to meet with colleagues, peers, and subject matter experts to share best practices, tips, and techniques around Oracle technologies. In addition to the Oracle usergroup experts, Oracle executives and experts will be available to answer questions and listen to the user feedback.

If you cannot make it to the session, the IOUG and Oracle Enterprise Manager teams invite you to join a Twitter Chat during this session on Sunday, Sep. 30th from 3:30 PM to 4:30 PM PST.  IOUG leaders, Enterprise Manager SIG contributors and many Oracle Users Forum speakers will answer questions related to their experience with Oracle Enterprise Manager and the activities and resources available for  Enterprise Manager SIG members.

You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c      (Needs Twitter credential for participating). 

Don't forget to join us at the Oracle Enterprise Manager General Session on Tuesday at noon that features many real-world IT heroes who will share their personal journeys with Oracle Enterprise Manager. A full listing of Oracle Enterprise Manager activities at Oracle Enterprise Manager is available at the Focus-on document.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Wednesday Sep 18, 2013

Learn from Korea Telecom and HDFC about their private cloud journey at Oracle Open World

Join us and listen to Korea Telecom and HDFC in the  Zero to Cloud: Real Customers, Real-World Success Stories [CON9585] at Oracle Open World on Tuesday, Sep 24, at 10:30 AM - 11:30 AM in #305 , Moscone South.

In this session, real customers will discuss their real successes as early adopters,  revealing how they were able to organize IT resources into a cloud, enable self service provisioning, publish self service applications and meter and manage the cloud. We'll walk you through their best practices and customer experiences in implementing clouds in the real world for greater agility, IT efficiency and reduced costs.

You will learn how the Data Centers of Korea Telecom transformed to offer Private and Public Infrastructure Services. HDFC will share how they continued their private cloud through Database Schema as a Service.

Don't forget to join us at the Oracle Enterprise Manager General Session that features many real-world IT heroes who will share their personal journeys with Oracle Enterprise Manager. A full listing of Oracle Enterprise Manager activities at Oracle Enterprise Manager is available at the Focus-on document.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Tuesday Sep 17, 2013

Listen to the CTO of SUNY on Deploying Applications in a Private Cloud with Oracle Enterprise Manager

Join us listen to the CTO of SUNY on Deploying Applications in a Private Cloud with Oracle Enterprise Manager at at Oracle Open World on Wednesday, Sep 25 at 10:15 AM - 11:15 AM in #308 , Moscone South.

A typical real world multi-tired applications include Oracle Databases, Oracle Weblogic Server, Oracle Fusion Middleware, web servers, security infrastructures, messaging etc. They also have specific infrastructure requirements like servers, OS, stroage, network, load balancer. It can be quite a chore for DBAs, Fusion Middleware Administrators and System Administrators to deploy and configure such applications. And they need to be deployed in multiple environments like development, test, user acceptance, production.

This session talks about key Enterprise Manager 12c cloud automation capabilities which allow for such applications to be rapidly deployed by the end users like developers/testers themselves through self service, with metering and charge back. System Administrators just need to define application templates and make them available to developers/testers while rest is taken care of by Enterprise Manager. This also enforces standardization with respect to configuration, compliance, security, availability of the different application components.

The session will provide technical details about how to leverage technologies such as Virtualization, Infrastructure as a Service, Database as a Service, Middleware as a Service, Storage/Network provisioning, pooling and consolidation of hardware resources, Oracle Engineered Systems like Exadata, Exalogic etc. to create a private cloud for such applications.

Don't forget to join us at the Oracle Enterprise Manager General Session that features many real-world IT heroes who will share their personal journeys with Oracle Enterprise Manager. A full listing of Oracle Enterprise Manager activities at Oracle Enterprise Manager is available at the Focus-on document.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Monday Sep 16, 2013

Join Real-world IT Heroes & Oracle ACEs in Oracle Enterprise Manager 12c General Session

This year at Oracle Open World, the Oracle Enterprise Manager General Session features many real-world IT heroes who will share their personal journeys with Oracle Enterprise Manager.


In this highly educational and entertaining general session on Tuesday, Sep 24 from 12:00 PM to 1:00 PM in Room #103, Moscone South, you can learn about the efforts of everyday heroes such as you who are driving their IT organizations’ journeys to a more efficient and agile IT. You’ll hear about the experiences of these heroes in deploying and managing large-footprint Oracle stack environments encompassing Oracle Applications, Oracle Fusion Middleware, Oracle Database, and Oracle engineered systems. The presentation places Oracle Enterprise Manager’s own journey as a product in context and also gives you a sneak preview of what’s to come.

You can join us on twitter during the general session as well .You can join the conversation using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c  (Needs Twitter credential for participating).  

You will also see the preview trailer of the upcoming Sci-fi movie Cloud Odyssey : A Hero's Quest   for the first time in the  Oracle Enterprise Manager General Session.  Visit the Cloud Odyssey booth (next to the Tap and Brew!)in Moscone West to learn more and join the crew!


A full listing of Oracle Enterprise Manager activities at Oracle Enterprise Manager is available at the Focus-on document.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Thursday Aug 29, 2013

Go from Zero to Deploying Oracle Database and Applications in the Cloud

Imagine being able to build, deploy, and manage an enterprise private cloud in a matter of hours.

Is it possible? Yes, it is.

Join us for this special online event featuring interactive product demos using real-world IT scenarios to see how it’s done. This webcast will start with a keynote by Sushil Kumar, Vice President, Oracle. This is your opportunity to get a comprehensive overview of how to transform to the private cloud and ask questions of product experts.


Learn how to:

  • Use Oracle hardware and software products to deploy an enterprise cloud
  • Deliver and manage database, applications, and shared IT infrastructures on enterprise private clouds
  • Propel your high-value enterprise applications to the cloud faster and with less effort
Register now for this webcast and take your enterprise to the private cloud in a matter of hours.


Presenters:


Sushil Kumar

Vice President, Business Development and Product Strategy,
Oracle


Martin Pena

Director, Oracle Enterprise Manager Product Management,
Oracle


Anand Akela

Senior Principal Product Marketing Director, Oracle Enterprise Manager,
Oracle



Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Tuesday Aug 27, 2013

Enterprise Manager sessions by Usergroup members at Oracle Openworld 2013 SIG Sunday

Oracle Enterprise Manager 12c

User Group Forum Sessions

Sunday, September 22, 2013 - Moscone West

The IOUG's Enterprise Manager Special Interest Group (EM SIG) wants to let you know of an awesome line-up of Enterprise Manager sessions awaits those who can be there on "SIG Sunday" of Oracle OpenWorld!  It promises to be an interesting mix of real-world use cases and panel discussions from implementers and users.  Click the titles on the listing below for session abstracts. 

Make sure you come early.  Last year many of these sessions were full and folks had to be turned away, so don't let that happen to you.  All sessions will be in the user pavilion area in Moscone West.  While you are there you can stop by the User Group booths in the pavilion to learn more about IOUG in between the sessions.

At the final session of the day, Oracle Enterprise Manager Panel Discussion will also serve as the EM special interest group (SIG) meeting.  It will be a great  opportunity to meet with colleagues, peers, and subject matter experts to share best practices, tips, and techniques around Oracle technologies. In addition to the Oracle usergroup experts, Oracle executives and experts will be available to answer questions and listen to the user feedback.

If you cannot make it to the session, the IOUG and Oracle Enterprise Manager teams invite you to join a Twitter Chat during this session on Sunday, Sep. 30th from 3:30 PM to 4:30 PM PST.  IOUG leaders, Enterprise Manager SIG contributors and many Oracle Users Forum speakers will answer questions related to their experience with Oracle Enterprise Manager and the activities and resources available for  Enterprise Manager SIG members.

You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c      (Needs Twitter credential for participating). 

A full listing of Enterprise Manager activities at OOW is available at the Focus-on EM 12c document.

Session Name
Time Room ID
Extending Oracle Enterprise Manager 12c Features/Functionality: Oracle Application Express
Todd Bellaver, Secure 24 LLC

8-9 AM

3005 UGF9793
Oracle RAC Performance with Oracle Enterprise Manager 12c and AWR—Interconnect Troubleshooting
Tim Quinlan, Scotiabank

8-9 AM

3016
UGF9804
I Have to Patch Again? Patch Management with Oracle Enterprise Manager 12c
Bobby Curtis, BIAS Corporation.

9:15-10:15 AM

3005 UGF9772
 Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware
Leighton Nelson, Mercy Health

10:30-11:30 AM

3005 UGF9794
Oracle Enterprise Manager 12c, Oracle Database 12c, and You
Bobby Curtis, BIAS Corporation.

1-2 PM

3004 UGF9764
Simplify Database Performance Analysis with Oracle Enterprise Manager 12c for Monitoring
Sam Lucido, EMC CORPORATION

1-2 PM

3005 UGF9807
Clustering/High Availability with Oracle VM and Oracle Enterprise Manager 12c: 360 Degrees
Tariq Farooq, BrainSurface & Kai Yu, Dell, Inc.

1-2 PM

3016
UGF9803
Oracle Enterprise Manager Command-Line Interface Illustrated
Ray Smith, Portland General Electric

2:15-3:15 PM

3005 UGF9773
Cloud Computing, Oracle VM, and Oracle Enterprise Manager 12c Best Practices: Expert Panel
Michael Ault, IBM; Tariq Farooq, BrainSurface; Syed Jaffar Hussain, Alinma Bank; Charles Kim, Viscosity North America
2:15-3:15 PM 3018
UGF9756
Oracle Enterprise Manager Panel Discussion
Kris Cook, SITA; Bobby Curtis, BIAS Corporation; Seth Miller, St. Jude Medical; Ray Smith, Portland General Electric

3:30-4:30 PM

3005 UGF9808


Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Google+ Newsletter

Tuesday Aug 20, 2013

Short Demo Video : Deliver Database as a Service with Oracle Enterprise Manager

This demo provides an overview of various use cases and benefits of delivering database as a service using Oracle Enterprise Manager.

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Newsletter Google+

Tuesday Aug 06, 2013

Answers to Your Common Questions on Enterprise Manager 12.1.0.3 Agent deployment using Add Host Targets Wizard (Agent Push)

Deploying EM agents through Add Host Targets Wizard (Agent Push) is one of the most used deployment method and oracle recommended method for deploying multiple agents in a single go.  In this blog we will address some frequently asked questions:

Question 1) Can I perform mass agent deployment using command line?

Ans) Yes, starting EM 12.1.0.3 you can now perform mass agent deployment using EM CLI. This functionality will allow you to push multiple agents from command line.  We can divide EM CLI verbs into 2 categories:


A. Perform agent deployment

a) submit_add_host -- Submit an Add Host session
b) list_add_host_platforms -- List the supported Add Host platforms
c) retry_add_host -- Retry a failed Add Host session

d) continue_add_host - Resume a failed Add Host session


B. Tracking Add Host verbs

a) get_add_host_status        -- Display the latest status of a submitted Add Host session.
b) list_add_host_sessions         -- List the submitted Add Host sessions

You can watch short video on how to perform agent deployment using EMCLI from here:
Screenwatch: How to perform mass agent deployment using Add host wizard (Agent Push) through EM CLI (New in EM 12.1.0.3)

Question 2) Can I use my SSH-key credential while deploying agent through Add Host Targets Wizard (Agent Push) ? 

 Answer 2) Starting EM 12.1.0.3 named credentials support SSH public key authentication and password based authentication. So you can use an existing SSH public key authentication without exposing your passwords. There are 2 use cases here.

i.  If you have setup SSH between the OMS and the target hosts and has the ssh keys handy the he has to follow only steps 4 and 5

ii. If you have not setup SSH between the OMS and the target hosts and does not have the ssh keys then he has to follow steps 1 to 5.

1. Navigate to the following location in the OMS home: $<OMS_HOME>/oui/prov/resources/scripts 

For example, /home/software/em/middleware/oms/oui/prov/resources/scripts

2. Run the following script, and pass the OMS user name you used for installing the OMS and the fully qualified name of the target hosts.

sshUserSetup.sh -setup -user <user_name> -hosts <target_hosts>

3. The SSH keys are generated under $OMS_USER_HOME/.ssh/id_rsa and $OMS_USER_HOME/.ssh/id_rsa.pub

4. Upload the keys to EM

5. Select the keys during agent deployment

Question 3) In my company we use Tectia instead of SSH, can I still use Add Host Targets Wizard (Agent Push) to deploy agents? 

Answer 3)  Yes, Add Host Targets Wizard (Agent Push ) supports SSH Vendors are OpenSSH (SSH2), Tectia. If you have any of these setup between your OMS and target machine you don’t have to do anything extra, application is intelligent enough to pick up the configuration and perform the agent deployment.

Question 4) Does Add Host Targets Wizard (Agent Push) support RSH?  

Answer 4) We don’t support RSH as we need secure shell to perform remote execution and remote copy. Even if RSH is setup Agent push application will not honor it.

Question 5)  I am not sure on which port my SSH is running and how to change SSH port for Add Host Targets Wizard (Agent Push)?

Answer 5) SSH default port is 22 but if you want to cross check or its running on different port then you can cat /etc/ssh/sshd_config to find out what port ssh is running on. Another way to find the port used by SSH you can run:

netstat -anp | grep -i sshd

Output of this command  will be like- 

tcp      0 0 0.0.0.0:22         0.0.0.0:*         LISTEN         3188/sshd

So in the above output 22 is the ssh port.

Once you know the ssh port used, you can update the SSH_PORT property in $<OMS_HOME>/oui/prov/resources/Paths.properties as below: SSH_PORT=<port number>

Question 6) Cygwin is required for deploying agents on Windows host using Add Host Targets Wizard (Agent Push). Once 12c agent is properly installed, is there a need to maintain a copy of Cygwin on the Windows server?  Can it be deleted?

Answer 6) Cygwin 1.7  is required to just deploy EM 12c agent on remote host and can be remove once agents are deployed. Cygwin is not required for any other EM lifecycle operations. 

Follow the steps to configure cygwin for agent deployment from here: http://docs.oracle.com/cd/E24628_01/install.121/e22624/preinstall_req_cygwin_ssh.htm#CBHCDFCH

Question 7)  What is the purpose of user "cyg_server" getting created, while Installing Cygwin, from 12c Cloud Control side. Is this user used during authentication? What if we provide some other username instead of "cyg_server"?

Answer 7) This user is an internal user created by ssh for privilege delegation and not used for agent install.

Question 8) I don’t want to deploy agents using EM login user: SYSMAN. Can I perform role based agent deployment? 

 Answer 8) Yes you can deploy agent from UI and EM CLI with non-sysman user having CREATE_TARGET privilege. If user tries to access the add host page with a user who does not have this privilege, he will get the below error.

Question 9) What all authentication utilities does Add Host Targets Wizard (Agent Push) support?

Answer 9) We support for all standard pdp utilities, sudo, pbrun, sesu , su. 

Question 10) What are the sudo requirements for deploying agent using Add Host Targets Wizard (Agent Push)?

Answer 10)  If your install user can become root then make sure that the /etc/sudoers file have following permission: 

<install_user> ALL=(root) /usr/bin/id, <agent_home>/*/agentdeployroot.sh

For example, oracle ALL=(root) /usr/bin/id, /home/oracle/agentibd/*/agentdeployroot.sh.

Here, oracle is the installing user, and /home/oracle/agentibd is the Management Agent home, that is, the agent base directory.

Question 11) Why do we need install user to have permission to run  /usr/bin/id command?

Answer 11) We use this command to check if the install user has the privilege to switch to root user using the privilege delegation tool.  If you are have locked account usecase then the user that you will switch to should have the permission to run this command. More details on locked account usecase refer to : http://docs.oracle.com/cd/E24628_01/install.121/e22624/install_agent.htm#CACJEFJI

Question 12)  In EM 12.1.0.3 do we still need to set the visiblepw in the /etc/sudoers file?

Answer 12) From EM 12.1.0.3 its not mandatory to set this parameter in /etc/sudoers file instead user can just  pass –enablePty in the additional parameters and set the global property oracle.sysman.prov.agentpush.enablePty=true in $OMS_HOME/sysman/prov/agentpush/agentpush.properties.

You need to set the above property so that the privilege delegation tools such as pbrun, sesu, and su can use pseudo terminal for remote command execution over SSH.

More Information:

What's New in Enterprise Manager 12.1.0.3 Agent Deployment

http://www.oracle.com/technetwork/oem/install-upgrade/em-12103-agent-deployment-1967206.pdf

EM 12.1.0.3 Add Host Targets Wizard (Agent Push) chapter

http://docs.oracle.com/cd/E24628_01/install.121/e22624/install_agent.htm#CACJEFJI 

Screenwatch: How to perform mass agent deployment using Add host wizard (Agent Push) through EM CLI (New in EM 12.1.0.3)  

https://apex.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:7714,1 

    About

    Latest information and perspectives on Oracle Enterprise Manager.

    Related Blogs




    Search

    Archives
    « April 2014
    SunMonTueWedThuFriSat
      
    3
    5
    6
    7
    9
    10
    11
    12
    13
    14
    15
    17
    18
    19
    20
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    Today