[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 985
  • Last Modified:

Using Oracle Enterprise Manager

I'm a newbie to Oracle and currently have a couple 9i instances and a couple 10g instances. These are being managed by 2 different OEM installations. What I would like to do ideally is install the latest OEM 11g on a Windows server and use it to manage all the instances. So i guess my questions would be: 1) Is it possible to use a newer version of OEM to manager older instances? 2) Is there an installation available for OEM to be installed on Windows that manages AIX Oracle instances? 3) If possible how does that work? I'm assuming that you just put an agent on the AIX boxes and they report back to the Windows server.

Thanks for any help.
0
GeorgesIT
Asked:
GeorgesIT
  • 10
  • 4
1 Solution
 
sonicefuCommented:
) Is it possible to use a newer version of OEM to manager older instances?

I think you are talking about OEM client, Yes you can manage the older instaces by OEM 11g Client.
0
 
sonicefuCommented:
2) Is there an installation available for OEM to be installed on Windows that manages AIX Oracle instances?
Yes, install OEM 11g Client at Windows based system and manage AIX Oracle Instances.


3) If possible how does that work?

Install OEM client at windows and create tns aliases for databases installed at AIX box(es) in the tnsnames.ora file.
0
 
GeorgesITAuthor Commented:
Where would I find the OEM 11g Client? I can't seem to find an download\install for that product.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
sonicefuCommented:
explore the following link to see the Oracle By Example Series

http://www.oracle.com/technology/obe/11gr1_db/index.htm
0
 
sonicefuCommented:
0
 
GeorgesITAuthor Commented:
I'm sorry but I don't see a download to just install the OEM Database management piece. I'm only wanting the management piece. Forgive me if I'm just missing it.
0
 
sonicefuCommented:
signup at otn.oracle.com , membership at oracle technology network (otn) is free

then open the following link

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

and then click at the "accept" link and then click at "instantclient-basic-win32-11.1.0.6.0.zip"

and provide the user name and password if it's asked

unzip the downloaded file and install it at windows based system

0
 
sonicefuCommented:
Enterprise Manager 10g Grid Control (to manage multiple databases at one place)

http://www.oracle.com/technology/software/products/oem/index.html
0
 
sonicefuCommented:
an other option is web based enterprise manager

Enterprise Manager 10g Grid Control (to manage multiple databases at one place)

http://www.oracle.com/technology/software/products/oem/index.html
0
 
sonicefuCommented:
0
 
GeorgesITAuthor Commented:
In SQL Server I have an installation of SQL Management Studio\Enterprise Manager that I have installed on my pc. It is connected to multiple sql servers in our environment. I can use this to create tables\add users\changes schemas\ etc... I'm looking for this same tool Oracle provides to work with there databases. I was of the understanding that it was OEM or Oracle Enterprise Manager. The one I'm using is a web based software running on a Unix box. I would like to have this same software installed on a Windows machine that I connect to to manage all of my Oracle instances. I'm assuming this link http://www.oracle.com/technology/software/products/oem/index.html is the correct place to get this based on the comments you've made. I'm downloading that right now and will install to see. Not sure what the "Grid Control" is and also the latest version of OEM is 11g. I found that by downloading the trial of the 11g Database and when installed it also installs the 11g OEM. I don't see a download for the 11g version. Maybe it's not released like that yet.
0
 
sonicefuCommented:
When you install oracle 10g/11g OEM  (database control or grid control (both are web besed oem)) is selected in the default option. I assume that you've installed oracle with default options. you can access it by typing the following in web browser
https://<hostname>:1158/em

<hostname> is the name of your database server or you can type here the ip address of database server

after connecting you can manage your database as you were able to manage in the sql server.


-----
http://www.oracle.com/technology/obe/11gr1_db/install/dbinst/dbinst.htm
0
 
GeorgesITAuthor Commented:
Thank you so much for your patience!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 10
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now