ORA-21561: 生成 OID 失败

最新推荐文章于 2025-08-15 21:37:40 发布
原创 最新推荐文章于 2025-08-15 21:37:40 发布 · 1.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#oracle

本文描述了在使用Oracle RMAN进行数据库恢复操作时遇到的错误：ORA-21561 OID生成失败。问题的根源在于/etc/hosts文件中public IP的名称与hostname不一致，调整一致后，错误消失。

问题描述

[oracle@new-rac1 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on 星期二 12月 3 09:19:54 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-21561: 生成 OID 失败

在这里插入图片描述

问题解决

原因是修改了/etc/hosts文件的public IP的name后，和hostname不一致

一致后无报错

解决 ORA-21561: OID generation failed
ElonLink的博客
09-23 2万+
昨天更新了macOS Sierra 后，发现用 Navicat 连接 Oracle 报 ORA-21561: OID generation failed 错误解决方法 打开终端，查看 hostname hostname发现是 local 而不是 localhost 查看 hosts 文件 cd /etc open hosts内容为 ## # Host Database # # loc
ORA-00020: maximum number of processes (500) exceeded 故障一例
aaron8219's Oracle&Linux Technology Blog
04-29 4945
今天去客户那里做巡检，碰到一个奇怪的问题，在此做个记录 这套库是搭建在windows server 2008上的一套11g RAC，在alert日志中出现了大量下列信息： Wed Apr 29 10:32:48 2015 ORA-00020: maximum number of processes (500) exceeded  ORA-20 errors will not be
ORA-21561：OID generation failed
06-20
ORA-21561错误是Oracle数据库中的一种错误，通常在尝试生成唯一的对象标识符（OID）时发生。OID在数据库中用于唯一标识行、索引、触发器等对象。当系统无法为新创建的对象分配一个唯一的OID时，就会抛出这个错误。 ...
C:\Users\Administrator>impdp his/zr_his@orcl directory=DB_BAK dumpfile=HIS_20250901.dmp full=y Import: Release 12.2.0.1.0 - Production on 星期二 11月 25 20:55:03 2025 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. 连接到: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production ORA-31626: 作业不存在 ORA-31633: 无法创建主表 "HIS.SYS_IMPORT_FULL_05" ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: 在 "SYS.KUPV$FT", line 1161 ORA-00959: 表空间 'HIS' 不存在 ORA-06512: 在 "SYS.KUPV$FT", line 1054 ORA-06512: 在 "SYS.KUPV$FT", line 1042
最新发布
11-26
针对错误ORA-31626和ORA-31633，通常是因为主表创建失败，而主表创建失败的原因主要是上述的表空间问题或对象已存在。 总结解决方案： 1. 确保所有需要的表空间（尤其是备份文件中使用的表空间）在目标数据库中...
ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_ESCI_PK" ON "SYSMAN"."MGMT_ECM_SNAP_COMPONENT_INFO" ("SNAPSHOT_GUID", "COMPONENT_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."CON_UK" ON "SYSMAN"."MGMT_INV_CONTAINER" ("SNAPSHOT_GUID", "CONTAINER_LOCATION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."ENT_PK" ON "SYSMAN"."MGMT_INV_COMPONENT" ("NAME", "VERSION", "CONTAINER_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MDIV_PK" ON "SYSMAN"."MGMT_DELTA_ID_VALUES" ("DELTA_IDS_GUID", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."OSP_SNP_PK" ON "SYSMAN"."MGMT_HC_OS_PROPERTIES" ("SNAPSHOT_GUID", "TYPE", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."TABLE_SIZES_PRIMARY_KEY" ON "SYSMAN"."MGMT_TABLE_SIZES" ("COLLECTION_TIMESTAMP", "TABLE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."INDEX_SIZES_PRIMARY_KEY" ON "SYSMAN"."MGMT_INDEX_SIZES" ("COLLECTION_TIMESTAMP", "INDEX_NAME", "TABLE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_TARGET_PROPERTIES_PK" ON "SYSMAN"."MGMT_TARGET_PROPERTIES" ("TARGET_GUID", "PROPERTY_NAME", "PROPERTY_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_STRING_METRIC_HISTORY_PK" ON "SYSMAN"."MGMT_STRING_METRIC_HISTORY" ("TARGET_GUID", "METRIC_GUID", "KEY_VALUE", "COLLECTION_TIMESTAMP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 3 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_METRIC_ERRORS_PK" ON "SYSMAN"."MGMT_METRIC_ERRORS" ("TARGET_GUID", "METRIC_GUID", "COLL_NAME", "AGENT_GUID", "COLLECTION_TIMESTAMP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 4 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."PARAMETERS_PRIMARY_KEY" ON "SYSMAN"."MGMT_PARAMETERS" ("PARAMETER_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_ECM_SNAP_IDX" ON "SYSMAN"."MGMT_ECM_SNAPSHOT" ("SNAPSHOT_TYPE", "TARGET_NAME", "TARGET_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_ECM_SNAP_IDX2" ON "SYSMAN"."MGMT_ECM_SNAPSHOT" ("IS_CURRENT", "TARGET_TYPE", "SNAPSHOT_TYPE", "TARGET_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_SUMMARY_IDX" ON "SYSMAN"."MGMT_INV_SUMMARY" ("SNAPSHOT_GUID", "MAP_TARGET_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_INV_COM_CONT_IDX" ON "SYSMAN"."MGMT_INV_COMPONENT" ("CONTAINER_GUID", "NAME", "VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_COMPONENT_IDX_1" ON "SYSMAN"."MGMT_INV_COMPONENT" ("CONTAINER_GUID", "COMPONENT_GUID", "NAME", "VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_VERSIONED_PATCH_PIDX" ON "SYSMAN"."MGMT_INV_VERSIONED_PATCH" ("PATCHSET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_INV_DEP_ER_IDX" ON "SYSMAN"."MGMT_INV_DEPENDENCY_RULE" ("REFERENCER_GUID", "DEPENDEE_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DELTA_IDS_IDX" ON "SYSMAN"."MGMT_DELTA_IDS" ("COLLECTION_TYPE", "KEY_STRING") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_ROWGUID_IDX" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("ROW_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_SHOULD_BE_UK" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("DELTA_GUID", "ROW_GUID", "DELTA_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_ENTRY_TIME_IDX" ON "SYSMAN"."MGMT_DELTA_ENTRY" ("DELTA_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_DELTA_SNAP_IDX2" ON "SYSMAN"."MGMT_DELTA_SNAP" ("SNAPSHOT_TYPE", "TARGET_TYPE", "NEW_LEFT_TARGET_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 3 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_CPU_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_CPU_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_IOCARD_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_IOCARD_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_NIC_DETAILS_IDX" ON "SYSMAN"."MGMT_HC_NIC_DETAILS" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_OS_COMPONENTS_IDX1" ON "SYSMAN"."MGMT_HC_OS_COMPONENTS" ("SNAPSHOT_GUID", "TYPE", "NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_VENDOR_SW_SUMMARY_IDX" ON "SYSMAN"."MGMT_HC_VENDOR_SW_SUMMARY" ("SNAPSHOT_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_HC_VENDOR_SW_COMPS_IDX" ON "SYSMAN"."MGMT_HC_VENDOR_SW_COMPONENTS" ("VENDOR_SOFTWARE_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_SYSTEM_ERROR_LOG_01" ON "SYSMAN"."MGMT_SYSTEM_ERROR_LOG" ("MODULE_NAME", "LOG_LEVEL", "OCCUR_DATE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_EMD_PING_IDX_01" ON "SYSMAN"."MGMT_EMD_PING" ("STATUS", "MAX_INACTIVE_TIME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."EMDW_TRACE_DATA_IDX_01" ON "SYSMAN"."EMDW_TRACE_DATA" ("CONTEXT_TYPE_ID", "LOG_TIMESTAMP", "LOG_LEVEL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX02" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("SOURCE_TARGET_GUID", "ASSOC_TARGET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX03" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("ASSOC_TARGET_GUID", "SOURCE_TARGET_GUID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX01" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("SOURCE_TARGET_GUID", "IS_MEMBERSHIP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "SYSMAN"."MGMT_FLAT_TARGET_ASSOC_IDX04" ON "SYSMAN"."MGMT_FLAT_TARGET_ASSOC" ("ASSOC_TARGET_GUID", "IS_MEMBERSHIP") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_CONTROLFILES_ECM_PK" ON "SYSMAN"."MGMT_DB_CONTROLFILES_ECM" ("ECM_SNAPSHOT_ID", "FILE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_ROLLBACK_SEGS_ECM_PK" ON "SYSMAN"."MGMT_DB_ROLLBACK_SEGS_ECM" ("ECM_SNAPSHOT_ID", "ROLLNAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_SGA_ECM_PK" ON "SYSMAN"."MGMT_DB_SGA_ECM" ("ECM_SNAPSHOT_ID", "SGANAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_TABLESPACES_ECM_PK" ON "SYSMAN"."MGMT_DB_TABLESPACES_ECM" ("ECM_SNAPSHOT_ID", "TABLESPACE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_DATAFILES_ECM_PK" ON "SYSMAN"."MGMT_DB_DATAFILES_ECM" ("ECM_SNAPSHOT_ID", "TABLESPACE_NAME", "FILE_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_SQL_SUMMARY_PK" ON "SYSMAN"."MGMT_SQL_SUMMARY" ("TARGET_GUID", "SNAP_ID", "ADDRESS", "HASH_VALUE", "PLAN_HASH_VALUE", "PIECE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_SQL_PLAN_PK" ON "SYSMAN"."MGMT_SQL_PLAN" ("TARGET_GUID", "SNAP_ID", "ADDRESS", "HASH_VALUE", "PLAN_HASH_VALUE", "ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_RECUSERSETTINGS_ECM_PK" ON "SYSMAN"."MGMT_DB_RECUSERSETTINGS_ECM" ("ECM_SNAPSHOT_ID", "USER_NAME", "PROBLEM_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_RECSEGMENTSETTINGS_PK" ON "SYSMAN"."MGMT_DB_RECSEGMENTSETTINGS_ECM" ("ECM_SNAPSHOT_ID", "OBJ_TYPE", "OBJ_OWNER", "OBJ_NAME", "OBJ_PARTITION", "OBJ_LOB_COL", "SEGMENT_TYPE", "PROBLEM_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "SYSMAN"."MGMT_DB_INVOBJS_ECM_PK" ON "SYSMAN"."MGMT_DB_INVOBJS_ECM" ("ECM_SNAPSHOT_ID", "OBJECT_TYPE", "OBJECT_OWNER", "OBJECT_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE UNIQUE INDEX "APEX_030200"."WWV_FLOW_SW_RESULT_IDX3" ON "APEX_030200"."WWV_FLOW_SW_RESULTS" ("SECURITY_GROUP_ID", "ID", "STATUS") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "APEX_030200"."WWV_FLOW_SW_D_RESULT_IDX3" ON "APEX_030200"."WWV_FLOW_SW_DETAIL_RESULTS" ("SECURITY_GROUP_ID", "RESULT_ID", "FILE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 ORA-39083: Object type INDEX failed to create with error: ORA-02158: invalid CREATE INDEX option Failing sql is: CREATE INDEX "APEX_030200"."WWV_FLOW_SW_STMTS_IDX3" ON "APEX_030200"."WWV_FLOW_SW_STMTS" ("SECURITY_GROUP_ID", "FILE_ID", "ISRUNNABLE", "STMT_ID", "STMT_NUMBER") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 2 NOCOMPRESS NOLOGGING TABLESPACE "SYSAUX" PARALLEL 1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
08-16
我们正在解决Oracle数据库导入过程中出现的CREATE INDEX失败问题，错误代码为ORA-02158和ORA-01452。 根据用户提供的引用，我们注意到之前有关于导入导出错误的讨论，但当前问题与索引创建有关，因此需要具体分析。...
故障分析：ORA-00604 ORA-01555故障处理过程
提供数据库技术支持(系统优化，故障处理，安装升级，数据恢复等）
08-15 714
本文记录了Oracle数据库ORA-00604和ORA-01555故障的处理过程。案例基于Oracle 11g R2（11.2.0.3）在Red Hat Enterprise Linux AS 4环境下的恢复操作。通过修改参数文件调整数据文件位置后，使用重建控制文件的方法进行恢复。初始尝试时因日志文件校验错误（ORA-00367）导致失败，后将控制文件中的NORESETLOGS改为RESETLOGS成功解决问题。文章详细展示了参数文件配置、控制文件重建脚本及错误处理过程，为类似故障提供了通用分析思路。完整内
ORA-21561: OID generation failed
雅冰石的专栏
05-08 1829
一 问题描述 程序连不上oracle，报错： ORA-21561: OID generation failed 二 解决办法 ① 在程序服务器上修改/etc/hosts文件，添加oracle数据库的ip和主机名对应关系，示例： 192.168.3.1 host1 ② 重启程序 ...
解决ORA-21561: OID generation failed
qunwuhui的博客
01-19 483
linux的安装参照： https://blog.youkuaiyun.com/chengyuqiang/article/details/80406159 在linux上使用sqlplus连接oracle数据库 先输入：sqlplus test_username/password@//192.168.7.210:1521/garac 解决过程: 主机名不一致导致的；解决就是将hosts和netw...
解决 ORA-21561: OID generation failed错误
lovely_4的专栏
07-25 1607
用 Navicat 连接 Oracle报 ORA-21561: OID generation failed 错误 1、在终端上输入：hostname       ***.local 2、查看/etc/hosts文件：cat /etc/hosts       127.0.0.1 localhost 3、保证hostname与hosts文件中127.0.0.1对应的名
ERROR: ORA-21561: OID generation failed
Cherry
07-18 2112
从linux机器连接Oracle数据库时报ORA-21561OIDgenerationfailed错误。不是因为DNSName没有修改，而是因为机器的hostname没有写进/etc/hosts文件。将本机IP和机器名写入文件/etc/hosts。
【ORA】ora-21561 oid generation failed
debimeng
07-13 344
ora-21561 oid generation failed$ oerr ora 2156121561, 00000, "OID generation failed"// *Cause:  The handles passed in may not be valid// *Action: Check the validity of the env, svc handleshost文件里面的hos...
sqlldr时报错ORA-21561: OID generation failed
05-10 863
小疏忽大错误:当服务器(虚拟机)更换时.而这台机又有oracle客户端时. 那么在使用sqlldr的时候,可能会出现以下错误  sqlldr userid=username/password@db errors=999999  control=xxx 故障:sqlldr时报 ERROR: ORA-21561: OID generation failed 诊断:可能是
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值