ORA-02019 DURING REMOTE INSERT WITH A LOCAL SEQUENCE (Doc ID 130206.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2.0.4 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.

Symptoms

Problem Description


In your TNSNAMES.ORA you have:

LB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xxx.xx )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lb1)
)
)

you create the database link:


create database link LB1
connect to scott
identified by tiger
using 'lb1'


You create local sequence:

create sequence rl1
increment by 1
start with 1
order ;

you try:

SQL> insert into emp@lb1 (empno) values (rl1.nextval) ;
insert into emp@lb1 (empno) values (rl1.nextval)
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
ORA-02063: preceding line from LB1

The database link seems to be working fine.

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