impdp导入数据无权限ORA-39213错误
impdp导入数据无权限ORA-39213错误
　　Oracle@linux:~& impdp tbs/tbs directory=dmpdir dumpfile=.dmp
　　Import: Release 11.2.0.1.0 - Production on Sat Dec 31 11:36:18 2011
　　Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
　　Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39006: internal errorORA-39213: Metadata processing is not available
　　oracle@linux:~& oerr ora 392133, "Metadata processing is not available"// *Cause:& The Data Pump could not use the Metadata API.& Typically,//&&&&&&&&& this is caused by the XSL stylesheets not being set up properly.// *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets//&&&&&&&&& to reload the stylesheets.oracle@linux:~& sqlplus /nolog
　　SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 31 11:39:51 2011
　　Copyright (c) , Oracle.& All rights reserved.
　　SQL& conn / as sysdbaConnected.SQL& exec dbms_metadata_util.load_stylesheets
　　PL/SQL procedure successfully completed.
　　ok....
H3C认证Java认证Oracle认证
基础英语软考英语项目管理英语职场英语
.NETPowerBuilderWeb开发游戏开发Perl
二级模拟试题一级模拟试题一级考试经验四级考试资料
港口与航道工程建设工程法规及相关知识建设工程经济考试大纲矿业工程市政公用工程通信与广电工程
操作系统汇编语言计算机系统结构人工智能数据库系统微机与接口
软件测试软件外包系统分析与建模敏捷开发
法律法规历年试题软考英语网络管理员系统架构设计师信息系统监理师
高级通信工程师考试大纲设备环境综合能力
路由技术网络存储无线网络网络设备
CPMP考试prince2认证项目范围管理项目配置管理项目管理案例项目经理项目干系人管理
Powerpoint教程WPS教程
电子政务客户关系管理首席信息官办公自动化大数据
职称考试题目
就业指导签约违约职业测评
招生信息考研政治
网络安全安全设置工具使用手机安全
3DMax教程Flash教程CorelDraw教程Director教程
Dreamwaver教程HTML教程网站策划网站运营Frontpage教程
生物识别传感器物联网传输层物联网前沿技术物联网案例分析
互联网电信IT业界IT生活
Java核心技术J2ME教程
Linux系统管理Linux编程Linux安全AIX教程
Windows系统管理Windows教程Windows网络管理Windows故障
组织运营财务资本
视频播放文件压缩杀毒软件输入法微博
数据库开发Sybase数据库Informix数据库
&&&&&&&&&&&&&&&
希赛网 版权所有 & &&oracle 9.2.0.8 exp导出dmp导入报Segmentation fault/段错误故障解决-Oracle教程-数据库-壹聚教程网oracle 9.2.0.8 exp导出dmp导入报Segmentation fault/段错误故障解决
oracle 9.2.0.8 exp导出dmp导入报Segmentation fault错误我们经常会碰到过，但每次的解决方法与导致的原因都不同，下面来给各位介绍问题的解决办法。
在9.2.0.8 rac环境中,使用exp导出来dmp文件任何报错(按单个表，按用户导出,使用tns方式远程exp导出)，包括重启后导出，无法导入到其他数据库中(本库,tns方式远程导入,ftp传输到远程导入,9i/10g/11g版本)报错类似有setillegal instruction(coredump)，段错误，Segmentation fault等，以下列出来几个报错信息--导入11.2.0.2版本Import:&Release&11.2.0.2.0&-&Production&on&Fri&Mar&27&20:09:51&2015
Copyright(c)&,&Oracle&and/or&its&affiliates.&&All&rights&reserved.
Connected&to:&Oracle&Database&11g&Enterprise&Edition&Release&11.2.0.2.0&-&64bit&Production
With&the&Partitioning,&OLAP,&Data&Mining&and&Real&Application&Testing&options
Export&file&created&by&EXPORT:V09.02.00&via&conventional&path
import&done&in&ZHS16GBK&character&set&and&AL16UTF16&NCHAR&character&setillegal&instruction(coredump)
--导入11.2.0.4版本
Import:&Release&11.2.0.4.0&-&Production&on&Thu&Apr&2&21:12:18&2015&
Copyright&(c)&,&Oracle&and/or&its&affiliates.&All&rights&reserved.&
Connected&to:&Oracle&Database&11g&Enterprise&Edition&Release&11.2.0.4.0&-&64bit&Production&
With&the&Partitioning,&OLAP,&Data&Mining&and&Real&Application&Testing&options&
Export&file&created&by&EXPORT:V09.02.00&via&conventional&path&
Warning:&the&objects&were&exported&by&UNIONDB,&not&by&you&
import&done&in&ZHS16GBK&character&set&and&AL16UTF16&NCHAR&character&set段错误
--导入10.2.0.5版本
Import:&Release&10.2.0.5.0&-&Production&on&Thu&Apr&2&21:44:47&2015
Copyright&(c)&,&Oracle.&&All&rights&reserved.
Connected&to:&Oracle&Database&10g&Enterprise&Edition&Release&10.2.0.5.0&-&64bit&Production
With&the&Partitioning,&OLAP,&Data&Mining&and&Real&Application&Testing&options
Export&file&created&by&EXPORT:V09.02.00&via&conventional&path
Warning:&the&objects&were&exported&by&UNIONDB,&not&by&you
import&done&in&US7ASCII&character&set&and&AL16UTF16&NCHAR&character&set
import&server&uses&ZHS16GBK&character&set&(possible&charset&conversion)
export&client&uses&ZHS16GBK&character&set&(possible&charset&conversion)段错误
增加trace=y跟踪分析
Trace&file&/u01/app/oracle/diag/rdbms/qsng/qsng/trace/qsng_ora_16772.trc&
Oracle&Database&11g&Enterprise&Edition&Release&11.2.0.4.0&-&64bit&Production&
With&the&Partitioning,&OLAP,&Data&Mining&and&Real&Application&Testing&options&
ORACLE_HOME&=&/u01/app/oracle/product/11.2.0/db_1
System&name:&Linux&
Node&name:&localhost.localdomain&
Release:&2.6.32-300.10.1.el5uek&
Version:&#1&SMP&Wed&Feb&22&17:37:40&EST&2012&
Machine:&x86_64&
Instance&name:&qsng&
Redo&thread&mounted&by&this&instance:&1&
Oracle&process&number:&50&
Unix&process&pid:&16772,&image:&oracle@localhost.localdomain&(TNS&V1-V3)&
***&&21:23:11.764&
***&SESSION&ID:(72.1-04-02&21:23:11.764&
***&CLIENT&ID:()&&21:23:11.764&
***&SERVICE&NAME:(SYS$USERS)&&21:23:11.764&
***&MODULE&NAME:(imp@localhost.localdomain&(TNS&V1-V3))&&21:23:11.764&
***&ACTION&NAME:()&&21:23:11.764&
=====================&
PARSING&IN&CURSOR&#864&len=34&dep=1&uid=0&oct=42&lid=0&tim=3775&hv=&ad='7f'&sqlid='14ys3d7nmvxbv'&
ALTER&SESSION&SET&SQL_TRACE&=&TRUE&
END&OF&STMT&
EXEC&#864:c=0,e=65,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=6277&
CLOSE&#864:c=0,e=4,dep=1,type=0,tim=4938&
=====================&
PARSING&IN&CURSOR&#416&len=67&dep=0&uid=0&oct=47&lid=0&tim=5036&hv=&ad='54d651fb0'&sqlid='78wmnnryh9uyp'&
BEGIN&EXECUTE&IMMEDIATE&'ALTER&SESSION&SET&SQL_TRACE&=&TRUE';&END;&
END&OF&STMT&
EXEC&#416:c=2999,e=10041,p=0,cr=0,cu=0,mis=1,r=1,dep=0,og=1,plh=0,tim=5033&
CLOSE&#416:c=0,e=24,dep=0,type=0,tim=5547&
=====================&
PARSING&IN&CURSOR&#416&len=50&dep=0&uid=0&oct=47&lid=0&tim=7424&hv=&ad=''&sqlid='8ppuwaur51jqp'&
BEGIN&SYS.DBMS_EXPORT_EXTENSION.SET_STATSON;&END;&
END&OF&STMT&
PARSE&#416:c=1999,e=1828,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=7422&
=====================&
PARSING&IN&CURSOR&#744&len=41&dep=1&uid=0&oct=42&lid=0&tim=8326&hv=&ad='0'&sqlid='g63fjfq4kgjfn'&
alter&session&set&TIMED_STATISTICS&=&TRUE&
END&OF&STMT&
PARSE&#744:c=0,e=206,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=8325&
EXEC&#744:c=1000,e=5348,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=3803&
CLOSE&#744:c=0,e=4,dep=1,type=0,tim=3879&
EXEC&#416:c=2000,e=6363,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=3926&
=====================&
PARSING&IN&CURSOR&#472&len=37&dep=1&uid=0&oct=3&lid=0&tim=6092&hv=&ad='553f2f718'&sqlid='grwydz59pu6mc'&
&text&from&view$&where&rowid=:1&
END&OF&STMT&
PARSE&#472:c=1000,e=824,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=6091&
=====================&
PARSING&IN&CURSOR&#856&len=210&dep=2&uid=0&oct=3&lid=0&tim=1474&hv=&ad='547f6c0c0'&sqlid='96g93hntrzjtr'&
select&/*+&rule&*/&bucket_cnt,&row_cnt,&cache_cnt,&null_cnt,&timestamp#,&sample_size,&minimum,&maximum,
&distcnt,&lowval,&hival,&density,&col#,&spare1,&spare2,&avgcln&from&hist_head$&where&obj#=:1&and&intcol#=:2&
END&OF&STMT&
PARSE&#856:c=1000,e=1332,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,plh=0,tim=1472&
EXEC&#856:c=2000,e=21773,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,plh=,tim=3432&
FETCH&#856:c=0,e=78,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=3,plh=,tim=3580&
STAT&#856&id=1&cnt=0&pid=0&pos=1&obj=448&op='TABLE&ACCESS&BY&INDEX&ROWID&HIST_HEAD$&(cr=2&pr=0&pw=0&time=108&us)'&
STAT&#856&id=2&cnt=0&pid=1&pos=1&obj=450&op='INDEX&RANGE&SCAN&I_HH_OBJ#_INTCOL#&(cr=2&pr=0&pw=0&time=98&us)'&
CLOSE&#856:c=0,e=5,dep=2,type=3,tim=4838&
EXEC&#856:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=,tim=5112&
FETCH&#856:c=0,e=15,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=3,plh=,tim=5174&
CLOSE&#856:c=0,e=4,dep=2,type=3,tim=5230&
EXEC&#472:c=5000,e=49516,p=0,cr=4,cu=0,mis=1,r=0,dep=1,og=4,plh=,tim=5784&
FETCH&#472:c=0,e=74,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=,tim=5935&
STAT&#472&id=1&cnt=1&pid=0&pos=1&obj=69&op='TABLE&ACCESS&BY&USER&ROWID&VIEW$&(cr=1&pr=0&pw=0&time=59&us&cost=1&size=15&card=1)'&
CLOSE&#472:c=1000,e=79,dep=1,type=0,tim=6064&
=====================&
PARSING&IN&CURSOR&#888&len=50&dep=0&uid=0&oct=3&lid=0&tim=7030&hv=&ad='548d195c8'&sqlid='gnhvzburxkq3s'&
SELECT&value&from&sys.exu8opt&where&parameter&=&:1&
END&OF&STMT&
PARSE&#888:c=7999,e=52316,p=0,cr=6,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=7029&
=====================&
PARSING&IN&CURSOR&#424&len=37&dep=1&uid=0&oct=3&lid=0&tim=7683&hv=&ad='553f2f718'&sqlid='grwydz59pu6mc'&
select&text&from&view$&where&rowid=:1&
END&OF&STMT&
PARSE&#424:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=7681&
EXEC&#424:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=7862&
FETCH&#424:c=0,e=19,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=,tim=7938&
STAT&#424&id=1&cnt=1&pid=0&pos=1&obj=69&op='TABLE&ACCESS&BY&USER&ROWID&VIEW$&(cr=1&pr=0&pw=0&time=10&us&cost=1&size=15&card=1)'&
CLOSE&#424:c=1000,e=79,dep=1,type=0,tim=8062&
EXEC&#888:c=2000,e=2039,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,plh=,tim=9442&
FETCH&#888:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=9653&
STAT&#888&id=1&cnt=1&pid=0&pos=1&obj=0&op='FIXED&TABLE&FULL&X$OPTION&(cr=0&pr=0&pw=0&time=42&us&cost=0&size=81&card=1)'&
CLOSE&#888:c=0,e=77,dep=0,type=0,tim=9862&
CLOSE&#416:c=0,e=15,dep=0,type=0,tim=0042&
=====================&
PARSING&IN&CURSOR&#416&len=54&dep=0&uid=0&oct=47&lid=0&tim=0154&hv=&ad='54aea3138'&sqlid='4jv63yp7dgjyk'&
BEGIN&SYS.DBMS_EXPORT_EXTENSION.SET_NO_OUTLINES;&END;&
END&OF&STMT&
PARSE&#416:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=0153&
=====================&
PARSING&IN&CURSOR&#328&len=48&dep=1&uid=0&oct=42&lid=0&tim=0368&hv=&ad='0'&sqlid='7kgh52cmshpf6'&
alter&session&set&CREATE_STORED_OUTLINES&=&FALSE&
END&OF&STMT&
PARSE&#328:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=0367&
EXEC&#328:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=0510&
CLOSE&#328:c=0,e=3,dep=1,type=0,tim=0557&
EXEC&#416:c=0,e=338,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=0605&
CLOSE&#416:c=0,e=19,dep=0,type=1,tim=0823&
=====================&
PARSING&IN&CURSOR&#336&len=59&dep=0&uid=0&oct=47&lid=0&tim=0946&hv=&ad='551bd30c0'&sqlid='akubp592a0s4w'&
BEGIN&SYS.DBMS_EXPORT_EXTENSION.SET_NLS_NUMERIC_CHAR;&END;&
END&OF&STMT&
PARSE&#336:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=0945&
=====================&
PARSING&IN&CURSOR&#136&len=45&dep=1&uid=0&oct=42&lid=0&tim=1195&hv=&ad='0'&sqlid='45sy639hv9u2w'&
alter&session&set&NLS_NUMERIC_CHARACTERS='.,'
END&OF&STMT&
PARSE&#136:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1194&
EXEC&#136:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1347&
CLOSE&#136:c=0,e=3,dep=1,type=0,tim=1396&
EXEC&#336:c=0,e=347,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1438&
=====================&
PARSING&IN&CURSOR&#016&len=37&dep=1&uid=0&oct=3&lid=0&tim=2676&hv=&ad='553f2f718'&sqlid='grwydz59pu6mc'&
select&text&from&view$&where&rowid=:1&
END&OF&STMT&
PARSE&#016:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=2675&
EXEC&#016:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=2903&
FETCH&#016:c=1000,e=45,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=,tim=3000&
STAT&#016&id=1&cnt=1&pid=0&pos=1&obj=69&op='TABLE&ACCESS&BY&USER&ROWID&VIEW$&(cr=1&pr=0&pw=0&time=22&us&cost=1&size=15&card=1)'&
CLOSE&#016:c=0,e=63,dep=1,type=1,tim=3122&
=====================&
PARSING&IN&CURSOR&#280&len=35&dep=0&uid=0&oct=3&lid=0&tim=4448&hv=&ad=''&sqlid='3mwu4pcxnrj7j'&
SELECT&USERID,NAME&FROM&SYS.IMP9USR&
END&OF&STMT&
PARSE&#280:c=2000,e=2133,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,plh=,tim=4446&
EXEC&#280:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=,tim=4763&
FETCH&#280:c=0,e=68,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=5015&
PARSE&#016:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=6151&
EXEC&#016:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=6279&
FETCH&#016:c=0,e=20,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=,tim=6349&
CLOSE&#016:c=0,e=16,dep=1,type=3,tim=6409&
=====================&
PARSING&IN&CURSOR&#856&len=34&dep=0&uid=0&oct=3&lid=0&tim=7576&hv=&ad=''&sqlid='33pm4s32ynwwc'&
SELECT&NAME,VALUE&FROM&SYS.EXU9NLS&
END&OF&STMT&
PARSE&#856:c=1000,e=1857,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,plh=,tim=7575&
EXEC&#856:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=,tim=7843&
FETCH&#856:c=0,e=83,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=8058&
FETCH&#856:c=0,e=20,p=0,cr=1,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=8214&
FETCH&#856:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=8355&
FETCH&#856:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=0,dep=0,og=1,plh=,tim=8483&
STAT&#856&id=1&cnt=3&pid=0&pos=1&obj=98&op='TABLE&ACCESS&FULL&PROPS$&(cr=5&pr=0&pw=0&time=72&us&cost=2&size=84&card=3)'&
CLOSE&#856:c=0,e=8,dep=0,type=0,tim=8734&
PARSE&#016:c=0,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=9322&
EXEC&#016:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=,tim=9430&
FETCH&#016:c=0,e=17,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=,tim=9495&
CLOSE&#016:c=0,e=15,dep=1,type=3,tim=9554&
=====================&
PARSING&IN&CURSOR&#856&len=37&dep=0&uid=0&oct=3&lid=0&tim=2425&hv=&ad='54cd0a630'&sqlid='as799jkjkdh0z'&
SELECT&COMPATIBLE&FROM&SYS.IMP9COMPAT&
END&OF&STMT&
PARSE&#856:c=3000,e=3443,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,plh=,tim=2424&
EXEC&#856:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=,tim=2721&
FETCH&#856:c=4999,e=4966,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=7851&
CLOSE&#336:c=0,e=18,dep=0,type=1,tim=8283&
=====================&
PARSING&IN&CURSOR&#200&len=65&dep=0&uid=0&oct=47&lid=0&tim=8389&hv=&ad=''&sqlid='6mk0b8p0k0tdx'&
BEGIN&SYS.DBMS_EXPORT_EXTENSION.SET_IMP_TIMEZONE('+08:00');&END;&
END&OF&STMT&
PARSE&#200:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=8387&
=====================&
PARSING&IN&CURSOR&#968&len=36&dep=1&uid=0&oct=42&lid=0&tim=9135&hv=&ad='0'&sqlid='gcqwsz0vyvjan'&
alter&session&set&TIME_ZONE='+08:00'
END&OF&STMT&
PARSE&#968:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=9133&
EXEC&#968:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=9270&
CLOSE&#968:c=0,e=3,dep=1,type=0,tim=9317&
EXEC&#200:c=0,e=882,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=9392&
=====================&
PARSING&IN&CURSOR&#816&len=28&dep=0&uid=0&oct=3&lid=0&tim=0463&hv=&ad='550faead8'&sqlid='7wf7949rym5j0'&
SELECT&DBTIMEZONE&FROM&DUAL&
END&OF&STMT&
PARSE&#816:c=0,e=827,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=,tim=0462&
EXEC&#816:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=,tim=0766&
FETCH&#816:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=,tim=0897&
STAT&#816&id=1&cnt=1&pid=0&pos=1&obj=0&op='FAST&DUAL&(cr=0&pr=0&pw=0&time=2&us&cost=2&size=0&card=1)'&
CLOSE&#816:c=0,e=6,dep=0,type=0,tim=1087&
STAT&#856&id=1&cnt=1&pid=0&pos=1&obj=0&op='HASH&JOIN&(cr=0&pr=0&pw=0&time=4973&us&cost=0&size=2115&card=1)'&
STAT&#856&id=2&cnt=1&pid=1&pos=1&obj=0&op='FIXED&TABLE&FULL&X$KSPPI&(cr=0&pr=0&pw=0&time=3099&us&cost=0&size=81&card=1)'&
STAT&#856&id=3&cnt=982&pid=1&pos=2&obj=0&op='FIXED&TABLE&FULL&X$KSPPCV&(cr=0&pr=0&pw=0&time=1112&us&cost=0&size=203400&card=100)'&
CLOSE&#856:c=0,e=191,dep=0,type=0,tim=1702&
STAT&#280&id=1&cnt=1&pid=0&pos=1&obj=22&op='TABLE&ACCESS&CLUSTER&USER$&(cr=2&pr=0&pw=0&time=68&us&cost=1&size=18&card=1)'&
STAT&#280&id=2&cnt=1&pid=1&pos=1&obj=11&op='INDEX&UNIQUE&SCAN&I_USER#&(cr=1&pr=0&pw=0&time=34&us&cost=0&size=0&card=1)'&
CLOSE&#280:c=0,e=123,dep=0,type=0,tim=1866&
CLOSE&#200:c=0,e=17,dep=0,type=0,tim=1919这里分析，未发现任何错误，导出程序直接报Segmentation fault终止原因分析通过各种方式导入都报类似错误，初步确定是dmp文件异常，而dmp异常有几种可能性：1.exp程序异常导致dmp文件异常，这里使用tns方式导出，排除该种可能2.数据库内存出现异常导致dmp文件异常，重启数据库依旧，排除该种可能3.因为测试过多种平台，版本，本地，远程导入，排除兼容性，远程传输损坏等4.因为以前正常，突然异常，坏可以exp程序调用包异常，这种故障不能排除解决方案鉴于此，通过expcat.sql重新安装相关包，发现执行这个之后，exp导出程序，再imp导入一切正常执行expcat.sql不影响生产库，只影响exp/imp程序conn&/&as&sysdba
@?/rdbms/admin/expcat.sql这里再次提醒我们看到exp导出成功,不能证明imp一定ok,最好通过imp进行导入测试&
上一页： &&&&&下一页：相关内容SQL导入EXCEL报错_百度知道
SQL导入EXCEL报错
0, Line 1无法初始化链接服务器 &quot, Line 1链接服务器 &:&#92, State 1:&#92.4;ad Hoc distributed Queries' 的数据源对象.0&;再执行exec sp_configure ' 的访问, State 1;;外围应用配置器&quot.4, State 1;*Msg 15281, Line 1SQL Server 阻止了对组件 &#39.telphone。提供程序未给出有关错误的任何信息,&#39.0&quot，因为此组件已作为此服务器安全配置的一部分而被关闭.xls' 的 STATEMENT'datebase=G.0'HDR=Yes, Level 16;Excel 8，请参阅 SQL Server 联机丛书中的 &quot：Msg 7399;show advanced options' 的 OLE DB 访问接口 &quot.4.datebase=G;OpenDatasource&#39。 */(null)&quot。Msg 7303.OpenRowset&#47,1reconfigureexec sp_configure 'microsoft.oledbselect * into test from openrowset(&#39,sheet1$)/*Msg 15281.4, State 1;, Line 1结果报错.microsoft.0;;Ad Hoc Distributed Queries&#39.xls'(null)&microsoft。系统管理员可以通过使用 sp_configure 启用 'Excel 8;Ad Hoc Distributed Queries&#39,1reconfigure重新执行select * into test from openrowset(&#39, Level 16.;HDR=Yes.jet, Level 16.jet, Level 16,sheet1$)/ 的详细信息.0&#39,';Ad Hoc Distributed Queries' 的 OLE DB 访问接口 &; 报错。有关启用 &#39
提问者采纳
请提供以下信息，操作系统及版本 office版本 sql 版本
操作系统：XP SP3 英文版SQL：2005office:2007（但文件是保存成2003版本的）
你试用一下这个select * from
OPENROWSET('Microsoft.Ace.OLEDB.12.0',
'Excel 12.0;DATABASE=c:\test.xls' , 'Select * from [Sheet1$]')
Msg 7357, Level 16, State 2, Line 1无法处理对象 &Select * from [Sheet1$]&。链接服务器 &(null)& 的 OLE DB 访问接口 &Microsoft.Ace.OLEDB.12.0& 指示该对象没有列，或当前用户没有访问该对象的权限。
请确认以下信息：1，excel 表中是否有 sheet1表2，excel 表是否关闭，在查询的时候最好把表格关闭掉。
提问者评价
非常感谢你的热心帮助
其他类似问题
为您推荐：
excel的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁查看: 1533|回复: 8
IOS打包出错 exec returned: 1
主题帖子积分
初级会员, 积分 69, 距离下一级还需 131 积分
初级会员, 积分 69, 距离下一级还需 131 积分
IOS打包出错的问题 能否有朋友能指导一下,p12证书都已经在根目录下。证书有效期正常！但是多次打包都报错 exec returned: 1
Task &pack& started.
****ERROR****: Task &pack& finished with error.
****ERROR****: Target &packUseAppBuilderServer& finished with error.
****ERROR****: Build finished with error.
****ERROR**** 错误信息: 执行HTTP请求失败，错误信息：生成app包失败!
错误原因：
exec returned: 1
主题帖子积分
根目录下有没有ios.developer.mobileprovision或ios.distribution.mobileprovision证书？
p12证书的密码是否和build.properties 里面的iosCerPassword一样？
发一下打包服务器日志
远程的联系方法 QQ 。添加好友时，需要填写论坛账号
发远程时同时也发一下帖子的地址，方便了解要解决的问题
如按照该方法解决，请及时跟帖，便于版主结贴
主题帖子积分
初级会员, 积分 102, 距离下一级还需 98 积分
初级会员, 积分 102, 距离下一级还需 98 积分
你看看打包服务器的日志 是不是和 John 兄台的错误一样
我好不容易弄了个证书 打包还是报错&&到底怎么搞才能打个能用的IOS的包啊
技术技术 拜托了
主题帖子积分
初级会员, 积分 69, 距离下一级还需 131 积分
初级会员, 积分 69, 距离下一级还需 131 积分
根目录下有没有ios.developer.mobileprovision或ios.distribution.mobileprovision证书？
p12证书的密码是 ...
ios.developer.mobileprovision 和 ios.developer.p12 都在根目录。
p12证书的密码是否和build.properties 里面的iosCerPassword一样？
这个不知道怎么验证，请给一下方法，导入证书的时候 密码是111111
以下是打包服务器的服务器日志：
Build started.
Task &property& started.
Task &property& finished.
Task &path& started.
Task &path& finished.
Task &typedef& started.
Task &typedef& finished.
Task &svnSetting& started.
Task &svnSetting& finished.
Task &typedef& started.
Task &typedef& finished.
Target &clean& started.
Task &delete& started.
Deleting directory /Volumes/X5/workspace/build/C66E42ADB/build
Task &delete& finished.
Task &delete& started.
Deleting directory /Volumes/X5/workspace/build/C66E42ADB/plugins
Task &delete& finished.
Task &delete& started.
Deleting directory /Volumes/X5/workspace/build/C66E42ADB/dist
Task &delete& finished.
Target &clean& finished.
Target &createApp& started.
Task &copy& started.
Copying 607 files to /Volumes/X5/workspace/build/C66E42ADB/build
Copied 168 empty directories to 16 empty directories under /Volumes/X5/workspace/build/C66E42ADB/build
Task &copy& finished.
Task &chmod& started.
Task &chmod& finished.
Task &chmod& started.
Task &chmod& finished.
Task &chmod& started.
Task &chmod& finished.
Task &chmod& started.
Task &chmod& finished.
Task &chmod& started.
Task &chmod& finished.
Task &chmod& started.
Task &chmod& finished.
Task &copy& started.
Copying 1633 files to /Volumes/X5/workspace/build/C66E42ADB/plugins
Copied 665 empty directories to 8 empty directories under /Volumes/X5/workspace/build/C66E42ADB/plugins
Task &copy& finished.
Target &createApp& finished.
Target &mergeResources& started.
Task &unzip& started.
Expanding: /Volumes/X5/workspace/build/C66E42ADB/upload/x5.zip into /Volumes/X5/workspace/build/C66E42ADB/build
Task &unzip& finished.
Task &unzip& started.
Expanding: /Volumes/X5/workspace/build/C66E42ADB/upload/x5.zip into /Volumes/X5/workspace/build/C66E42ADB
Task &unzip& finished.
Task &property& started.
Task &property& finished.
Target &mergeResources& finished.
Target &prepareBuild& started.
Task &mkdir& started.
Task &mkdir& finished.
Task &mkdir& started.
Created dir: /Volumes/X5/workspace/build/C66E42ADB/dist
Task &mkdir& finished.
Task &prepareBuild& started.
Task &prepareBuild& finished.
Target &prepareBuild& finished.
Target &prepareAndroidBuild& started.
Target &prepareAndroidBuild& finished.
Target &prepareIOSBuild& started.
Task &exec& started.
security: SecKeychainItemImport: MAC verification failed during PKCS12 import (wrong password?)
****ERROR****: Task &exec& finished with error.
****ERROR****: Target &prepareIOSBuild& finished with error.
****ERROR****: Build finished with error.
****ERROR**** 错误信息: exec returned: 1
****ERROR**** 调用栈:
& & & & at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:643)
& & & & at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:669)
& & & & at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:495)
& & & & at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
& & & & at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
& & & & at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
& & & & at java.lang.reflect.Method.invoke(Method.java:606)
& & & & at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
& & & & at org.apache.tools.ant.Task.perform(Task.java:348)
& & & & at org.apache.tools.ant.Target.execute(Target.java:435)
& & & & at org.apache.tools.ant.Target.performTasks(Target.java:456)
& & & & at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
& & & & at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
& & & & at com.justep.deploy.app.servlet.Pack.a(Unknown Source)
& & & & at com.justep.deploy.app.servlet.Pack.doPost(Unknown Source)
& & & & at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
& & & & at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
& & & & at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
& & & & at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
& & & & at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
& & & & at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
& & & & at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
& & & & at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
& & & & at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
& & & & at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
& & & & at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
& & & & at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
& & & & at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
& & & & at java.lang.Thread.run(Thread.java:745)复制代码
主题帖子积分
修改本地app目录下的build.properties文件
iosCerPassword=111111
远程的联系方法 QQ 。添加好友时，需要填写论坛账号
发远程时同时也发一下帖子的地址，方便了解要解决的问题
如按照该方法解决，请及时跟帖，便于版主结贴
主题帖子积分
初级会员, 积分 69, 距离下一级还需 131 积分
初级会员, 积分 69, 距离下一级还需 131 积分
完美解决，可以结贴了，谢谢，正在打包，希望不要出现闪退的情况！
主题帖子积分
中级会员, 积分 355, 距离下一级还需 145 积分
中级会员, 积分 355, 距离下一级还需 145 积分
我设置的就是123456&&怎么就不行
主题帖子积分
初级会员, 积分 157, 距离下一级还需 43 积分
初级会员, 积分 157, 距离下一级还需 43 积分
我的buildproperty里没有ioscertpassword啊
#Tue, 29 Dec :29 +0800
# app used plugins, gen automation
usedPlugins=org.apache.cordova.inappbrowser,org.apache.cordova.camera,com.justep.cordova.plugin.baidulocation,org.apache.cordova.media-capture,org.apache.cordova.geolocation,cn.jpush.phonegap.JPushPlugin,com.justep.cordova.plugin.alipay,org.apache.cordova.device,com.justep.cordova.plugin.weixin.v3
# last pack config
platform=ios
compileUI=false
releaseMode=debug
resPassword=
includeUIRes=true
useProxyBuilderServer=true
proxyBuilderServer=http\://192.168.1.104\:8080/app-builder
主题帖子积分
初级会员, 积分 157, 距离下一级还需 43 积分
初级会员, 积分 157, 距离下一级还需 43 积分
开始......
保存配置信息:
清除编译环境:
复制模版工程:
加密UI资源:
更新工程信息:
& &使用到的插件: [cn.jpush.phonegap.JPushPlugin, org.apache.cordova.splashscreen, org.apache.cordova.device, org.apache.cordova.splashscreen, org.apache.cordova.inappbrowser, org.apache.cordova.camera, com.justep.cordova.plugin.baidulocation, org.apache.cordova.media-capture, org.apache.cordova.geolocation, cn.jpush.phonegap.JPushPlugin, com.justep.cordova.plugin.alipay, org.apache.cordova.device, com.justep.cordova.plugin.weixin.v3]
& &开始准备插件参数......
& &插件 &cn.jpush.phonegap.JPushPlugin& 参数如下：
& && &&&jpush_appkey：182f66b2cdf997f0506650ee
& &插件参数准备完成
& &开始安装插件......
& &Installing &cn.jpush.phonegap.JPushPlugin& for android
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\android\cordova\version&), continuing anyways.
& &Installing &cn.jpush.phonegap.JPushPlugin& for ios
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\ios\cordova\version&), continuing anyways.
& &Installing &org.apache.cordova.splashscreen& for android
& &Installing &org.apache.cordova.splashscreen& for ios
& &Installing &org.apache.cordova.device& for android
& &Installing &org.apache.cordova.device& for ios
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\android\cordova\version&), continuing anyways.Installing &org.apache.cordova.inappbrowser& for android
& &Installing &org.apache.cordova.inappbrowser& for ios
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\ios\cordova\version&), continuing anyways.
& &Installing &org.apache.cordova.camera& for android
& &Installing &org.apache.cordova.camera& for ios
& &Installing &com.justep.cordova.plugin.baidulocation& for android
& &Installing &com.justep.cordova.plugin.baidulocation& for ios
& &Installing &org.apache.cordova.file& for android
& &Installing &org.apache.cordova.file& for ios
& &Installing &org.apache.cordova.media-capture& for android
& &Installing &org.apache.cordova.media-capture& for ios
& &Installing &org.apache.cordova.geolocation& for android
& &Installing &org.apache.cordova.geolocation& for ios
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\android\cordova\version&), continuing anyways.
& &Installing &com.justep.cordova.plugin.alipay& for android
& &Installing &com.justep.cordova.plugin.alipay& for ios
& &cordova version check failed (&F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\ios\cordova\version&), continuing anyways.
& &Installing &com.justep.cordova.plugin.weixin.v3& for android
& &F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\android
& &F:\WeX5_V3.2.1\WeX5_V3.2.1_pre\model\Native\wsd\build\src\platforms\android
& &Installing &com.justep.cordova.plugin.weixin.v3& for ios
& &插件安装完成
创建源代码工程:
使用代理服务生成应用包:
& &压缩应用源代码......
& &上传应用源代码到服务端......
& &服务端正在执行......
****ERROR****: 子任务 &pack& 执行失败。
****ERROR****: 任务 &packUseAppBuilderServer& 执行失败。
****ERROR****: 执行出错：
****ERROR**** 错误信息: 执行HTTP请求失败，错误信息：生成app包失败!
错误原因：
exec returned: 1
服务端调用栈：
调用栈：& & & & at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:643)& & & & at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:669)& & & & at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:495)& & & & at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)& & & & at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)& & & & at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)& & & & at java.lang.reflect.Method.invoke(Method.java:606)& & & & at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)& & & & at org.apache.tools.ant.Task.perform(Task.java:348)& & & & at org.apache.tools.ant.Target.execute(Target.java:435)& & & & at org.apache.tools.ant.Target.performTasks(Target.java:456)& & & & at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)& & & & at org.apache.tools.ant.Project.executeTarget(Project.java:1364)& & & & at com.justep.deploy.app.servlet.Pack.a(Unknown Source)& & & & at com.justep.deploy.app.servlet.Pack.doPost(Unknown Source)& & & & at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)& & & & at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)& & & & at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)& & & & at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)& & & & at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)& & & & at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)& & & & at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)& & & & at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)& & & & at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)& & & & at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)& & & & at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)& & & & at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)& & & & at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)& & & & at java.lang.Thread.run(Thread.java:745)
****ERROR**** 调用栈:
& & & & at com.justep.tools.ant.task.HttpTask.processResponse(Unknown Source)
& & & & at com.justep.tools.ant.task.HttpTask.execute(Unknown Source)
& & & & at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
& & & & at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
& & & & at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
& & & & at java.lang.reflect.Method.invoke(Method.java:606)
& & & & at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
& & & & at org.apache.tools.ant.Task.perform(Task.java:348)
& & & & at org.apache.tools.ant.Target.execute(Target.java:435)
& & & & at org.apache.tools.ant.Target.performTasks(Target.java:456)
& & & & at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
& & & & at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
& & & & at Pack.execTask(Pack.java:46)
& & & & at Pack.access$000(Pack.java:25)
& & & & at Pack$1.run(Pack.java:95)
& & & & at java.lang.Thread.run(Thread.java:745)
Powered by