PLM系统实施过程中经常需要做整个系统的克隆备份。Teamcenter2007在做基于Oracel的系统克隆时,用exp功能导出数据表,部署在目标机器上时会遇到DBMS错误,导致后续DB写操作无法进行。查看日志片段如下:
*** NOTE:: in line 506 of d:\tc072w0119\src\core\fclasses\error_store.cxx at Thu Aug 01 18:05:54 2013 中国标准时间
+++ in processing error text "由于某些意外的 DBMS 错误失败" we never substituted argument 1 : Newstuff
*** NOTE:: in line 2177 of d:\tc072w0119\src\foundation\pom\eim\eim_enquire.cxx at Thu Aug 01 18:05:54 2013 中国标准时间
+++ OCIStmtExecute error -1 942 "SELECT ref_uid,vuid,process,type FROM POM_LOCK WHERE ref_uid = :1"
这是由于用exp功能导出数据时,DB视图没有一起导出。在命令行下执行如下语句,重启Teamcenter即可:
1 sqlplus /nolog 2 3 connect infodba/infodba@tc as sysdba 4 5 CREATE OR REPLACE VIEW POM_LOCK AS SELECT ref_uid,vuid,process,ref_class,type FROM POM_M_LOCK UNION SELECT 6 ref_uid,vuid,process,ref_class,type FROM POM_R_LOCK; 7 8 exit
浙公网安备 33010602011771号