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