Tag Archives: ORA-31623

抽取AWR信息遭遇ORA-39147错误

Posted on 2012/10/16 by yangtingkun

今天在使用awrextr.sql脚本导出AWR数据时碰到这个错误。 数据库版本为10.2.0.5 RAC for HP_UX，错误信息为： USING the dump file prefix: awrdat_15222_15448 | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | The AWR EXTRACT dump file will be located | IN the following directory/file: | /orabak01/orabak | awrdat_15222_15448.dmp | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | | *** AWR EXTRACT Started … Continue reading →

Posted in ORACLE | Tagged , , , , , , , | Leave a comment

数据泵导出出现ORA-31623错误

Posted on 2012/02/07 by yangtingkun

客户数据库在调整SGA后，导出出现ORA-31623错误。 Oracle对于这个错误的描述为： ORA-31623: a job IS NOT attached TO this SESSION via the specified handle Cause: An attempt TO reference a job USING a handle which IS invalid OR no longer valid FOR the CURRENT SESSION. Action: SELECT a handle … Continue reading →

Posted in ORACLE | Tagged , , , | Leave a comment