laptop and a wrench

漏洞

ORA-14451 error when creating an operating system authenticated user with the Create Database User geoprocessing tool.

上次发布: December 10, 2019 ArcGIS for Desktop
漏洞 ID 编号 BUG-000126055
已提交October 16, 2019
上次修改时间June 25, 2025
适用范围ArcGIS for Desktop
找到的版本10.7.1
操作系统Windows OS
操作系统版本10.0 64 Bit
状态Will Not Be Addressed

附加信息

We apologize that we were unable to address this issue within the current product support cycle.  If the issue continues to affect your work in a supported release, please contact Technical Support.

解决办法

  1. After running the tool in 10.7.1, connect as the OS-authenticated user and make an appropriate selection set using ArcMap or ArcGIS Pro, which should create the missing indexes and sequence and still allow the log files to be Global Temporary Tables.
  2. Use 10.7 or earlier to create the OS-authenticated user which uses traditional tables for the log files (optionally, convert them to Global Temporary Tables as per https://support.esri.com/en/Technical-Article/000009061).
  3. Create a database authenticated user and use Oracle tools to create the missing indexes and sequences based on the DDL from the database-authenticated user, for example:

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX1" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("LOGFILE_DATA_ID", "SDE_ROW_ID") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX2" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("SDE_ROW_ID") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX3" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("LOGFILE_DATA_ID", "UUID_VAL") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX4" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("UUID_VAL") ;

CREATE SEQUENCE "TESTUSER3"."SDE_LOGFILE_LID_GEN" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ; 

重现步骤

漏洞 ID: BUG-000126055

软件:

  • ArcGIS for Desktop

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项