ORACLE 10064诊断工具，TRCA安装与测试

最新推荐文章于 2025-08-22 11:17:10 发布

原创

最新推荐文章于 2025-08-22 11:17:10 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了如何安装和测试Oracle的TRCA工具，包括安装过程中的用户创建、表空间选择，以及安装成功后的数据字典快照和测试操作。通过TRCA，可以对10064错误进行诊断并生成详细的分析报告。

1：安装

[oracle@st8cserver16 tmp]$ cd /tmp/trca/install/
[oracle@st8cserver16 install]$ ls
tacobj.sql   tacpkgg.pks tacpkgp.pks tacpkgt.pkb tacreate.sql tadrop.sql
tacpkge.pkb tacpkgi.pkb tacpkgr.pkb tacpkgt.pks tacusr.sql    tadusr.sql
tacpkge.pks tacpkgi.pks tacpkgr.pks tacpkgx.pkb tacvw.sql     tasqdirset.sql
tacpkgg.pkb tacpkgp.pkb tacpkg.sql   tacpkgx.pks tadobj.sql    tautltest.sql
[oracle@st8cserver16 install]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 7月 17 17:39:53 2012

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> @tacreate.sql --运行此脚本
Uninstalling TRCA, please wait
TADOBJ completed.
SQL>
SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE;
SQL> REM If this DROP USER command fails that means a session is connected with this user.
SQL> DROP USER trcanlzr CASCADE;
SQL> WHENEVER SQLERROR CONTINUE;
SQL>
SQL> SET ECHO OFF;
TADUSR completed.
TADROP completed.

Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key

Optional Connect Identifier (ie: @PROD): --直接回车，默认创建trcanlzr用户

Define the TRCANLZR user password (hidden and case sensitive).

Specify TRCANLZR password:
Re-enter password:

Set up TRCANLZR temporary and default tablespaces

Below are the list of online tablespaces in this database.
Decide which tablespace you wish to create the TRCANLZR tables
and indexes. This will also be the TRCANLZR user default tablespace.

Specifying the SYSTEM tablespace will result in the installation
FAILING, as using SYSTEM for tools data is not supported.

Wait...

TABLESPACE_NAME         FREE_SPACE_MB
------------------------------ -------------
EAINDEX_IDX     200
FLINK_DATA     361
USERS      389
WZ_DATA     1018
EAINDEX_DATA    1925
SMSWAY           10240
NEWADUNION         226965

Above is the list of online tablespaces in this database.
Decide which tablespace you wish to create the TRCANLZR tables
and indexes. This will also be the TRCANLZR user default tablespace.

Specifying the SYSTEM tablespace will result in the installation
FAILING, as using SYSTEM for tools data is not supported.

Tablespace name is case sensitive.

Default tablespace [UNKNOWN]: NEWADUNION