I have recently written a short installation instruction for a customer to use LTOM for RAC hanganalyze.<\/p>\n
tar xfv ltom411.tar<\/p><\/blockquote>\n
\n
- Install statspack<\/li>\n<\/ul>\n
\n
- Installation: db account ltom\/ltom will be created<\/li>\n<\/ul>\n
Java Binary in path
\nwhich java<\/p>\nif not, place java in path in ~\/.bash_profile:
\nals User oracle: add $ORACLE_HOME\/jre\/1.4.2\/bin to PATH Variable<\/p>\ne.g.:
\nexport PATH=$PATH:$ORACLE_HOME\/bin:$ORACLE_HOME\/jre\/1.4.2\/bin<\/p>\nPut TOM_HOME in .~\/.bash_profile:
\nexport TOM_HOME=\/home\/oracle\/ltom\/tom_base\/install\/..\/tom<\/p>\nSourcen of TOM_HOME<\/p>\n
cd \/home\/oracle\/ltom\/tom_base\/install
\n.\/autoinstall.sh<\/p>\nSample Output:
\n[oracle@ora-vm1 install]$ .\/autoinstall.sh
\nTOM_HOME=\/home\/oracle\/ltom\/tom_base\/install\/..\/tom
\nrm: cannot remove `autoinstall.log’: No such file or directory<\/p>\nPreparing to install LTOM v4.0.0…<\/p>\n
Checking your Oracle Environment…<\/p>\n
ORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0
\nORACLE_SID=ORA102
\nTNS_ADMIN=
\nTOM_HOME=\/home\/oracle\/ltom\/tom_base\/install\/..\/tom<\/p>\nIs this the correct Oracle environment you wish to use for installing LTOM?
\nHit Return to Accept Default:
\n============================> \\c<\/p>\nContinuing the install with this environment<\/p>\n
Checking for Java…<\/p>\n
Java found.<\/p>\n
Checking for top utility…
\nFound top utility.<\/p>\nChecking for vmstat utility…
\nFound vmstat utility.<\/p>\nNeed to run some sql now to create TOM user
\nit Return to allow setup to do this for you, enter other to do this manually:
\n============================> \\c<\/p>\nTom user created successfully.
\nWarning…Please change tom password immediately!<\/p>\nGrant user Tom successful.
\nCreate package dbmssupp successful.
\nGrant execute on dbmssupp successful.<\/p>\nChecking for statspack…<\/p>\n
Cannot verify statspack is installed on your system.
\nLTOM requires statspack to be installed to work properly.<\/p>\nEnter your email id to get notification of hangs via email…
\nHit Return to ignore hang notification via email:
\n============================> \\c<\/p>\nConfiguring tom_deploy.properties file…<\/p>\n
TOM\/LTOM successfully installed.<\/p>\n
Please review any messages you received above.<\/p>\n
REMEMBER: You must have TOM_HOME defined and java in your PATH
\nbefore you can run TOM\/LTOM.<\/p><\/blockquote>\n\n
- Configuration<\/li>\n<\/ul>\n
Change ltom\/tom_base\/tom\/init\/hangDetect.properties<\/p>\n
from:
\n#RAC_AWARE=TRUE
\nHANGANALYZE=A
\nSYSTEMSTATE=266
\nDELAY=30
\nHANGANALYZE=A
\nSYSTEMSTATE=266<\/p>\nto:
\nRAW_AWARE=TRUE
\nHANGANALYZE=A
\nSYSTEMSTATE=266
\nDELAY=30
\nHANGANALYZE=A
\nSYSTEMSTATE=266<\/p>\nChange tom db passwort:<\/p>\n
SQL> alter user tom identified by secret;<\/p>\n
Add credentials to config file:<\/p>\n
vi tom_deploy.properties<\/p>\n
DB_USERID=tom
\n:q!<\/p>\n.\/startltom.sh -p
\nEnter same password as in sqlplus. Password will be saved encrypted in tom_deploy.properties<\/p><\/blockquote>\n\n
- edit tom_deploy.properties to decide which of the 3 modules should be running during background operations: hangdetect, profiler, session recorder<\/li>\n<\/ul>\n
\n
- Start\/Stop Scripts<\/li>\n<\/ul>\n
vi start_ltom.sh
\n#!\/bin\/bash
\n. ~\/.bash_profile
\nnohup $TOM_HOME\/startltom.sh -s &<\/p>\nvi stop_ltom.sh
\n#!\/bin\/bash
\ntouch $TOM_HOME\/tmp\/hang.stop
\ntouch $TOM_HOME\/tmp\/profile.stop
\ntouch $TOM_HOME\/tmp\/session.stop<\/p>\nchmod u+x start_ltom.sh
\nchmod u+x stop_ltom.sh<\/p><\/blockquote>\n\n
- If you want\u00a0 to run ltom during a specific timeframe, use cron (as user oracle)<\/li>\n<\/ul>\n
crontab -e
\n45 01 * * *\u00a0\u00a0\u00a0\u00a0 \/home\/oracle\/ltom\/start_ltom.sh >\/dev\/null 2>\/dev\/null <\/dev\/null
\n00 05 * * *\u00a0\u00a0\u00a0\u00a0 \/home\/oracle\/ltom\/start_ltom.sh >\/dev\/null 2>\/dev\/null <\/dev\/null<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"I have recently written a short installation instruction for a customer to use LTOM for RAC hanganalyze. Download von MetaLink Note 352363.1: https:\/\/metalink2.oracle.com\/cgi-bin\/cr\/getfile.cgi?p_attid=352363.1:ltom unzip as User Oracle in directory with sufficient space. subdir ltom will be created tar xfv ltom411.tar Install statspack Installation: db account ltom\/ltom will be created Java Binary in path which java […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13,14,15,19,5,35],"tags":[],"class_list":["post-496","post","type-post","status-publish","format-standard","hentry","category-10g","category-11g","category-9ir2","category-metalink","category-oracle-database","category-real-application-clusters-oracle-database-2"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=496"}],"version-history":[{"count":16,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/496\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/496\/revisions\/507"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}