Initial DB Connection Error in Data Affinity-Enabled 26ai RAC Environment with Oracle 26ai Client

[seanonepa]

From manual page: https://php.net/book.oci8

---

Connection Error During Initial DB Connection in Data Affinity Environment

Description

A connection error occurs only when Data Affinity is applied to a RAC database environment.

The issue appears only during the initial database connection attempt. After the first failure, subsequent connection attempts complete successfully.

Environment

1. Database

   • Oracle Database 26ai RAC, version 23.26.2
   • Data Affinity enabled
   • Data is distributed across RAC nodes using hash partitioning

2. Oracle Client

   • 23.26.1
   • 23.26.2

3. PHP & OCI8

   • 8.3.31 + 3.3.0
   • 8.1.31 + 3.2.1
   • 7.4.33 + 2.2.0

Symptoms

• The error occurs only on the initial DB connection attempt.
• Subsequent DB connection attempts work normally.
• The issue has been observed only in the RAC environment where Data Affinity is enabled.

Error Message

The following error is returned during the initial connection attempt:

[message] => ORA--0001: Message -1 not found; product=RDBMS; facility=ORA Occur

Error Verification

We captured trace logs at the time of logon and confirmed that ORA-00904 occurred internally during the initial connection.

Trace log:

=====================
PARSE ERROR #140494884403080:len=121 dep=0 uid=648 oct=3 lid=648 tim=1918934112377 err=904
SELECT C.CHUNK_ID, CHUNK_NAME, NVL(PRIORITY, 0), TABFAM_ID, GRP_ID, NVL(INST_ID, 0) FROM LOCAL_CHUNKS ORDER BY TABFAM_ID
WAIT #140494884403080: nam='SQL*Net break/reset to client' ela=2 driver id=1347374924 break?=1 p3=0 obj#=4294967295 tim=1918934112621
WAIT #140494884403080: nam='SQL*Net break/reset to client' ela=3776 driver id=1347374924 break?=0 p3=0 obj#=4294967295 tim=1918934116406
WAIT #140494884403080: nam='SQL*Net message from client' ela=4241 driver id=1347374924 #bytes=1 p3=0 obj#=4294967295 tim=1918934120691
CLOSE #140494884403080:c=7,e=7,dep=0,type=0,tim=1918934120779
CLOSE #140494884441352:c=16,e=16,dep=0,type=0,tim=1918934120806

[seanonepa]

.