Error: DB_instance_create_release_table() OCI execute Error(922)
When trying to install multiple geodatabases for ArcSDE 9.2 on Oracle the following error message was received in the sde_setup.log file.
SDE schema object install not completed.
ERROR installing/upgrading ArcSDE, Error = -51
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((GISDATA)) . . .
DB_instance_create_release_table() OCI execute Error(922)
Error creating VERSION table. (-51)
DBMS error code: 922
ORA-00922: missing or invalid option
The error message above has been found to be caused by the dbtune.sde file not being modified correctly for the corresponding user schema that will be used for multiple geodatabases. This is due to a missing of invalid parameter under the DATA_DICTIONARY keyword within the dbtune.sde configuration file. This could be something as simple as a misspelled parameter and can be solved by making changes to the dbtune.sde file before running the sdesetup command.
Solution or Workaround
In the 9.2 ArcGIS Desktop Help there is a section on requirments for creating multiple geodatabases within an Oracle database. Here it is stated that edits need to be made to the dbtune.sde file under the DATA_DICTIONARY keyword to reference the correct tablespace in which the repository will be populated.
The following steps show how to make modifications and re-attempt the sdesetup command to populate repository tables into desired user tablespace.
- Read through this help section in order to have a better understanding of the requirements for creating multiple geodatabases for Oracle.
Using multiple geodatabases within a DBMS
- Make modifications to the %SDEHOME%\etc\dbtune.sde file to reflect the correct tablespace in which the repository tables will be populated.
Another requirement is that a user and user tablespace have already been created within the database prior to modifying dbtune.sde file and attemtping to populate repository tables.
- Use the following ArcSDE command syntax to populate the repository into the tablespace you specified in the dbtune file in step 2.
sdesetup –o install –d ORACLE10G –i 5151:GISDATA –u GISDATA –p XXXX