- 3,733,849 Users
- 2,246,830 Discussions
- 7,856,894 Comments
- 380.9K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.1K Databases
- 220.4K General Database Discussions
- 22 Multilingual Engine
- 506 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 148 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 195 Java User Groups
- 179 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Setting up a development environment with a legacy codebase, my setup and resulting error.
I'm a junior developer and I'm a *bit* in over my head here. There are no other senior developers on this project, and I'm having some difficulty even getting the site to work on my machine without throwing errors. I know this topic has been covered before, that's how I found these forums, but I'm unsure if I'm even installing the correct things for this environment. I've tried some of the troubleshooting steps from the other posts, but they seem to mostly apply to other operating systems.
Warning: oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\xampp\htdocs\wrc\database\connect.php on line 11
What I know:
I'm supposed to use OCI 8 & Xampp 5.6 to get plugged into our codebase. I've gotten conflicting stories on what my codebase uses. The technical people who've provided me guidance are working on another codebase that's using PHP 7, and the people more familiar with my project aren't technical at all. Neither has provided the information I need to launch and develop this codebase and I've run out of threads I can pull on for now. I'm hoping someone here can help me find more breadcrumbs.
Here's what I've installed according to my notes:
Xampp with PHP 5.6.38
Technical team tells me to use:
Oracle Instant Client 12.2
Non technical manager tells me to use https://www.youtube.com/watch?v=kdWWnPC4xzs which uses instant client 11.2
My current install followed the instructions of my peers, except my PHP installation began throwing warnings that it was missing some DLL's.
I installed the DLL's from PECL :: Package :: oci8 :: 2.0.12 the x86 thread safe.
First I followed the non-technical manager's video, and that didn't work. Then I followed the technical team's instructions, but it turns out they're using PHP 7, and I had to install those additional files, and that appeared to work (OCI 8 appears in phpinfo())
But now I'm getting this error and I'm at my wit's end. Any help or directions would be appreciated.
The technical team's instructions follow.
download xampp (I used 5.6.38)
download oracle instant client (I used 12.2)
set system environment path variable to point at folder where you put instant client (c:\instantclient_12_2 for me)
can just start typing 'environment variable' into start window, it will show up
Environment Variables -> click 'Path' variable under System Variables and hit 'Edit...'
copy following files from instant client folder and put into xampp/apache/bin folder
oci.dll, oraociei12.dll and oraons.dll (done)
run xampp, edit php.ini (click apache config button)
uncomment this line: extension=php_oci8_12c.dll
uncomment this line: extension=pdo_pgsql
change this line 'memory_limit=128M' to 'memory_limit=512M'
and after this I installed the PECL files, which solved some warnings being thrown about not finding .dll files that were there.