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