用exp导出数据库数据时提示“无法分配 131100 字节的共享内存”
具体的?:
exp vesta/sht2010@ADAM file=d:\daochu.dmp full=y
。
。
。
。
。
。
. . exporting table TBWPWTOWEROPCTRL 1 rows exported
. . exporting table TBWPWTRANSMISSION 1 rows exported
. . exporting table TBWPWTRANSOPCTRL 0 rows exported
. . exporting table TBWPWTRF 1 rows exported
. . exporting table TBWPWTRFOPCTRL 0 rows exported
. . exporting table TBWPWTTYPE 3 rows exported
. . exporting table TBWPWYAW 1 rows exported
. . exporting table TBWPWYAWOPCTRL 0 rows exported
. . exporting table TBWPYWBRAKEST 3 rows exported
. . exporting table TBWPYWST 5 rows exported
. exporting synonyms
. exporting views
EXP-00056: ORACLE error 4031 encountered
ORA-04031: 无法分配 131100 字节的共享内存 ("large pool","unknown object","session heap","kuxLpxAlloc")
ORA-06512: 在 "SYS.UTL_XML", line 152
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7195
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 9135
ORA-06512: 在 "SYS.DBMS_METADATA", line 1882
ORA-06512: 在 "SYS.DBMS_METADATA", line 3707
ORA-06512: 在 "SYS.DBMS_METADATA", line 3689
ORA-06512: 在 line 1
EXP-00056: ORACLE error 4031 encountered
ORA-04031: 无法分配 131100 字节的共享内存 ("large pool","unknown object","session heap","kuxLpxAlloc")
ORA-06512: 在 "SYS.UTL_XML", line 152
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7195
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 9135
ORA-06512: 在 "SYS.DBMS_METADATA", line 1882
ORA-06512: 在 "SYS.DBMS_METADATA", line 3707
ORA-06512: 在 "SYS.DBMS_METADATA", line 3689
ORA-06512: 在 line 1
EXP-00000: Export terminated unsuccessfully
这个问题怎么解决啊,盼望指导!
具体的?:
exp vesta/sht2010@ADAM file=d:\daochu.dmp full=y
。
。
。
。
。
。
. . exporting table TBWPWTOWEROPCTRL 1 rows exported
. . exporting table TBWPWTRANSMISSION 1 rows exported
. . exporting table TBWPWTRANSOPCTRL 0 rows exported
. . exporting table TBWPWTRF 1 rows exported
. . exporting table TBWPWTRFOPCTRL 0 rows exported
. . exporting table TBWPWTTYPE 3 rows exported
. . exporting table TBWPWYAW 1 rows exported
. . exporting table TBWPWYAWOPCTRL 0 rows exported
. . exporting table TBWPYWBRAKEST 3 rows exported
. . exporting table TBWPYWST 5 rows exported
. exporting synonyms
. exporting views
EXP-00056: ORACLE error 4031 encountered
ORA-04031: 无法分配 131100 字节的共享内存 ("large pool","unknown object","session heap","kuxLpxAlloc")
ORA-06512: 在 "SYS.UTL_XML", line 152
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7195
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 9135
ORA-06512: 在 "SYS.DBMS_METADATA", line 1882
ORA-06512: 在 "SYS.DBMS_METADATA", line 3707
ORA-06512: 在 "SYS.DBMS_METADATA", line 3689
ORA-06512: 在 line 1
EXP-00056: ORACLE error 4031 encountered
ORA-04031: 无法分配 131100 字节的共享内存 ("large pool","unknown object","session heap","kuxLpxAlloc")
ORA-06512: 在 "SYS.UTL_XML", line 152
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 7195
ORA-06512: 在 "SYS.DBMS_METADATA_INT", line 9135
ORA-06512: 在 "SYS.DBMS_METADATA", line 1882
ORA-06512: 在 "SYS.DBMS_METADATA", line 3707
ORA-06512: 在 "SYS.DBMS_METADATA", line 3689
ORA-06512: 在 line 1
EXP-00000: Export terminated unsuccessfully
这个问题怎么解决啊,盼望指导!
首先看 131100
通常 块在4000左右
这个 差别很明显 远大于 4000
所以 建议 增大 large pool
具体去搜索 ORA-04031 错误解决
一步一步的讲,谢谢了?
想直接解决该问题,有难度
因为 问题原因我已经分析出来
但解决,要求停数据库 修改其参数
不停,没法修改(确认可停应用,我再详细讲)考虑避免的方法:
首先将 导出操作在用户不忙的情况下进行
尝试是否可行如果不可行,
不要写 full=y了
首先 select * from cat;
查看用户下的表
然后 exp vesta/sht2010@ADAM file=d:\daochu.dmp tables=(表a,b,c,d)
....
这样来进行
exp vesta/sht2010@ADAM file=d:\daochu.dmp tables=(表a,b,c,d) buffer=64000 commit=y
exp vesta/sht2010@ADAM file= d:\daochu.dmp tables=(TBFRONTCHANNEL,TBFRONTCHANNEL,TBFRONTCOMMPORT,TBFRONTCOMMPORT,TBFRONTCOMMPORT,TBFRONTPROTOCOL,TBPLATEACTEVENT,TBPLATEALARMEVENT,TBPLATEBIZCODE,TBPLATEBREAKER,TBPLATEBREAKEROPCTRL,TBPLATEBRKALWAYS,TBPLATEBRKINOUT,TBPLATEBRKTYPE,TBPLATECOMPUTE,TBPLATECOMPUTEOPCTRL,TBPLATECONFGFILE,TBPLATEDUTYAREA,TBPLATEEVENTCFG,TBPLATEEVTTYPE,TBPLATEFINALSTATE,TBPLATEFORMULA,TBPLATEGRAPH,TBPLATEGRAPHTYPE,TBPLATEHISSAMPSTATS,TBPLATEICON,TBPLATEMENU,TBPLATEMODELICON,TBPLATEMONHISSTATS,TBPLATEMONSTATS,TBPLATENETALARM,TBPLATENETCFG,TBPLATENODEINFO,TBPLATENODEOPCTRL,TBPLATENODETYPE,TBPLATEOPEVENT,TBPLATEOVERJUDGE,TBPLATEPDRSET,TBPLATEPOWERCAPACITY,TBPLATEPROCINFO,TBPLATEPUBICONTYPE,TBPLATERECOVEREVENT,TBPLATEROLE,TBPLATESAMPSTATS,TBPLATESERVERCFG,TBPLATESMSHIS,TBPLATESMSQUEUE,TBPLATESMSTYPE,TBPLATESMSUSER,TBPLATESQLPROC,TBPLATESYSINFO,TBPLATETABATTRIBUTE,TBPLATETABLIST,TBPLATEUSER,TBPLATEVOLTLEVEL,TBPLATEYC,TBPLATEYCOPCTRL,TBPLATEYCOVER,TBPLATEYCTYPE,TBPLATEYEARHISSTATS,TBPLATEYEARSTATS,TBPLATEYM,TBWPANEST,TBWPBECBULBST,TBWPBLSTBL,TBWPBRKOPMOD,TBWPCLST,TBWPCNVOPMOD,TBWPDEHUMST,TBWPFTRST,TBWPGNCLST,TBWPGNOPMOD,TBWPHTEXST,TBWPHTST,TBWPICEST,TBWPINLOFFFLTST,TBWPLIFTST,TBWPLUST,TBWPMTPRESST,TBWPOILLEVST,TBWPPHYHEALTH,TBWPPTCTLST,TBWPROTST,TBWPTRFCLST,TBWPTURST,TBWPWCNVT,TBWPWCNVTOPCTRL,TBWPWDHTST,TBWPWGEN,TBWPWGENOPCTRL,TBWPWINDPICON,TBWPWNACELLE,TBWPWNACOPCTRL,TBWPWPLANT,TBWPWROT,TBWPWROTOPCTRL,TBWPWT,TBWPWTOPCTRL,TBWPWTOWER,TBWPWTOWEROPCTRL,TBWPWTRANSMISSION,TBWPWTRANSOPCTRL,TBWPWTRF,TBWPWTRFOPCTRL,TBWPWTTYPE,TBWPWYAW,TBWPWYAWOPCTRL,TBWPYWBRAKEST,TBWPYWST,
)
好像在界面上不能成功执行,这些字符不能一次输完!
在服务器本地连接方式
sqlplus name/pwd as sysdba
shutdown immediate
--测试就不讲究了
startup mount
show parameter large_pool_size
--看看大小
alter system set large_pool_size=64m scope=both;
--64m应该够了shutdown immediate startup
然后,够用了
数据库自行优化...
exp vesta/sht2010@ADAM file= d:\daochu.dmp tables=(TBFRONTCHANNEL,TBFRONTCHANNEL,TBFRONTCOMMPORT,TBFRONTCOMMPORT,TBFRONTCOMMPORT,TBFRONTPROTOCOL,TBPLATEACTEVENT,TBPLATEALARMEVENT,TBPLATEBIZCODE,TBPLATEBREAKER,TBPLATEBREAKEROPCTRL,TBPLATEBRKALWAYS,TBPLATEBRKINOUT,TBPLATEBRKTYPE,TBPLATECOMPUTE,TBPLATECOMPUTEOPCTRL,TBPLATECONFGFILE,TBPLATEDUTYAREA,TBPLATEEVENTCFG,TBPLATEEVTTYPE,TBPLATEFINALSTATE,TBPLATEFORMULA,TBPLATEGRAPH,TBPLATEGRAPHTYPE,TBPLATEHISSAMPSTATS,TBPLATEICON,TBPLATEMENU,TBPLATEMODELICON,TBPLATEMONHISSTATS,TBPLATEMONSTATS,TBPLATENETALARM,TBPLATENETCFG,TBPLATENODEINFO,TBPLATENODEOPCTRL,TBPLATENODETYPE,TBPLATEOPEVENT,TBPLATEOVERJUDGE,TBPLATEPDRSET,TBPLATEPOWERCAPACITY,TBPLATEPROCINFO,TBPLATEPUBICONTYPE,TBPLATERECOVEREVENT,TBPLATEROLE,TBPLATESAMPSTATS,TBPLATESERVERCFG,TBPLATESMSHIS,TBPLATESMSQUEUE,TBPLATESMSTYPE,TBPLATESMSUSER,TBPLATESQLPROC,TBPLATESYSINFO,TBPLATETABATTRIBUTE,TBPLATETABLIST,TBPLATEUSER,TBPLATEVOLTLEVEL,TBPLATEYC,TBPLATEYCOPCTRL,TBPLATEYCOVER,TBPLATEYCTYPE,TBPLATEYEARHISSTATS,TBPLATEYEARSTATS,TBPLATEYM,TBWPANEST,TBWPBECBULBST,TBWPBLSTBL,TBWPBRKOPMOD,TBWPCLST,TBWPCNVOPMOD,TBWPDEHUMST,TBWPFTRST,TBWPGNCLST,TBWPGNOPMOD,TBWPHTEXST,TBWPHTST,TBWPICEST,TBWPINLOFFFLTST,TBWPLIFTST,TBWPLUST,TBWPMTPRESST,TBWPOILLEVST,TBWPPHYHEALTH,TBWPPTCTLST,TBWPROTST,TBWPTRFCLST,TBWPTURST,TBWPWCNVT,TBWPWCNVTOPCTRL,TBWPWDHTST,TBWPWGEN,TBWPWGENOPCTRL,TBWPWINDPICON,TBWPWNACELLE,TBWPWNACOPCTRL,TBWPWPLANT,TBWPWROT,TBWPWROTOPCTRL,TBWPWT,TBWPWTOPCTRL,TBWPWTOWER,TBWPWTOWEROPCTRL,TBWPWTRANSMISSION,TBWPWTRANSOPCTRL,TBWPWTRF,TBWPWTRFOPCTRL,TBWPWTTYPE,TBWPWYAW,TBWPWYAWOPCTRL,TBWPYWBRAKEST,TBWPYWST)
命令执行成功!