Thursday, July 24, 2008

LTOM : Tool for "Automatic Session Tracing"-- How to install

=>cd ltom/
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom
=>ls
tom_base
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom
=>ll
total 0
drwxrwxrwx   4 oracle     oinstall        96 Jul  9  2007 tom_base
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom
=>cd tom_base/
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom/tom_base
=>ls
README   install  tom
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom/tom_base
=>ll
total 32
-rw-r--r--   1 oracle     oinstall     13541 May 12 21:29 README
drwxrwxrwx   2 oracle     oinstall      1024 Oct  2  2007 install
drwxrwxrwx   9 oracle     oinstall      1024 Mar 28  2007 tom
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom/tom_base
=>cd install/
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom/tom_base/install
=>ll
total 60
-rwxrwxrwx   1 oracle     oinstall     24795 Feb 27 05:32 autoinstall.sh
-rwxrwxrwx   1 oracle     oinstall       118 Jan 25  2007 cksp.sh
-rwxrwxrwx   1 oracle     oinstall       113 Jan 21  2005 createdbms.sh
-rwxrwxrwx   1 oracle     oinstall       113 Jan 22  2005 createtom.sh
-rwxrwxrwx   1 oracle     oinstall       112 Jan 21  2005 grantdbms.sh
-rwxrwxrwx   1 oracle     oinstall       109 Jan 21  2005 granttom.sh
oracle@hpoce127(rp3440):/mnt/app/oracle/ltom/tom_base/install
=>./autoinstall.sh
TOM_HOME=/mnt/app/oracle/ltom/tom_base/install/../tom
rm: autoinstall.log non-existent

Preparing to install LTOM v4.0.0...

Checking your Oracle Environment...

ORACLE_HOME=/mnt/app/oracle/10gR2_db
ORACLE_SID=orcl10g
TNS_ADMIN=
TOM_HOME=/mnt/app/oracle/ltom/tom_base/install/../tom

Is this the correct Oracle environment you wish to use for installing LTOM?
Hit Return to Accept Default:
============================>

Continuing the install with this environment

Checking for Java...

Java found.

Checking for top utility...
Found top utility.

Checking for vmstat utility...
Found vmstat utility.

Need to run some sql now to create TOM user
Hit Return to allow setup to do this for you, enter other to do this manually:
============================>
Tom user created successfully.
Warning...Please change tom password immediately!

Grant user Tom successful.
Create package dbmssupp successful.
Grant execute on dbmssupp successful.

Checking for statspack...

Cannot verify statspack is installed on your system.
LTOM requires statspack to be installed to work properly.

Enter your email id to get notification of hangs via email...
Hit Return to ignore hang notification via email:
============================>

Configuring tom_deploy.properties file...

TOM/LTOM successfully installed.

Please review any messages you received above.

REMEMBER: You must have TOM_HOME defined and java in your PATH
before you can run TOM/LTOM.

3 comments:

  1. Can LTOM be installed for multiple databases (using same LTOM_HOME )?

    ReplyDelete
  2. Sorry for the delayed reply and thanks for the comment.....

    Logically It should be possible. But I myself have not tried so far :0 You could have a look at Metalink Note:461052.1

    ReplyDelete
  3. Hi,

    Thanks for the response. I'd found out that this is not possible with same copy of LTOM. If I want to monitor 3 databases ons ave server, then I've got to install LTOM at three different locations (lets say in ADMIN folder to maintain a standard) and configure each LTOM seperately.
    That's because in the file "tom_deploy.properties", you can only mention one database using DB_NAME.

    ReplyDelete