English

Error: No execute privilege for required Oracle builtin package DBMS_PIPE

Error Message

When starting ArcSDE with the 'sdemon' command or connecting to the Oracle database through ArcSDE, the following error message is returned:

No execute privilege for required Oracle builtin package DBMS_PIPE

Cause

Insufficient privileges on the DBMS_PIPE package of stored procedures for Oracle that are necessary for managing various parts of ArcSDE functionality.

Solution or Workaround

  1. Connect to Oracle as the user 'sys'.
  2. Grant execute on dbms_pipe to public.