My Oracle Support Banner

Database Link Creation through NON-ADMIN user in Autonomous Database Is Failing with 'PLS-00201: identifier 'DBMS_CLOUD_ADMIN' must be declared' (Doc ID 2592198.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Autonomous Data Warehouse - Version N/A to N/A
Information in this document applies to any platform.

Symptoms

Database Link Creation through NON-ADMIN user is failing and reporting below error :

Command Executed :

BEGIN
DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK(
db_link_name => 'STAGING2_PROD',
hostname => 'XXX.XXX.XX.XXX',
port => '1521',
service_name => 'ORCL.608140747.oraclecloud.internal',
ssl_server_cert_dn => 'CN=dbcs',
credential_name => 'DBCS_LINK_XXXX',
directory_name => 'DATA_PUMP_DIR');
END;

Error Reported :

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.