Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
5 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Configuring Oracle 9i OEM & OMS
Posted on 2006-11-01
Greetings,
If I configure Oracle 9i OEM & OMS on a windows platform, can I manage oracle database and create jobs for all of my databases that reside in a unix environment or will I have to configure my Oracle 9i OEM & OMS in a unix environment? Can I actually create backup jobs and monitor Oracle database(which all reside on unix servers) if the OEM and OMS is configured on a windows platform? Also do you have step by step instructions for configuring Oracle 9i OEM & OMS that I can find online?
If I configure Oracle 9i OEM & OMS on a windows platform, can I manage oracle database and create jobs for all of my databases that reside in a unix environment or will I have to configure my Oracle 9i OEM & OMS in a unix environment? Can I actually create backup jobs and monitor Oracle database(which all reside on unix servers) if the OEM and OMS is configured on a windows platform? Also do you have step by step instructions for configuring Oracle 9i OEM & OMS that I can find online?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
2
9 Comments
Hi,
OMS is platform independant, the last place i worked, we had OMS9i installed on windows looking after databases / listeners / web servers on solaris, linux and windows platforms. the OMS talks to the various boxes through the agent that is installed on the boxes, it is a platform independant communication. What you can do for a windows database using OMS, you can do for a UNIX database as well. will look for an install guide.
:)
OMS is platform independant, the last place i worked, we had OMS9i installed on windows looking after databases / listeners / web servers on solaris, linux and windows platforms. the OMS talks to the various boxes through the agent that is installed on the boxes, it is a platform independant communication. What you can do for a windows database using OMS, you can do for a UNIX database as well. will look for an install guide.
:)
When configuring backup jobs in the OMS website, will you have to create a new backup job within RMAN or does it create a job for you in RMAN?
I have not used rman, i would assume that once you have created the job in OEM, it will do all the rman work for you.
easiest way is to test this on a TEST instance and see what happens..
easiest way is to test this on a TEST instance and see what happens..
So when you configured you backups jobs you excluded the whole concept of using RMAN for one of you components when configuring your backup? We will be upgrading our 9i databases to 10g soon and I know the 10g OEM & OMS supports 9i databases so I guess it would be best to configure my OEM & OMS in the 10g version correct? I know you can't use the 9i agents for 10g so I would have to install the 10g agents on all the host database servers correct? Does that 10g agent cover all databases on the host or just for one database?
Hi,
q1: did i exclude rman from my backup jobs?
yes. all the backups for all the oracle databases htat i looked after ( about 5-10 production ones ) were backed up using scheduled scripts. OEM was not used for the backups.
q2: do i use 9i oem or 10g grid control?
use 10g grid control, this is backward compatible with 9i databases, although you will not get the full functionality
q3: a 9i or 10g agent?
10g agent for 10g grid control.
q4: does the agent cover everything on the box?
yes, there needs to be one and only one 10g agent on each machine you wish to monitor. it will discover all the db's, listeners, IAS installs etc that are running on the host
:)
q1: did i exclude rman from my backup jobs?
yes. all the backups for all the oracle databases htat i looked after ( about 5-10 production ones ) were backed up using scheduled scripts. OEM was not used for the backups.
q2: do i use 9i oem or 10g grid control?
use 10g grid control, this is backward compatible with 9i databases, although you will not get the full functionality
q3: a 9i or 10g agent?
10g agent for 10g grid control.
q4: does the agent cover everything on the box?
yes, there needs to be one and only one 10g agent on each machine you wish to monitor. it will discover all the db's, listeners, IAS installs etc that are running on the host
:)
Featured Post
On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month5 days, 22 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.