[ArcGIS] Workaround for creating a geodatabase under Oracle RAC (create Enterprise Geodatabase) failed

Source: Internet
Author: User
Tags dba

Reprint please specify the original address: http://www.cnblogs.com/litou/p/8028843.html

Environment: Oracle 11g 11.2.0.1.0 (Dual-node RAC cluster), ArcGIS Desktop 10.1.

Typically, you need to store ArcGIS spatial data in the case of an Oracle standalone instance, and for the first time use the Create Enterprise geodatabase tool in the ArcGIS Toolbox to generate the SDE user, tablespace, and the corresponding management table. This is not a problem in the case of Oracle standalone instances.

However, when using the tool to create SDE-related content in the case of an Oracle RAC cluster, a failure is created because the data file for the tablespace cannot be found. The same error is reported when opening the table Space page of the Oracle console.

At this point, the user logs in to the database using DBA authority, viewing the tablespace file for the database, since Oracle RAC uses ASM Storage Management, not the usual way of file storage, and the Create Enterprise geodatabase tool The SDE user's default tablespace sde_tbs data file is placed on the local path of Oracle home by default, not on ASM managed storage, causing tablespace data files to not be found.

Referring to the practice of solving the procedures error problem of creating the SDE times stored under the Oraclerac cluster, the error is resolved, there is no problem with using the SDE user to store and use spatial data, but other non-SDE database users create or import spatial data. The spatial data automatically exists under the SDE user and cannot be used to save spatial data with other database users.

Workaround:

1. If you have used the Create Enterprise geodatabase tool and have the error above, log in to the database with DBA authority and delete the SDE user and Sde_tbs table space.

A) Delete the SDE User: Drop user cascade;

b) Delete the Sde_tbs table space: Drop tablespace sde_tbs including contents;

2. Manually create the Sde_tbs table space through the Oracle console, where the Sde_tbs table space data file uses ASM storage Management.

3, again using the Create Enterprise geodatabase tool generated, then the SDE related things will be created successfully, create a log prompt has a warning, but does not affect the use.

Reprint please specify the original address: http://www.cnblogs.com/litou/p/8028843.html

[ArcGIS] Workaround for creating a geodatabase under Oracle RAC (create Enterprise Geodatabase) failed

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.