About Oracle Creating an ArcGIS Spatial database

There are two ways to create an Oracle-based geodatabase:

1. Know the Oracle Administrator password and create it directly with the ArcGIS client's Create Enterprise Geodatabase tool

2, do not know the password of SYS, but in Oracle created the SDE user and SDE table space, and gave the SDE the appropriate permissions, you can directly "Enable Enterprise Geodatabase"

Note: After the geodatabase is created, the following error appears:
The St_geometry shape library path may not be valid, or the EXTPROC is not configured correctly in the Oracle instance. [(Unable to determine current version of St_shapelib. Please check the St_geometry shape library path on the Oracle server, which are set to "C:\progra~2\arcgis\desktop10.3\data Basesupport\oracle\windows64\st_shapelib.dll ". Refer to the ArcGIS Help topics for more details.
)]

That is, St_geometry is not properly configured in Oracle, locate the path to St_shapelib.dll under the installation path of the ArcGIS client C:\progra~2\arcgis\desktop10.3\databasesupport \oracle\windows64\st_shapelib.dll, open the Oracle database installation directory to find the Lisener.ora file to open, you need to add the following line (program = extproc) st_ Shapelib.dll path, modified to: (envs= "extproc_dlls=only:c:\progra~2\arcgis\desktop10.3\databasesupport\oracle\windows64\ St_shapelib.dll ").

After the EXTPROC is configured, the Reference class library is also configured in the database, first querying the current user for the existence of the corresponding class library reference definition with the SQL statement

1. Create or Replace library st_shapelib
2. 2 as ' C:\progra~2\arcgis\desktop10.3\databasesupport\oracle\windows64\st_shapelib.dll ';
3. 3/

Then, use the SQL statement to query whether the current user has the corresponding class library reference definition or query the ST_SHAPELIB definition in the entire system

SELECT * from dba_libraries where library_name= ' st_shapelib ';

Restart the Oracle instance service, and then connect the SDE to the client.

As you can see, when the Geodatabase is created, the Geodatabase-enabled project on the right-hand side of the database connection disappears (off topic)

In particular, in user mode, you only need to create the geodatabase once, and then create the user name and password and table space for the corresponding business space library under Oracle, directly connected to the ArcGIS client

You can then create a new feature dataset under the connection

About Oracle Creating an ArcGIS Spatial database