Is This Content Helpful?
We're glad to know this article was helpful.
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.
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.
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.
sdesetup –o install –d ORACLE10G –i 5151:GISDATA –u GISDATA –p XXXX