[Webinar] Streamline your web hosting managementRegister Today

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

installing 10g client on Database server

Hi,

on Oracle 10g db server is it ok to install Oracle client for DB administration e.g. to use Oracle Enterprise Manager?

0
baberamin
Asked:
baberamin
8 Solutions
 
mrjoltcolaCommented:
Yes, you can have multiple Oracle homes, but for your case you should not need to install the client, because the server has everything the client has (except perhaps if the admin did not install all options). The client install is a subset of the server install.

Also, the Enterprise Manager is no longer a client side tool, but is a web based application that runs on the server, and you access it with your browser, so you don't get it with the client with later versions of Oracle. You need to ensure it exists, and ensure it is configured and started on that instance (emctl).



0
 
slightwv (䄆 Netminder) Commented:
To add:

If you have installed Server, you already have the Client installed.  Oracle is client-server just by installing and configuring the Server.

There should be no need to install an extra client.

For a single instance, you can set up DBConsole.  If you want to monitor/administrate more than one or two, you might look at installing and configuring Oracle Grid Control.  Basically the same GUI as DBConsole but for multiple servers.  The drawback, it needs its own Oracle Database to store all of the info.

Here's a decent link on manually installing DBConsole in the database you already have:
http://www.akadia.com/services/ora_dbconsole.html
0
 
MujeeburRahmanCommented:
Yes you can Install the Oracle client in another home apart from the oracle database server home.
This will not affect the work of Database or the client.
There are cases where you need to install the client because some options will work only on client enterprise manager like Oracle replication monitor. You don't have any way to monitor the replication from oracle enterprise manager console.
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.

 
htonkovCommented:
Hi!
You can also install client in the same home as oracle database. That way you wouldn't need to maintain two copies of tnsnames and other files...

Regards
0
 
slightwv (䄆 Netminder) Commented:
htonkov,

You can't install the database without getting the client so there is nothing to be gained by installing over an existing home except the potential of messing up what is already running.
0
 
htonkovCommented:
http://download.oracle.com/docs/cd/B28359_01/install.111/b32007/install.htm

"Oracle Database Client can be installed in the same Oracle Database home if both products are at the same release level. For example, you can install Oracle Database Client 10g Release 2 (10.2) into an existing Oracle Database 10g Release 2 (10.2) home. If you apply a patch set before installing the client, then you must apply the patch set again. Oracle Universal Installer will prompt you for an Oracle home directory, whether you have other Oracle software installed on the computer or not. You cannot install products from one release of Oracle Database Client into an Oracle home directory of a different release. For example, you cannot install Oracle Database 11g release 1 (11.1) software into an existing Oracle9i Oracle home directory. If you attempt to install this release into an Oracle home directory that contains software from an earlier Oracle release, the installation fails."
0
 
slightwv (䄆 Netminder) Commented:
And? All I'm saying is you have most of the tools already with the server install.  If you have the same version of installer, does it really matter if you click 'client' from the OUI window?

It's just a radio button on the installer window.

I feel the question was more about the 'need' than 'can'.  A misunderstanding on what you needed to run enterprise manager.
0
 
baberaminAuthor Commented:
Thanks to all of you for your uselful comments.

Yes, I need Oracle Enterprise manager. Its 10g database so OEM thick client is available with 10g and I like it over web one.

Ok now to launch it from command line what is the command for that?
0
 
slightwv (䄆 Netminder) Commented:
The old Fat Java Client version is supposed to be buried in the 10g client disk somewhere.  I don't think it can be installed from the OUI.  You have to go find it.   It is supposed to still work with 10g.

The problem you will have is you will miss out on all the new 10g features the dbConsole provides.  You will eventually be forced to use the Browser version so the sooner you get used to it, the better off you will be.


It also appears there is some form of Java admin program in the 10.1 that is a Beta:
http://forums.oracle.com/forums/thread.jspa?threadID=235443&tstart=195


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.

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