English

Problem: Geodatabase tables are not created during post-installation setup of a new ArcSDE for Oracle installation

Description

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.

Cause

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.

Solution or Workaround

There are a few of solutions to this problem:

  • One solution is to add the SDE user to the operating system's DBA group or to the Oracle install (oinstall) group.

    Note:
    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.

  • Another solution is to grant READ and EXECUTE permissions to the non-owner (SDE user) on certain Oracle library files; for example, all files related to the following:

    $ORACLE_HOME/lib/libclntsh.so.10.1

    These related files can be found by running the dependency check command:

    ldd -r libclntsh.so.10.1
  • A third solution is to install an Oracle client under the SDE user's account so it can access the necessary files. See the related article below for instructions.

Related Information