Creating and configuring the 生产化制图 (Production Mapping) workspace in a geodatabase in Oracle (Production Mapping)
A geodatabase can be created in Oracle and configured to operate as an Esri Production Mapping workspace that can be used in an enterprise environment.
Creating an enterprise geodatabase
The server administrator needs to create a new geodatabase in Oracle that can be used as the 生产化制图 (Production Mapping) workspace.
For more information, see A quick tour of setting up a geodatabase in Oracle.
Recommendations for geodatabases in Oracle
It is recommended that the following parameter values be used when creating a geodatabase in Oracle.
Parameter name | Value |
|---|---|
Configure with Database Enterprise Manager | Enabled |
Automatic Memory Management | Enabled |
OPEN_CURSORS | 10000 |
SESSION_CACHED_CURSORS | 50–150 |
DEFERRED_SEGMENT_CREATION | False |
RESOURCE_LIMIT | True |
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 60 PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED | Set Default profile for ArcSDE and data owner users |
RECYCLEBIN | Off |
Configuring the geodatabase in ArcSDE
The DBMS used for the geodatabase should be configured before the 生产化制图 (Production Mapping) workspace is set up with the default geometry storage. See Geodatabase storage in relational databases or The SERVER_CONFIG system table for more information.
All default serverconfig settings should be used except TCPKEEPALIVE; make sure the TCPKEEPALIVE value is set to TRUE. This command should be used from the command prompt of a machine where the ArcSDE application server is installed.
注:Copying and pasting the example may cause syntax errors.
sdeconfig -o alter -v TCPKEEPALIVE=TRUE -i <service> -u sde -p <sde_password>
For more information, see the ArcSDE Administration Command Reference, which is included with the ArcSDE application server installation.