When you install the ArcSDE component of ArcGIS Server Enterprise for the Oracle database management system (DBMS), certain structured query language (SQL) scripts are installed in the SDEHOME > tools > oracle directory. They include the following:
arcsde_database_startup.sql—This script creates a startup trigger that runs whenever the Oracle instance is started. The trigger cleans up any orphaned session information that remains in the ArcSDE system tables following an instance failure. This trigger is optional because ArcSDE eventually cleans up orphaned session information during its normal operation. The startup trigger merely guarantees that orphaned session information is not present following the Oracle instance startup.
Run this script as the Oracle SYS user to create the startup trigger.
create_sde_oracle.sql—This script creates the SDE tablespace and ArcSDE administrator user (the SDE user) and grants the SDE user the permissions necessary to install or upgrade an ArcSDE geodatabase. When granting or revoking upgrade privileges to the SDE user, you need to remove the remark notations from the appropriate lines of the script.
NOTE: If you use the Post Installation wizard when installing on Windows, the wizard creates the SDE table space and user for you.
xml_lob_block_distribution.sql and xml_lob_cache_size.sql—These two scripts are used to help you configure your Oracle instance to store XML data. For details on these scripts, see Tuning an Oracle instance for XML data storage.
