| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: EM10g OMS Install Issues securing repository
On Wed, 03 Jan 2007 15:05:20 -0800, DA Morgan wrote:
> Essentially the OP's complaint is: I don't like the GUI.
My understanding was more like: "this particular GUI sucks" and I cannot dispute that. It really is insufficiently documented, implemented in J2EE, with a ton of XML configuration files. Take a look at the listing of $ORACLE_HOME:
$ ls $ORACLE_HOME
inventory has olap sqlj cdata root.sh diagnostics odbc slax admin OPatch jdk oui relnotes ultrasearch install.platform jdbc ord uix jpub assistants jre oracore xdk wf css jlib owm wwg medo.noip.com_10G crs ldap perl sqlnet.log startup.log clone mesg plsql root.sh.old.1 listener.log bin md rdbms root.sh.old shutdown.log demo lib racg oraInst.loc dbs ctx nls precomp opmn javavm network sysman log install mgw srvm config hs oc4j sqlplus cfgtoollogs$
You get: jre, jdk, j2ee and Perl. Most installations also have a
directory called "Apache". None of these products is an oracle product.
It's a bunch of OSS and I'm allergic to Java. I start sneezing and
coughing and my sinuses start hurting me. OK, let's see the configuration
directory:
$ cd $ORACLE_HOME
$ ls sysman/config
pref emd.properties.template OUIinventories.add emd.properties.emca monwallet emd.properties gridcontrol_classes.lst emca.properties genwallet.pl.template emcalog.properties emoms.properties.template emagentlogging.properties.template emoms.properties.emca emagentlogging.properties.ouibak emomslogging.properties.template emagentlogging.properties emomslogging.properties classpath.lst emomsintg.xml b64LocalCertificate.txt em.ini.template b64InternetCertificate.txtem_ear.properties.template
This is a CONFIGURATION directory, where I would expect to see files with names like emd.ora or emctl.ora, with few well documented parameters, sort of init.ora or listener.ora. But, it wasn't to be. Nobody knows what are these parameter files for and which parameter should go where. Files are amazingly alike:
$ head -10 emcalog.properties
############################################################
# EMCA Logging Configuration File
#
############################################################
############################################################
# Global properties
############################################################
handlers= java.util.logging.ConsoleHandler
$ head emd.properties.emca
#
# perl executable directory
#
perlBin=/oracle/product/10g/perl/bin
#
# script directory
#
scriptsDir=/oracle/product/10g/sysman/admin/scripts
Now, let's see emd.properties:
$ head -10 emd.properties
#
# perl executable directory
#
perlBin=/oracle/product/10g/perl/bin
#
# script directory
#
scriptsDir=/oracle/product/10g/sysman/admin/scripts
$ head -10 emd.properties
#
# perl executable directory
#
perlBin=/oracle/product/10g/perl/bin
#
# script directory
#
scriptsDir=/oracle/product/10g/sysman/admin/scripts
Do they really have to put the location of Perl executable into each and every parameter file? Do they really have to code scriptsDir into each and every parameter file? Have developers heard of a little known variable in the world of Oracle called "ORACLE_HOME"? It's a bad design, no matter how you spin it. I couldn't care less what amount of effort was invested, I'd like to know who made the effort. I wouldn't like to have any of those geniuses working in the same IT with me.
Furthermore, nobody got the bright idea to tell people which Perl modules
they need. It's a plain vanilla Perl 5.8.3 with some things that bring
back memories:
./lib/site_perl/5.8.3/i686-linux-thread-multi/Oraperl.pm
Has anybody here worked with the Perl 4 (subroutines were called with & at the beginning, classes were much poorer and you had to link new oraperl executable to work with Oracle)?
Perl installation is rather ordinary, what could be expected on FC3 or Debian Sarge (3.1) or even Woody (3.0). It contains a full complement of Pod conversion modules which must be enormously useful for working with Oracle. For aficionados, HTMLDB contains php4. Replacing it with php5 is easy.
What do I need 2 Perl installations on my systems for? Actually, it's 3, but I know what I need 5.9 for. Somebody at Oracle could have had a brilliant idea to tell people that Perl 5.8.0+ is needed and tell them what modules to install.
In addition to all that, normal DBCONSOLE agent, started by emctl start dbconsole doesn't talk to the OMS on the repository side. It doesn't even speak SNMP. It's an idiotic web application which uses Java to plot the graphics, of the same general usefulness as my "DBA_Helper". Nagios is much better designed and better looking. somebody should have simply written bunch of Nagios scripts for Oracle and it would be much better looking and more useful.
Furthermore, Perl that comes with Oracle comes with DBD::Oracle 1.15, which is far inferior to version 1.19 by John Scoles and Pythian Group. The latter has the array interface, which makes it faster. MUCH faster. My eternal gratitude and a beer, if I ever get to meet the guy, goes to John Scoles of Pythian Group.
set -a
PATH=$ORACLE_HOME/perl/bin:$PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.8.3:$ORACLE_HOME/perl/lib/5.8.3/i686-linux
-thread-multi:/oracle/product/10g/perl/lib/site_perl/5.8.3
$ perl -e 'use DBD::Oracle; print $DBD::Oracle::VERSION,"\n";' 1.15
Last, the following thing is just plain wrong from the aesthetic point of
view:
$ ps -fu oracle|grep perl
oracle 3944 1 0 23:07 pts/1 00:00:00 /oracle/product/10g/perl/bin/perl /oracle/product/10g/bin/emwd.pl dbconsole /oracle/product/10g/medo.noip.com_10G/sysman/log/emdb.nohup
oracle 5524 3460 0 23:10 pts/1 00:00:00 grep perl
$
Someone should have been executed along with Saddam for having such a command line. This piece of software is crap, no two ways about it. I hope that people at Oracle Corp. will come to their senses and stop putting out half baked products written by an army of little bearded men with funny hats living in the marshlands of Elbonia.
OK, Dan. You can praise the effort now. I'm sure it was a great effort and that Elbonia will defeat Kneebonia soon.
-- http://www.mladen-gogala.comReceived on Thu Jan 04 2007 - 22:30:03 CST
 |
 |