My Oracle Support Banner

Bequeath Database Links failing with Loopback error ORA-09276 (Doc ID 2635046.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Database links creating via bequeath protocol failing with error ORA-09276

Ex:

dbname1 =

 (DESCRIPTION =

   (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 = oracleorcl)

   (ENVS='ORACLE_HOME=D:\app\jagdeeps\virtual\product\12.2.0\dbhome_1,ORACLE_SID=orcl')

   (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')

)

(CONNECT_DATA =

         (SERVICE_NAME = orcl)

   )

 )

 

SQL> CREATE DATABASE LINK dblink2 USING 'dbname1';

CREATE DATABASE LINK dblink2 USING 'dbname1'

*

ERROR at line 1:

ORA-09276: All bequeath database links must be loopback database links

 

Changes

 None

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
Changes
Cause
Solution
References


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