运行adaddnode.pl报错ORA-01403 And ORA-06512
来源:互联网 发布:mac给iphone装软件 编辑:程序博客网 时间:2024/06/13 05:14
系统环境如下:
EBS
RDBMS 11.2.0.3
OS
Symptoms
给应用添加节点,运行完adconfig后,执行adaddnode.pl报如下错误:
Configuring snapshot information for the new (clone target) node...
Executing command:
sqlplus /nolog @*********/patch/115/sql/adadmdat.sql APPS apps PROD
PROD erpdev erpweb2 ***********/temp/adadmdat_sql.spool
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 159
Cause
执行adadmdat.sql配置快照信息时报错
Solution
1、在主节点执行adadmin更新快照
adadmin -- Maintain Applications Files -- maintain Snapshot information-- update the current view snapshot
2、重新执行adaddnode.pl
注意adaddnode.pl最先执行adadmprf.sql更新ad_appl_tops表。建议第一次执行adaddnode.pl时备份ad_appl_tops表,以防后续再次执行adaddnode.pl时报
ORA-00001: unique constraint
ORA-06512: at line 25
错误。有了备份就很好补救了。
如果没有提前备份ad_appl_tops表可以使用如下方法解决:
参考Adaddnode.Pl Fails With Ora-00001: Unique Constraint (Applsys.Ad_appl_tops_u2) Violated (文档 ID 1435834.1)
1、备份当前ad_appl_tops表
2、删除new_node条目
SQL> delete from AD_APPL_TOPS where NAME='<new_node>';
SQL> commit;
3、修改文件$APPL_TOP/admin/adconfig.txt中的APPL_TOP_NAME,修改为源环境的值
APPL_TOP_NAME
%%END_OF_TOKEN%%
%%START_OF_VALUE%%
<old_node>
%%END_OF_VALUE%%
4.、Run AutoConfig from $AD_TOP/bin
adconfig.pl contextfile=<put your context file with path>
5. Run adaddnode.pl
6. Verify that new_node was added as a new node and has an associated snapshot. The following queries should return:
SQL> select APPL_TOP_ID, NAME from ad_appl_tops;
APPL_TOP_ID NAME
----------- --------------------------------------------------
...
<Newid> <new_node>
SQL> select APPL_TOP_ID, SNAPSHOT_ID, SNAPSHOT_NAME from ad_snapshots;
APPL_TOP_ID SNAPSHOT_ID SNAPSHOT_NAME
----------- ----------- ----------------------
...
<Newid> <NewSnap_id> CURRENT_VIEW
- 运行adaddnode.pl报错ORA-01403 And ORA-06512
- ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP报错问题处理
- expdp 导出报错 ORA-39006: ORA-39065: ORA-04063: ORA-06508: ORA-39097: ORA-01403: ORA-39097:
- pl/sql developer报错ORA-12170: TNS: 连接超时
- pl/sql 编辑表格 报错 ora-00942的解决方案
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ORACLE11G RAC expdp报错ORA-39002 ORA-39070 ORA-29283 ORA-06512
- 关于PL/SQL Developer 登陆报错 ora-12154 ORA-12560
- Ora-03113 报错
- 报错ora-32035
- ORA-3136报错
- 数据库报错ORA
- ORA-报错解释
- ORA-09817,ORA-01075报错解决方法
- 转 -- ORA-02068,ORA-03113 报错
- ORA-02068,ORA-03113 报错
- impdp报错ORA-31631、ORA-39122
- 在java 中使用 hibernate
- 成绩函数版
- JAVA中的数组与集合,以及互转
- nginx单独添加模块|日志记录post数据
- MySQL备份与恢复之percona-xtrabackup实现增量备份及恢复
- 运行adaddnode.pl报错ORA-01403 And ORA-06512
- Service和Thread的区别
- Android_WindowManager_实现类似360流量悬浮框
- effective c++
- LLVM Overview
- LeetCode Longest Palindromic Substring
- VisualStudio快捷键总结
- 游戏盒子接球
- php学习之字符串转换