安装Oracle 的信息生命周期管理工具(ILM assistant)(一)

2014-11-24 18:46:32 · 作者: · 浏览: 6

今天安装了一下,步骤很简单!


检查环境:


SQL> show parameter job


NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ 要大于0.
job_queue_processes integer 1000
SQL> select username from dba_users where username like 'APEX%';


USERNAME
------------------------------
APEX_030200 要有这个用户!
APEX_PUBLIC_USER


以sys用户连接sqlplus 执行下面脚本


SQL> @ilma_install apex_030200 ilm_tablespace orcl


Session altered.



Session altered.



PL/SQL procedure successfully completed.








*******************************************************************
ILM Assistant Installation Procedure
*******************************************************************



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.









Session altered.



User created.



Grant succeeded.



Grant succeeded.



Grant succeeded.



Grant succeeded.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.



Type created.



Type created.


No errors.


Type created.



Package created.



Package created.



Package created.



Package created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



Sequence created.



PL/SQL procedure successfully completed.



Table created.



Table created.



Index created.



Index created.



Table created.



Index created.



Table created.



Index created.



Table created.



Index created.



Table created.



Index created.



Table created.



Index created.



Index created.



Table created.



Index created.



Index created.



Table created.



Index created.



Table created.



Index created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Table created.



Index created.



Index created.



Table created.



Index created