Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 471 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
PHP oci_connect ORA-12569 Checksum failure
Greetings,
I'm using Nginx as a reverse proxy to authenticate a service (Elasticsearch and Kibana). I'm using a module that can proxy the authentication to a PHP-script, allowing for custom authentication.
While connecting to a remote Oracle database, I encountered the following error:
[27-Oct-2015 09:14:41 Europe/Brussels] PHP Warning: oci_connect(): ORA-12569: TNS:packet checksum failure in \ontw\tools\ELK-new\nginx-1.9.5\auth\authentication.php on line 7.
I'm using php-cgi.exe as a bound service to my localhost on port 9100. This allows me to proxy the authentication requests to the required script.
What could be the cause of this error? I'm pretty sure my connection string is correct as a different hostname results in a "database not found"-error and a different port results in a "listener not found"-error.
Based on Google search results I'm inclined to believe that somewhere along the route between me and the remote database, one of the tcp-headers gets changed, resulting in the conflicting checksum.
However, connecting to the remote database through a JAVA web application with the same connection string goes smoothly.
This makes me wonder, what could be the cause of this abnormality and how can this be resolved?
Kind regards,
JaminVP
PS: Some more details:
- OS: Windows Server 2008 R2 Enterprise
- PHP Version 5.4.35
- Oracle Instant Client version 12.1.0.2.0 32-bit
- Path includes the Oracle Instant Client directory
- Oracle environment variables are not set as suggested by the PHP Oracle Underground Manual
UPDATE: I tried the PDO interface, but I get the same error. It's strange that I can access the database through a a webbapplication hosted by tomcat apache if the database is added as a resource. You'd expect the same to work in PHP, but nope.
.
Answers
-
Your Java app may be using the 'thin' driver which might account for the differences.
Did you try SQL*Plus? This uses OCI similar to PHP OCI8 and PDO_OCI.
-
go to the network admin file sql net ora file and update the line
TRACE_LEVEL_CLIENT = 16
which will rectify your problem.
as the memory issues with th
-
the error will be same with SQL * Plus too...
change TRACE_LEVEL_CLIENT = 16 can solve it in network admin config file sql net ora