My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 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 orclpdb

    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 = orclpdb.cn.oracle.com)))
    OK (0 msec)


SQL> CREATE DATABASE LINK "TO_DB122"
    CONNECT TO "JEROME" IDENTIFIED BY "******"
    USING 'orclpdb'; 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@TO_DB122;
    select count(1) from t@TO_DB122
      *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [npibeg-begindisttxn: ncosno max
    value], [256], [], [], [], [], [], [], [], [], [], []


Changes

 

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!


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