English

Bug: SDE Repository setup fails during post installation with error -93

Description

The ArcSDE repository setup fails during post installation setup forArcSDE for Oracle8i or Oracle9i. The error returned in the wise_err.log is:

"SDE_Oracle Error: 1017
ORA-01017: Invalid username/password; logon denied

Error: Invalid DBA password (-93)
Error: Unable to connect"

Cause

The post installation setup for ArcSDE 8.3 for Oracle8i and Oracle9i provides the option to change the name of the SDE tablespace from the default 'SDE' to another tablespace name. However, when this option is used, the post installation process changes both the tablespace name and (incorrectly) the name of the 'SDE' user.

When the post installation setup connects to Oracle to create the ArcSDE repository, the repository setup fails because the user 'SDE' no longer exists.

Workaround

Below are available options that help avoid or work around this problem:

  1. Avoid the problem by not using the ArcSDE 8.3 post installation setup when creating a tablespace with a name other than the default 'SDE'. Instead, set up the SDE user environment manually.

    The Oracle user SDE owns the ArcSDE Repository, sometimes known as the ArcSDE system table schema. The SDE user and its tablespaces are usually created by the program sdesetupora9i, or sdesetupora8i, or by the ArcSDE installation process.

    Follow these steps to manually create the SDE user and tablespace:

    1. Connect to Oracle as the system user.

    2. Issue the following command to create the SDE user:

    create user sde
    identified by <password>
    default tablespace <default_tablespace_name>
    temporary tablespace <temp_tablespace_name>
    account unlock;

    3. Issue the following command to grant necessary permissions to the SDE user:

    grant
    select any table,
    create session,
    create table,
    create procedure,
    create sequence,
    create trigger,
    unlimited tablespace
    to SDE;

    The default and temporary tablespaces must already exist.

    The SDE user temporarily needs additional privileges when upgrading an existing ArcSDE instance. For a complete list of necessary privileges, please refer to the ArcSDE for Oracle Configuration and Tuning Guide.



    After creating the SDE user and granting permissions, use the post installation setup to set up the SDE Repository, and to create and start the ArcSDE service.
  2. Work around the error by deleting the incorrect user from the Oracle database, and creating a new one, naming it 'SDE', which references the non-default tablespace created. Be certain to grant the necessary permissions to the SDE user.

    The SDE user requires at least the following permissions:

    CREATE ANY PROCEDURE
    CREATE ANY SEQUENCE
    CREATE SESSION
    SELECT ANY TABLE
    CREATE TABLE
    SELECT ANY TABLE
    UNLIMITED TABLESPACE



    After creating the SDE user and granting permissions, use the post installation setup to set up the SDE Repository, and to create and start the ArcSDE service.