My Oracle Support Banner

ORA-00600: [npibeg-begindisttxn: ncosno max value], [256] Via Dblink In 12.2 (Doc ID 2425900.1)

Last updated on MAY 12, 2021

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The following error was occurred when running a query via dblink:

ORA-00600: internal error code, arguments: [npibeg-begindisttxn: ncosno max value], [256], [], [], [], [], [], [], [], [], [], []      <<<< open_links is 256

 

Steps to reproduce the issue:
---------------------------------
SQL> host tnsping <service name>

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 20-JUL-2018 18:20:25
......
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <service name>)))
OK (0 msec)

SQL> CREATE DATABASE LINK "<dblink name>"
CONNECT TO "<target>" IDENTIFIED BY "******"
USING '<service name>'; 2 3

Database link created.

SQL> show parameter links
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_global_dblinks boolean FALSE
open_links integer 256
open_links_per_instance integer 4

SQL> select count(1) from t@<dblink name>;
select count(1) from t@<dblink name>
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [npibeg-begindisttxn: ncosno max
value], [256], [], [], [], [], [], [], [], [], [], []

 

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
References


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