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

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