ORA-00600: [npibeg-begindisttxn: ncosno max value], [256] Via Dblink In 12.2
(Doc ID 2425900.1)
Last updated on JANUARY 08, 2024
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle 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 |