[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Using Oracle Enterprise Manager

Posted on 2008-06-12
14
Medium Priority
?
984 Views
Last Modified: 2013-12-12
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
Comment
Question by:GeorgesIT
[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
  • 10
  • 4
14 Comments
 
LVL 13

Expert Comment

by:sonicefu
ID: 21770087
) 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
 
LVL 13

Expert Comment

by:sonicefu
ID: 21770138
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
 

Author Comment

by:GeorgesIT
ID: 21770162
Where would I find the OEM 11g Client? I can't seem to find an download\install for that product.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 13

Expert Comment

by:sonicefu
ID: 21770262
explore the following link to see the Oracle By Example Series

http://www.oracle.com/technology/obe/11gr1_db/index.htm
0
 
LVL 13

Expert Comment

by:sonicefu
ID: 21770271
0
 

Author Comment

by:GeorgesIT
ID: 21771025
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
 
LVL 13

Expert Comment

by:sonicefu
ID: 21771385
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
 
LVL 13

Expert Comment

by:sonicefu
ID: 21771391
Enterprise Manager 10g Grid Control (to manage multiple databases at one place)

http://www.oracle.com/technology/software/products/oem/index.html
0
 
LVL 13

Expert Comment

by:sonicefu
ID: 21771402
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
 
LVL 13

Expert Comment

by:sonicefu
ID: 21771456
0
 

Author Comment

by:GeorgesIT
ID: 21771591
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
 
LVL 13

Accepted Solution

by:
sonicefu earned 1000 total points
ID: 21771900
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
 

Author Comment

by:GeorgesIT
ID: 21771989
Thank you so much for your patience!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question