Solved

Using Oracle Enterprise Manager

Posted on 2008-06-12
14
973 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
  • 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
 
LVL 13

Expert Comment

by:sonicefu
ID: 21770197
0
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now