Oracle1463,Oracle LTOM数据库故障诊断工具！

LTOM和上一篇文章提到的OSW工具类似，都是oracle提供的一个诊断工具，不过OSW是基于OS层面的信息统计，LTOM则倾向于统计数据库的相关信息，结合这2个诊断工具，可以给DBA减少不少的工作量。和OSW一样，LTOM同样支持多平台：Solaris,Linux,HP-UX,AIX,Tru64. 目前最新版本是4.3.1，文章末尾有下载地址。下面简单是来看一下LTOM的安装和使用。

1. 上传LTOM安装包到服务器，并解压

PgSQL

jerry@linux-fz9d:~> ll

total 10548

drwxr-xr-x 2 jerry users 4096 Jul 12 2013 bin

-rw-r--r-- 1 jerry users 9318400 Mar 27 12:06 ltom431.tar

jerry@linux-fz9d:~> tar -xvf ltom431.tar

ltom/

ltom/tom_base/

ltom/tom_base/tom/

ltom/tom_base/tom/hanglog/

ltom/tom_base/tom/init/

ltom/tom_base/tom/init/dataCollect.properties

ltom/tom_base/tom/init/hangDetect.properties

ltom/tom_base/tom/init/sessionRecorder.properties

ltom/tom_base/tom/init/tom_deploy.properties

ltom/tom_base/tom/src/

ltom/tom_base/tom/src/ass109.awk

ltom/tom_base/tom/src/errorstack.sh

...

...

...

jerry@linux-fz9d:~> ll

total 10552

drwxr-xr-x 2 jerry users 4096 Jul 12 2013 bin

drwxr-xr-x 3 jerry users 4096 Mar 28 2007 ltom

-rw-r--r-- 1 jerry users 9318400 Mar 27 12:06 ltom431.tar

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

jerry@linux-fz9d:~>ll

total10548

drwxr-xr-x2jerryusers4096Jul122013bin

-rw-r--r--  1 jerry users 9318400 Mar 27 12:06 ltom431.tar

jerry@linux-fz9d:~>tar-xvfltom431.tar

ltom/

ltom/tom_base/

ltom/tom_base/tom/

ltom/tom_base/tom/hanglog/

ltom/tom_base/tom/init/

ltom/tom_base/tom/init/dataCollect.properties

ltom/tom_base/tom/init/hangDetect.properties

ltom/tom_base/tom/init/sessionRecorder.properties

ltom/tom_base/tom/init/tom_deploy.properties

ltom/tom_base/tom/src/

ltom/tom_base/tom/src/ass109.awk

ltom/tom_base/tom/src/errorstack.sh

...

...

...

jerry@linux-fz9d:~>ll

total10552

drwxr-xr-x2jerryusers4096Jul122013bin

drwxr-xr-x3jerryusers4096Mar282007ltom

-rw-r--r--  1 jerry users 9318400 Mar 27 12:06 ltom431.tar

2. 解压之后会得到ltom目录，进入到tom_base目录，可以看到有2个目录，一个是install，另一个是tom，还有一个README的文件，可以查看README文件进行安装，首先进入Install目录，运行autoinstall.sh脚本自动安装ltom，这里需要注意的是，在运行这个自动安装的脚本之前，一定要给当前用户配置3个环境变量：java的环境变量，ORACLE_HOME, ORACLE_SID, TOM_HOME。

PgSQL

----------------------------我这里配置的环境变量如下，我使用的是oracle用户安装，不然等下无法创建tom数据库用户，因为需要管理员的权限

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/12.1/db_1

export ORACLE_SID=ora12c130

export JAVE_HOME=/opt/oracle/product/12.1/db_1/jdk/jre

export PATH=/opt/oracle/product/12.1/db_1/jdk/jre/bin:$PATH:HOME/bin:$ORACLE_HOME/bin

export TOM_HOME=/opt/oracle/ltom/tom_base/tom

----------------------------然后运行autoinstall.sh脚本

oracle@linux-fz9d:~/ltom/tom_base/install> ./autoinstall.sh

