Creating and configuring the Reviewer workspace in a geodatabase in Oracle

Creating an enterprise geodatabase

The server administrator needs to create a new geodatabase in Oracle that can be used as the Reviewer workspace.

Learn more about setting up a geodatabase in Oracle

Recommendations for a geodatabase 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

Oracle parameters

Configuring the geodatabase in ArcSDE

The DBMS used for the geodatabase should be configured before the Reviewer workspace is set up with the default geometry storage. For more information, see Geodatabase storage in relational databases or The SERVER_CONFIG system table.

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.

RemarqueRemarque :

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.

4/26/2014