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

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

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


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             

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值