Administering ArcSDE for Oracle
Administering ArcSDE for Oracle
Release 9.3
This topic contains links to administration concepts and instructions. Some of these are topics that apply to all database management systems; others are specific to ArcSDE for Oracle.
Setting up the geodatabase
Be sure to read the
ArcSDE for Oracle installation guide
for specific preinstallation, installation, and postinstallation setup steps for your operating system. The following are links to provide summaries and help with configuring the geodatabase.
Tuning tips to configure the DBMS to work with ArcSDE
Oracle initialization parameters
Minimize disk I/O contention in Oracle
Tuning memory in Oracle
User logins and permissions
The ArcSDE administrative account
User permissions
User permissions for geodatabases in Oracle
Installing ArcSDE for Oracle
Installation summary for the ArcSDE component for Oracle
Sample scripts installed with ArcSDE for Oracle
Managing multiple ArcSDE component installations on the same machine
Using multiple geodatabases in Oracle
Upgrade summary for ArcSDE geodatabases
Postinstallation setup
The following are topics about tuning the ArcSDE geodatabase repository creation:
The giomgr.defs file and the SERVER_CONFIG system table
ArcSDE initialization parameters
The dbinit.sde file
The dbtune file and the DBTUNE table
DBTUNE configuration keywords
Default configuration keywords specific to Oracle
Composite configuration keywords
Making configuration keywords available in ArcGIS
The DATA_DICTIONARY keyword
Oracle DATA_DICTIONARY keyword
The DEFAULTS keyword
Oracle DEFAULTS keyword
Log file configuration options
Log file keywords
LOGFILE_DEFAULTS for Oracle
DBTUNE configuration parameter name-configuration string pairs
Oracle DBTUNE configuration parameters
About Oracle Spatial DBTUNE storage parameters
These topics discuss other geodatabase setup configurations:
Configuring Oracle Net Services to use ST_Geometry SQL functions
Language support in the geodatabase
Language support for Oracle
XML columns in the geodatabase
Configuring an Oracle database to support XML columns
Tuning an Oracle instance for XML data storage
Making connections to the geodatabase
The following are general topics about connecting to a geodatabase:
An overview of ArcSDE geodatabase connections
Compatibility between clients and geodatabases
ArcSDE connection syntax
Creating spatial database connections
These topics are specific to making connections using an ArcSDE service:
Starting an ArcSDE service
Stopping an ArcSDE service
Pausing and resuming an ArcSDE service
Accessing an ArcSDE service through a firewall
Displaying ArcSDE service statistics and session information
Removing ArcSDE service user processes
Troubleshooting the ArcSDE service
These topics deal with direct connections to the geodatabase:
Properties of a direct connection to an ArcSDE geodatabase
Setting up a direct connection to Oracle
Troubleshooting direct connections to an ArcSDE geodatabase
Working with the geodatabase
These topics cover working with data in an ArcSDE geodatabase:
About data types
Oracle data types
About geometry storage types
Registering tables to be used by ArcGIS Desktop
Granting and revoking privileges on datasets
Oracle backups
Recovery models for Oracle
Using database views
Views in Oracle
Locators in the geodatabase
About compressing a geodatabase
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise
Updating geodatabase statistics in Oracle databases
It would also be helpful to understand how the geodatabase is structured and how data is stored in it. For this, consult the section "Geodatabase data storage and schema" found in this help. There is a specific book for Oracle in this section: "Inside a geodatabase in Oracle."
See Also
An overview of ArcSDE geodatabase administration
