Bequeath Database Links failing with Loopback error ORA-09276
(Doc ID 2635046.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Net Services - Version 12.1.0.2 and laterInformation 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 |