English

Error: Underlying DBMS error (-51). Error installing GDB schema. Geodatabase schema object install not completed.

Error Message

When implementing ArcSDE for Oracle remote setup, users can connect to the database from the ArcSDE machine in SQLPlus:


Code:
C:>sqlplus sde/sde@gis1

When running sdesetup -o install -d oracle10g -u sde -p sde@gis1 to create repository tables, the following error messages are returned.

"Error: Underlying DBMS error (-51).
Error: Error installing GDB schema.
Geodatabase schema object install not completed."

Cause

This error is returned when following lines are put into the dbinit.


Code:
set SDEINSTANCE=xxxx
set LOCAL=xxxx


Note:
The dbinit.sde should not be modified until after the ArcSDE repository has been created.

Solution or Workaround

  1. Comment out the 'set SDEINSTANCE' and 'set LOCAL' lines in the dbinit.sde file.
  2. Create the ArcSDE repository.
  3. Un-comment the 'set SDEINSTANCE' and 'set LOCAL' lines in the dbinit.sde file.

Related Information