Oracle Adapter Connection test fails with error ORA-00904: "V"."BANNER_FULL": invalid identifier
Article ID: KB0071127
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | WebFOCUS 9.1.0 and higher |
Description
Symptoms
Receiving Error message:
ORA-00904: "V"."BANNER_FULL": invalid identifier
During Test Adapter Connection when configuring Oracle 18c, 19c, or 21c Adapter with Oracle 11g, 12c as a Target database
Receiving Error message:
ORA-00904: "V"."BANNER_FULL": invalid identifier
During Test Adapter Connection when configuring Oracle 18c, 19c, or 21c Adapter with Oracle 11g, 12c as a Target database
Issue/Introduction
Oracle Adapter Connection test fails with error ORA-00904: "V"."BANNER_FULL": invalid identifier
Environment
Windows, Linux
Resolution
Cause:
The "BANNER_FULL" column, used by the Oracle Adapter Test query, was introduced by Oracle from 18c releases. Prior Oracle releases were using the "BANNER" column.
The "BANNER_FULL" column, used by the Oracle Adapter Test query, was introduced by Oracle from 18c releases. Prior Oracle releases were using the "BANNER" column.
Additional Information
Refer the below Article for more information
Oracle Adapter Connection Test fails while configuring against Oracle 11g or 12c databases
Oracle 18c - Database Reference - 9.129 V$VERSION
https://docs.oracle.com/en/database/oracle/oracle-database/18
Oracle Adapter Connection Test fails while configuring against Oracle 11g or 12c databases
Oracle 18c - Database Reference - 9.129 V$VERSION
https://docs.oracle.com/en/database/oracle/oracle-database/18
Feedback
Yes
No
Powered by