TOM_HOME=/opt/oracle/ltom/tom_base/install/../tom

rm: cannot remove `autoinstall.log': No such file or directory

Preparing to install LTOM v4.3.0...

Checking your Oracle Environment...

ORACLE_HOME=/opt/oracle/product/12.1/db_1

ORACLE_SID=ora12c130

TNS_ADMIN=

TOM_HOME=/opt/oracle/ltom/tom_base/install/../tom

Is this the correct Oracle environment you wish to use for installing LTOM?

Hit Return to Accept Default:

============================> \c

Continuing the install with this environment

Checking for Java...

./autoinstall.sh: line 176: /tmp/jstout.txt: Permission denied

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:

============================> \c

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:

============================> \c

xxxx@qq.com --------输入你的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.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

----------------------------我这里配置的环境变量如下，我使用的是oracle用户安装，不然等下无法创建tom数据库用户，因为需要管理员的权限

exportORACLE_BASE=/opt/oracle

exportORACLE_HOME=/opt/oracle/product/12.1/db_1

exportORACLE_SID=ora12c130

exportJAVE_HOME=/opt/oracle/product/12.1/db_1/jdk/jre

exportPATH=/opt/oracle/product/12.1/db_1/jdk/jre/bin:$PATH:HOME/bin:$ORACLE_HOME/bin

exportTOM_HOME=/opt/oracle/ltom/tom_base/tom

----------------------------然后运行autoinstall.sh脚本

oracle@linux-fz9d:~/ltom/tom_base/install>./autoinstall.sh

TOM_HOME=/opt/oracle/ltom/tom_base/install/../tom

rm:cannotremove`autoinstall.log':Nosuchfileordirectory

PreparingtoinstallLTOMv4.3.0...

CheckingyourOracleEnvironment...

ORACLE_HOME=/opt/oracle/product/12.1/db_1

ORACLE_SID=ora12c130

TNS_ADMIN=

TOM_HOME=/opt/oracle/ltom/tom_base/install/../tom

IsthisthecorrectOracleenvironmentyouwishtouseforinstallingLTOM?

HitReturntoAcceptDefault:

============================>\c

Continuingtheinstallwiththisenvironment

CheckingforJava...

./autoinstall.sh:line176:/tmp/jstout.txt:Permissiondenied

Javafound.

Checkingfortoputility...

Foundtoputility.

Checkingforvmstatutility...

Foundvmstatutility.

NeedtorunsomesqlnowtocreateTOMuser

HitReturntoallowsetuptodothisforyou,enterothertodothismanually:

============================>\c

Tomusercreatedsuccessfully.

Warning...Pleasechangetompasswordimmediately!

GrantuserTomsuccessful.

Createpackagedbmssuppsuccessful.

Grantexecuteondbmssuppsuccessful.

Checkingforstatspack...

Cannotverifystatspackisinstalledonyoursystem.

LTOMrequiresstatspacktobeinstalledtoworkproperly.

Enteryouremailidtogetnotificationofhangsviaemail...

HitReturntoignorehangnotificationviaemail:

============================>\c

xxxx@qq.com--------输入你的Email账号

Configuringtom_deploy.propertiesfile...

TOM/LTOMsuccessfullyinstalled.

Pleasereviewanymessagesyoureceivedabove.

REMEMBER:YoumusthaveTOM_HOMEdefinedandjavainyourPATH

beforeyoucanrunTOM/LTOM.

3. 配置完成后，如果需要修改采集配置，在ltom/tom_base/tom/init目录下可以看到相关的配置文件，可以按需修改

PgSQL

oracle@linux-fz9d:~/ltom/tom_base/tom/init> ll

total 20

-rw-r--r-- 1 oracle oinstall 3619 Oct 4 2007 dataCollect.properties

-rw-r--r-- 1 oracle oinstall 7087 Oct 6 2007 hangDetect.properties

-rw-r--r-- 1 oracle oinstall 3544 Oct 6 2007 sessionRecorder.properties

-rw-r--r-- 1 oracle oinstall 3956 Mar 27 12:39 tom_deploy.properties

