Import reports errors (IMP-00017/PLS-00201/ORA-06550) while executing dbms_aqadm.create_aq_agent (Doc ID 1365319.1)

Last updated on NOVEMBER 28, 2016

In this Document
  Symptoms
  Cause
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Symptoms

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path

Warning: the objects were exported by JIRAYUTH, not by you

import done in TH8TISASCII character set and AL16UTF16 NCHAR character set
. importing USER1's objects into USER1  <== Executing PLSQL code as USER1

...


IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"DECLARE"
"AGENT_EXISTS exception; "
"PRAGMA EXCEPTION_INIT(AGENT_EXISTS, -24089);"
"BEGIN "
"dbms_aqadm.create_aq_agent(agent_name => 'USER1', enable_http => FALSE, enab"
"le_smtp => FALSE, enable_anyp => FALSE); "
"dbms_aqadm.enable_db_access(agent_name => 'USER1', db_username => 'USER1'); "
"EXCEPTION WHEN AGENT_EXISTS THEN NULL; END; "
""
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 6, column 1:
PLS-00201: identifier 'DBMS_AQADM' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
ORA-06550: line 7, column 1:
PLS-00201: identifier 'DBMS_AQADM' must be declared
ORA-06550: line 7, column 1:
PL/SQL: Statement ignored





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms