Is This Content Helpful?
We're glad to know this article was helpful.
New ArcSDE installations on Linux or UNIX boxes with Oracle 10g Release 2 fail to create geodatabase (GDB) system tables when performing the post-installation setup.
Specifically, the first portion of the post-installation (the creation of the ArcSDE system tables) may complete. However, the post-installation fails when adding the Locator information and the GDB system tables.
Subsequent attempts to manually upgrade the partially created ArcSDE geodatabase repository using sdesetup -o upgrade also fail, and the upgrade.log file contains a long string of question marks.
Due to tightened Oracle security on access of the $ORACLE_HOME location beginning with Oracle 10g R2, the SDE user is no longer granted the READ and EXECUTE privileges by default to the $ORACLE_HOME location. Because of this, the SDE user is unable to access the Oracle libraries during the ArcSDE post-installation setup.
There are a few of solutions to this problem:
If adding the SDE user to the oinstall group as a secondary group does not solve the issue, adding the SDE user to the oinstall group as a primary group may be required.