GeorgesIT
asked on
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.
Thanks for any help.
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.
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.
ASKER
Where would I find the OEM 11g Client? I can't seem to find an download\install for that product.
explore the following link to see the Oracle By Example Series
http://www.oracle.com/technology/obe/11gr1_db/index.htm
http://www.oracle.com/technology/obe/11gr1_db/index.htm
Especially the following one
http://www.oracle.com/technology/obe/11gr1_db/manage/dbconsole/dbcontrol.htm
http://www.oracle.com/technology/obe/11gr1_db/manage/dbconsole/dbcontrol.htm
ASKER
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.
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
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
and provide the user name and password if it's asked
unzip the downloaded file and install it at windows based system
Enterprise Manager 10g Grid Control (to manage multiple databases at one place)
http://www.oracle.com/technology/software/products/oem/index.html
http://www.oracle.com/technology/software/products/oem/index.html
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
Enterprise Manager 10g Grid Control (to manage multiple databases at one place)
http://www.oracle.com/technology/software/products/oem/index.html
or
you can use "toad for oracle" to manage your databses
http://www.softslist.com/download-10-13-27498.html
http://www.download.com/Toad-for-Oracle/3000-10256_4-10597467.html
you can use "toad for oracle" to manage your databses
http://www.softslist.com/download-10-13-27498.html
http://www.download.com/Toad-for-Oracle/3000-10256_4-10597467.html
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much for your patience!
I think you are talking about OEM client, Yes you can manage the older instaces by OEM 11g Client.