ArcSDE 10.2 for Oracle 12C Installation considerations

ArcSDE 10.2 for Oracle 12C Installation considerations

1. Environmental description

Oracle 12C is supported starting from ArcSDE10.2.1.

2, Installation precautions

The SDE space database can be installed in the PDB and created using the Create Enterprise geodatabase tool, with no difference between the installation method and Oracle 11g.

By default, users created, even if the Connect and resource roles are assigned, the database does not automatically give quota permissions, and a ORA-01950 error is prompted when creating features in catalog. This permission needs to be assigned manually.

Method 1:

Sql>?create?user?test?identified?by?test? DEFAULT? Tablespace? ESRI? Temporary? Tablespace? TEMP? Account? UNLOCK?? quota?unlimited?on?esri?container=current;??

sql>?grant?connect,resource?to?test;??

Method 2:

Sql>?create?user?test?identified?by?test? DEFAULT? Tablespace? ESRI? Temporary? Tablespace? TEMP? Account? UNLOCK??? container=current;??

sql>?grant?connect,resource?to?test;??

sql>?grant?unlimited?tablespace?to?test;

3. St_geometry Configuration

(1) Copy the Desktop10.2\databasesupport\oracle\windows64\st_shapelib.dll file to the bin file in the Oracle installation directory.

(2) Create user library for SDE user

Use the SDE user to connect to Oracle, and then execute the following statement:

Sql>?create?or?replace?library? St_shapelib?as? ' Oracle_home/bin/st_shapelib.dll '?;

sql>?select?file_spec?from?user_libraries;??

Note: If the ArcGIS Desktop is installed on the same machine as the database and the SDE is created using GP, the DLL file under the desktop is automatically registered to the user library.

(3) Modify the Oracle_home\hs\admin\extproc.ora file.

Setting the Set Extproc_dlls=only:c:\\mylibraries\\st_shapelib.dll

Or

SET Extproc=all

(4) test

4. Reference

http://blog.csdn.net/linghe301/article/details/19193517

http://blog.csdn.net/linghe301/article/details/19337351

ArcSDE 10.2 for Oracle 12C Installation considerations