- 综合排序
- 最热优先
- 最新优先
- 来自专栏开源部署
ORA-31623、ORA-06512 错误解决实例
generated Oracle error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA -06512: at "SYS.DBMS_DATAPUMP", line 3263 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488 ORA-06512: at
1.9K30编辑于 2022-08-18 - 来自专栏从ORACLE起航，领略精彩的IT技术。
XTTS测试遇到问题：ORA-20001、ORA-06512
XTTS流程验证，遇到错误： ERROR at line 1: ORA-20001: TABLESPACE(S) IS READONLY OR, OFFLINE JUST CONVERT, COPY ORA * 3> ERROR at line 1: 4> ORA-20001: TABLESPACE(S) IS READONLY OR, 5> OFFLINE JUST CONVERT, COPY 6> ORA
64730编辑于 2023-06-10 - 来自专栏开源部署
数据泵导出时报ORA-31623、ORA-06512问题的解决
问题描述 同事反应Oracle数据库在使用数据泵导出时，导出报UDE-31623、ORA-31623、ORA-06512，大致如下： 告警日志信息大致如下： 处理过程 (1)第一步， 我以为是streams
3.4K10编辑于 2022-08-18 - 来自专栏全栈程序员必看
ora00279解决办法_oracle物化视图日志表
-06512:在”SYS.SNAPSHOT”, line 2809 ORA-06512:在”SYS.SNAPSHOT”, line 3025 ORA-06512:在”SYS.SNAPSHOT”, line ”.”MV_ABCD_K_PPLLCJ”的代码时出现以下错误 ORA-00920:无效的关系运算符 ORA-06512:在”SYS.SNAPSHOT”,line2809 ORA-06512:在”SYS.SNAPSHOT ”,line3025 ORA-06512:在”SYS.SNAPSHOT”,line2994 ORA-06512:在line1 SQL> BEGIN DBMS_MVIEW.REFRESH(‘MV_ABCD_K_PPLLCJ -06512:在”SYS.SNAPSHOT”, line 2809 ORA-06512:在”SYS.SNAPSHOT”, line 3025 ORA-06512:在”SYS.SNAPSHOT”, line ORA-06512:在”SYS.SNAPSHOT”,line3025 ORA-06512:在”SYS.SNAPSHOT”,line2994 ORA-06512:在line1 SQL> 查了mview的定义
1.5K30编辑于 2022-11-05 - 来自专栏开源部署
Oracle 12.2 报错：ORA-12012: error on auto execute of job “SYS＂.＂ORA$AT_OS_OPT_SY_7458”
ORA$AT_OS_OPT_SY_7458" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512 : at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL ", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line : at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL ", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line
62310编辑于 2022-08-17 - 来自专栏Oracle数据库技术
如何在Active Data Guard环境下创建Standby的AWR
-06512: at "SYS.DBMS_UMF_INTERNAL", line 132 ORA-06512: at "SYS.DBMS_UMF_INTERNAL", line 170 ORA-06512 : at "SYS.DBMS_UMF", line 822 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_UMF", line 794 ORA-06512: -06512: at "SYS.DBMS_SWRF_INTERNAL", line 5132 ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 5175 ORA- ", line 167 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 2182 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY ", line 2213 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 2197 ORA-06512: at line 1 SQL> alter
57820编辑于 2022-08-19 - 来自专栏数据库与编程
识别主机名和IP地址
UTL_INADDR.get_host_address('banana') from dual * ERROR at line 1: ORA-29257: host banana unknown ORA -06512: at "SYS.UTL_INADDR", line 19 ORA-06512: at "SYS.UTL_INADDR", line 40 ORA-06512: at line 1 SQL UTL_INADDR.get_host_name('1.1.1.1') FROM dual * ERROR at line 1: ORA-29257: host 1.1.1.1 unknown ORA -06512: at "SYS.UTL_INADDR", line 4 ORA-06512: at "SYS.UTL_INADDR", line 35 ORA-06512: at line 1 SQL
3.1K30编辑于 2022-12-01 - 来自专栏小麦苗的DB宝专栏
【故障处理】ORA-31600和ORA-04063错误
recursive SQL level 1 ORA-31600: invalid input value COMPATIBLE for parameter VERSION in function GET_DDL ORA -06512: at "SYS.DBMS_METADATA", line 5805 ORA-06512: at "SYS.DBMS_METADATA", line 8344 ORA-06512: at line 1 ORA-06512: at line 10 ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA- 04063: package body "SYS.DBMS_METADATA" has errors ORA-06512: at line 10 解决办法： SQL> shutdown immediate
1.1K20发布于 2019-09-30 - 来自专栏开源部署
Orace 12.2 ORA-12012: error on auto execute of job “SYS＂.＂ORA$AT_OS_OPT_SY_21”
ORA$AT_OS_OPT_SY_21" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL ", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line
78410编辑于 2022-08-17 - 来自专栏乐沙弥的世界
无法成功执行catalog.sql，ORA-04045 ORA-04064
LBACSYS.LBAC_EVENTS" ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA 06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA 06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA 06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA 06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA
1.6K30发布于 2018-08-13 - 来自专栏从ORACLE起航，领略精彩的IT技术。
Oracle SPA取报告阶段xml解析失败解决方案
ORA-19202: Error occurred in XML processing LPX-00216: invalid character 207 (0xCF) Error at line 26 ORA -06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 8211 ORA-06512: at "SYS.DBMS_SQLPA", line 515 ORA-06512: 我这里测试会有如下的报错： ERROR: ORA-51705: XML DOM error: 217 " LPX-00217: invalid character 0 (U+0000)" ORA-06512 : at "SYS.DBMS_SQLTUNE_INTERNAL", line 8211 ORA-06512: at "SYS.DBMS_SQLPA", line 515 ORA-06512: at line
1.3K20发布于 2019-05-24 - 来自专栏全栈程序员必看
SQL Tuning Advisor一个错误ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj]
ORA-00600: internal error code, arguments: [kesqsMakeBindValue:obj], [], [], [], [], [], [], [] ORA -06512: at “SYS.PRVT_ADVISOR”, line 1624 ORA-06512: at “SYS.DBMS_ADVISOR”, line 186 ORA-06512: at “SYS.DBMS_SQLTUNE”, line 1008 ORA-06512: at line 8 ################## 经MOS上确认，此为BUG。
50510编辑于 2022-07-06 - 来自专栏全栈程序员必看
Spring StoredProcedure调用ORACLE存储过程或函数
package body "SCHEMA_NAME.PACKAGE_NAME" ORA-06508: PL/SQL: 无法找到正在调用 : "SCHEMA_NAME.PACKAGE_NAME" 的程序单元 ORA -06512: 在 "SCHEMA_NAME.PACKAGE_NAME", line 432 ORA-06512: 在 "SCHEMA_NAME.PACKAGE_NAME", line 192 ORA- package body "SCHEMA_NAME.PACKAGE_NAME" ORA-06508: PL/SQL: 无法找到正在调用 : "SCHEMA_NAME.PACKAGE_NAME" 的程序单元 ORA -06512: 在 "SCHEMA_NAME.PACKAGE_NAME", line 432 ORA-06512: 在 "SCHEMA_NAME.PACKAGE_NAME", line 192 ORA-
1.7K30编辑于 2022-09-18 - 来自专栏公众号：Lucifer三思而后行
OGG add schematrandata报错 OGG-01790
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 1565 ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL ", line 1074 ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 722 ORA-06512: at line 1 SQL BEGIN sys.dbms_capture_adm.PREPARE_SCHEMA_INSTANTIATION
89420发布于 2021-08-17 - 来自专栏杨建荣的学习笔记
物化视图刷新结合ADG的尝试 (r8笔记第47天)
* ERROR at line 1: ORA-16000: database open for read-only access ORA -06512: at "SYS.DBMS_SNAPSHOT_UTL", line 364 ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 446 ORA-06512 * ERROR at line 1: ORA-16000: database open for read-only access ORA -06512: at "SYS.DBMS_SNAPSHOT_UTL", line 364 ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 446 ORA-06512
1.1K100发布于 2018-03-19 - 来自专栏小麦苗的DB宝专栏
【DB笔试面试701】在Oracle中，如何让普通用户可以杀掉自己用户的会话？
PRO_KILL_SESSION_LHR(1,125,1); END; * ERROR at line 1: ORA-20002: You do not own session '125,1,@1' ORA -06512: at "SYS.PRO_KILL_MYOWN_SESSION_LHR", line 36 ORA-06512: at line 1 由于系统进程的用户名为空，所以，避免了误杀系统进程。 PRO_KILL_SESSION_LHR(1,79,16453); END; * ERROR at line 1: ORA-20002: You do not own session '79,16453,@1' ORA -06512: at "SYS.PRO_KILL_MYOWN_SESSION_LHR", line 36 ORA-06512: at line 1 SYS@lhrdb21> conn lhr/lhr Connected -06512: at "SYS.PRO_KILL_MYOWN_SESSION_LHR", line 36 ORA-06512: at line 1 普通用户LHR也不能杀掉其它用户LHRTEST的会话
2K40发布于 2019-12-17 - 来自专栏开源部署
ORA-23421: job number XXXX is not a job in the job queue
DBMS_JOB.broken(275,true); END; * ERROR at line 1: ORA-23421: job number 275 is not a job in the job queue ORA -06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 529 ORA-06512: at "SYS.DBMS_JOB ", line 245 ORA-06512: at line 1 查看了资料说：不是job的owner的用户delete,remove，broken 一个job时，会报错:ORA-23421: job
1.3K10编辑于 2022-08-17 - 来自专栏乐沙弥的世界
ORA-39126 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]错误
数字或值错误 LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE" ORA -06512: 在 "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: 在 "SYS.KUPW$WORKER", line 8165 ----- PL/SQL Call -06512: 在 "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: 在 "SYS.KUPW$WORKER", line 8165 ----- PL/SQL Call tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE" ORA -06512: at "SYS.DBMS_SYS_ERROR" ORA-06512: at "SYS.KUPW$WORKER" Cause The statistics included
1.2K40发布于 2018-08-14 - 来自专栏乐沙弥的世界
ORA-31623： a job is not attached to this session via the specified handle
-06512: at "GOEX_ADMIN.FNO_SYS_DATAPUMP_PKG", line 738 ORA-06512: at line 15 3、分析异常 -->初步判断有可能是存在权限问题 -06512: at "GOEX_ADMIN.FNO_SYS_DATAPUMP_PKG", line 709 ORA-06512: at line 15 SQL> ho oerr ora 31623 -06512: at "GOEX_ADMIN.FNO_SYS_DATAPUMP_PKG", line 709 ORA-06512: at line 15 SQL> / DECLARE * ERROR ", line 709 ORA-06512: at line 15 SQL> / DECLARE * ERROR at line 1: ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at "GOEX_ADMIN.FNO_SYS_DATAPUMP_PKG", line 709 ORA
1.2K30发布于 2018-08-14 - 来自专栏公众号：Lucifer三思而后行
ORA-27478 Job 无法执行
报错如下： ORA-27478: job "is running" ORA-06512: at "SYS.DBMS_ISCHED", line 182 ORA-06512: at "SYS.DBMS_SCHEDULER ", line 615 ORA-06512: at line 1 二、问题排查 1、通过查询v$session视图确定hang住的会话相关信息； 2、通过dba_jobs_running和dba_scheduler_running_jobs
1.4K20发布于 2021-08-17
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号