平台：Oracle10.2.0.1

alert日志文件常会有下面这样的信息：

Memory Notification: Library Cache Object loaded into SGA
Heap size 2261K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

AIX set -o vi

进入vi模式，使命令符下可以找回上一次输入命令

10gR2将default profile中的FAILED_LOGIN_ATTEMPTS改为了10,也就是如果使用错误密码登录10次，该帐号就会被lock住

SQL> select * from dba_profiles;

PROFILE RESOURCE_NAME RESOURCE LIMIT
—————————— ——————————– ——– —————————————-
DEFAULT COMPOSITE_LI

EM启动报错：

C:\Documents and Settings\GAOYANG>set ORACLE_SID=rman

C:\Documents and Settings\GAOYANG>emctl start dbconsole
OC4J Configuration issue. D:\oracle\product\10.2.0

\db_1/oc4j/j2ee/OC4J_DBConsole
_192.100.8.188_rman not found.

重建时可能遇到的问题：
1.EM Configuration issue
2.OC4J Configuration issue

按照如下步骤正常完成Oracle 10g EM Console重建。

C:\Documents and Settings\GAOYANG>emca -config dbco

主：sid=pro
从：sid=bak

主库：

create tablespace test datafile '/u01/app/oracle/oradata/test.dbf' size 10m;

create user test identified by test default tablespace test;

grant connect,resource to test;

主从：
alter system set aq_tm_processes=2 scope=both;
alter system set global_names=true scope=both;
alter system set job_queue_processes=10 scope=both;
alter system set parallel_max_servers=20 scope=both;