oracle@linux-fz9d:~/ltom/tom_base/tom/init> pwd

/opt/oracle/ltom/tom_base/tom/init

1

2

3

4

5

6

7

8

oracle@linux-fz9d:~/ltom/tom_base/tom/init>ll

total20

-rw-r--r-- 1 oracle oinstall 3619 Oct  4  2007 dataCollect.properties

-rw-r--r-- 1 oracle oinstall 7087 Oct  6  2007 hangDetect.properties

-rw-r--r-- 1 oracle oinstall 3544 Oct  6  2007 sessionRecorder.properties

-rw-r--r-- 1 oracle oinstall 3956 Mar 27 12:39 tom_deploy.properties

oracle@linux-fz9d:~/ltom/tom_base/tom/init>pwd

/opt/oracle/ltom/tom_base/tom/init

4. 配置完成后，就可以执行startltom.sh脚本了，在执行这个脚本的时候，需要输入tom数据库用户，但可能你会遇到一个ORA-28040: No matching authentication protocol错误，这是由于没有匹配的身份认证协议，是JDBC一个常规的错误，这时候需要将sqlnet.ora里的SQLNET.ALLOWED_LOGON_VERSION值设置为8，我这里设置为8后，就可以连接成功了。

PgSQL

oracle@linux-fz9d:~/ltom/tom_base/tom> ./startltom.sh

Enter username:tom

Enter your password:****

*ORA-28040: No matching authentication protocol

Login ERROR! Login failed with username = tom

Login ERROR! Login failed with password = tom

Login ERROR! Login failed with connectString = jdbc:oracle:thin:@linux-fz9d:1521:ora12c130

User/Password was not valid. Please re-enter:

Enter username:tom

Enter your password:****

Starting LTOM V4.3.1

LTOM written by Oracle Center of Expertise

Copyright (c) 2010 by Oracle Corporation

Enter 1 to Start Auto Hang Detection

Enter 2 to Stop Auto Hang Detection

Enter 3 to Start System Profiling

Enter 4 to Stop System Profiling

Enter 7 to Start Session Tracing

Enter 71 to Display Sessions Traced

Enter 72 to Dump All Trace Buffers

Enter 73 to Dump Specific Trace Buffer

Enter 74 to Stop Specific Session Tracing

Enter 8 to Stop All Session Tracing

Enter S to Update status

Enter Q to End Program

CURRENT STATUS: HangDetection=OFF Profiling=OFF AutoRec=OFF SessionRec=OFF

Please Select an Option:3

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

oracle@linux-fz9d:~/ltom/tom_base/tom>./startltom.sh

Enterusername:tom

Enteryourpassword:****

*ORA-28040:Nomatchingauthenticationprotocol

LoginERROR!Loginfailedwithusername=tom

LoginERROR!Loginfailedwithpassword=tom

LoginERROR!LoginfailedwithconnectString=jdbc:oracle:thin:@linux-fz9d:1521:ora12c130

User/Passwordwasnotvalid.Pleasere-enter:

Enterusername:tom

Enteryourpassword:****

StartingLTOMV4.3.1

LTOMwrittenbyOracleCenterofExpertise

Copyright(c)2010byOracleCorporation

Enter1toStartAutoHangDetection

Enter2toStopAutoHangDetection

Enter3toStartSystemProfiling

Enter4toStopSystemProfiling

Enter7toStartSessionTracing

Enter71toDisplaySessionsTraced

Enter72toDumpAllTraceBuffers

Enter73toDumpSpecificTraceBuffer

Enter74toStopSpecificSessionTracing

Enter8toStopAllSessionTracing

EnterStoUpdatestatus

EnterQtoEndProgram

CURRENTSTATUS:HangDetection=OFFProfiling=OFFAutoRec=OFFSessionRec=OFF

PleaseSelectanOption:3

然后就可以对数据库进行监控了，也可以生产图表的方式，这里给出ltom431的下载地址。点我下载

转载请注明: 版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

最后编辑：2019-04-30作者：Jerry

一个积极向上的小青年，热衷于分享--Focus on DB,BI,ETL