近日因工作需要收集oracle数据库的相关信息，想偷懒，于是找到了ora2html工具，在
http://ora2html.sourceforge.net/
上有下载，最新版本是v1-47。

先在我的linux平台上的单机oracle10g上运行成功，得到的信息报表内容很丰富，格式也不错。
后在HP－UX平台上的oracle9iRAC上运行，结果运行到一半说是实例没有运行，结过后面的数据库部分都cancel了。
仔细检查ora2html脚本，发现最后面有如下shell：

if [ "$DBINFO_CHECKSIDS" = "" ] ; then
  export DBINFO_ORACLE_SIDS=$(grep -v -E "^$|^#|^\*" $DBINFO_ORATAB | cut -d":" -f1)
else
  export DBINFO_ORACLE_SIDS="$DBINFO_CHECKSIDS"
fi
if [ "$DBINFO_NOSID" = "YES" ] ; then
  AddText std "\nNot checking any databases due to -nosid option"
  DBINFO_ORACLE_SIDS=""
fi
for ORACLE_SID in $DBINFO_ORACLE_SIDS ; do
  let DBINFO_COUNTER+=1
  GetSidEnvironment $ORACLE_SID
  CheckDbStatus

晕倒，原来该脚本是从/etc/oratab中获得ORACLE_SID的，而RAC上的oratab中的实例名都是不带后缀的。
于是，手工编辑/etc/oratab，加上实例后缀1或2，重新执行ora2html，大功告成
当然，事后要改回来。
后来我在linux平台上的oracle10g RAC上也运行成功。

都能收集些什么信息？

顶

QUOTE:

---

原帖由 wgz7747 于 2008-1-11 09:54 发表
都能收集些什么信息？

---

用过就知道了，下面是html的目录：

Contents
Report Summary

1 - Basic system / platform information

1.1 - Server OS
1.2 - Server platform
1.3 - Server memory configuration
1.4 - Server kernel IPC-parameters
1.5 - Server filesystem layout and status

2 - OS user configuration and environment

2.1 - OS-users with admin rights on databases
2.2 - User oracle basic information
2.3 - User oracle environment
2.4 - User oracle crontab
2.5 - User oracle OS-processes

3 - Oracle software and components

3.1 - System oraInst.loc
3.2 - System srvConfig.loc
3.3 - System oratab
3.4 - Detected installations
3.5 - Common SQL*Net settings

3.5.1 - Shared listener configuration
3.5.2 - Shared listener security
3.5.3 - Shared SQL*Net configuraion
3.5.4 - Shared Tnsnames configiration

3.6 - Components and config for ORACLE_HOME=/oracle/product/10.2.0/db_1

3.6.1 - /oracle/product/10.2.0/db_1 : Installed products
3.6.2 - /oracle/product/10.2.0/db_1 : Installed adapters
3.6.3 - /oracle/product/10.2.0/db_1 : SQL*Net settings
3.6.3.1 - /oracle/product/10.2.0/db_1 : Listener configuration
3.6.3.2 - /oracle/product/10.2.0/db_1 : Listener security information
3.6.3.3 - /oracle/product/10.2.0/db_1 : SQL*Net configuration
3.6.3.4 - /oracle/product/10.2.0/db_1 : Tnsnames

4 - Database headdb (/oracle/product/10.2.0/db_1)

4.1 - headdb : Database configuration and logfile

4.1.1 - headdb : System parameter file (spfile)
4.1.2 - headdb : Parameter file (pfile)
4.1.3 - headdb : Config file (ifile)

4.2 - headdb : Internal database setup and configuration

4.2.1 - headdb : Basic instance information
4.2.2 - headdb : License information
4.2.3 - headdb : Available database products and options
4.2.4 - headdb : NLS Parameters
4.2.5 - headdb : System Global Area - SGA

4.2.5.1 - headdb : SGA - Shared Pool
4.2.5.2 - headdb : SGA - Buffer Cache
4.2.5.3 - headdb : SGA - Misc information

4.2.6 - headdb : Program Global Area - PGA
4.2.7 - headdb : Non-default database parameters
4.2.8 - headdb : Runtime modified database parameters

4.3 - headdb : Datafiles and storage setup

4.3.1 - headdb : Archive information
4.3.2 - headdb : Database controlfiles
4.3.3 - headdb : Database redolog files
4.3.4 - headdb : Rollback segments
4.3.5 - headdb : Undo segments
4.3.6 - headdb : Tablespaces

4.3.6.1 - headdb : Tablespace summary
4.3.6.2 - headdb : Tablespace increases
4.3.6.3 - headdb : Tablespaces not listed as online
4.3.6.4 - headdb : Temporary tablespaces
4.3.6.5 - headdb : Locally managed tablespaces
4.3.6.6 - headdb : Transportable tablespaces
4.3.6.7 - headdb : Bigfile tablespaces
4.3.6.8 - headdb : Tablespace fragmentation

4.3.7 - headdb : Datafiles

4.3.7.1 - headdb : Datafile summary
4.3.7.2 - headdb : Datafiles with autoextend enabled
4.3.7.3 - headdb : Datafiles not listed as online
4.3.7.4 - headdb : Datafile IO information
4.3.7.5 - headdb : Datafile Corruption

4.4 - headdb : Users and Roles

4.4.1 - headdb : Users
4.4.2 - headdb : Roles
4.4.3 - headdb : DB Jobs

4.5 - headdb : Database objects

4.5.1 - headdb : Summary of objects by user
4.5.2 - headdb : Invalid objects
4.5.3 - headdb : Directories
4.5.4 - headdb : External tables
4.5.5 - headdb : Snapshots / Materialized views
4.5.6 - headdb : Large segments

4.5.6.1 - headdb : Largest unpartitoned tables
4.5.6.2 - headdb : Largest unpartitoned indexes

4.5.7 - headdb : Partitioned segments

4.5.7.1 - headdb : Partitoned tables
4.5.7.2 - headdb : Partitoned indexes

4.5.8 - headdb : Interesting segments

4.5.8.1 - headdb : Segments that should be relocated
4.5.8.2 - headdb : Segments reaching max extents
4.5.8.3 - headdb : Segments with high # extents
4.5.8.4 - headdb : Segments unable to allocate next extent
4.5.8.5 - headdb : Chaining and migration
4.5.8.6 - headdb : Sysaux objects

4.6 - headdb : Database sessions

4.6.1 - headdb : Current sessions
4.6.2 - headdb : Top CPU users
4.6.3 - headdb : Resumable sessions

4.7 - headdb : Security overview

4.7.1 - headdb : Oracle security parameters
4.7.2 - headdb : Profile security information
4.7.3 - headdb : Database password file users
4.7.4 - headdb : Users authenticated externally
4.7.5 - headdb : Users/roles with worrying roles granted
4.7.6 - headdb : Users/roles with worrying privs granted
4.7.7 - headdb : Default and easy logins
4.7.8 - headdb : Lazy logins

4.8 - headdb : Recovery Manager (RMAN)

4.8.1 - headdb : RMAN Configuration

能发个ora2html给我嘛
谢了

msn:yang_shuo2003@126.com

从这个http://ora2html.sourceforge.net/网站下不下来

good!

类似与oracle自己的RDA - Oracle Remote Diagnostic Agent 这个东西？

看起来和ＲＤＡ很像呀．

嗯，楼主还不如用RDA了．