Installing Flex And Bison On Windows
I have experienced problems installing some packages which are available in Ubuntu and I wonder if I have the 'right' set of repositories. I am running Mint 15 32-bit. For instance, I need flex and bison which I think are standard packages for Linux and are available in Ubu ntu. When I try installing flex, I get the following message: '. Preliminary notes-- looks promising with lots of space for Heads and NERF. Installing on a Dell R630. The current status (2017-09-20) is that most things work, with.
Configuring PHP with OCI8 Review the previous section before configuring OCI8. To enable the OCI8 extension, configure PHP with the option -with-oci8. Before starting the web server, OCI8 typically requires several Oracle environment variables (see below) to locate libraries, point to configuration files, and set some basic properties such as the character set used by Oracle libraries. The variables must be set before any PHP process starts. The PHP binary must link with the same, or more recent, major version of Oracle libraries as it was configured with.
For example, if you build OCI8 with Oracle 11.2 libraries, then PHP should also be deployed and run with Oracle 11.2 libraries. PHP applications can connect to other versions of Oracle Database, since Oracle has client-server cross-version compatibility./configure -with-oci8=shared,$ORACLEHOME Make sure the web server user ( nobody, www) has access to the libraries, initialization files and tnsnames.ora (if used) under the $ORACLEHOME directory. With Oracle 10 gR2, you may need to run the $ORACLEHOME/install/changePerm.sh utility to give directory access. After configuration, follow the usual PHP building procedure, e.g. Make install.
The OCI8 shared extension oci8.so library will be created. It may need to be manually moved to the PHP extension directory, specified by the option in your php.ini file.
To complete installation of OCI8, edit php.ini and add the line. Installing OCI8 on Windows When using Oracle 10 gR2 client libraries on Windows, uncomment the php.ini line extension=phpoci8.dll. When using Oracle 11 gR2 or later client libraries, uncomment extension=phpoci811g.dll or extension=phpoci8.dll. With Oracle 12 c libraries use extension=phpoci812c.dll or extension=phpoci811g.dll or extension=phpoci8.dll. Only one of these DLLs may be enabled at a time. DLLs with higher versions may contain more functionality. Not all DLLs may be available for all versions of PHP.
Make sure is set to the directory containing the PHP extension DLLs. If using Instant Client, set the system PATH environment variable to the Oracle library directory. Setting the Oracle Environment Before using this extension, make sure that the Oracle environment variables are properly set for the web daemon user. If your web server is automatically started at boot time then make sure that the boot-time environment is also configured correctly. Note: Do not set Oracle environment variables using in a PHP script because Oracle libraries may be loaded and initialized before your script runs.
Variables set with may then cause conflicts, crashes, or unpredictable behavior. Some functions may work but others might give subtle errors. The variables should be set up before the web server is started.
On Red Hat Linux and variants, export variables at the end of /etc/sysconfig/httpd. Other systems with Apache 2 may use an envvars script in the Apache bin directory. A third option, the Apache SetEnv directive in httpd.conf, may work in some systems but is known to be insufficient in others. To check that environment variables are set correctly, use and check the Environment (not the Apache Environment) section contains the expected variables. The variables that might be needed are included in the following table.
Refer to the Oracle documentation for more information on all the available variables. Common Oracle Environment Variables Name Purpose ORACLEHOME Contains the directory of the full Oracle Database software. Do not set this when using Oracle Instant Client as it is unnecessary and may cause installation problems. ORACLESID Contains the name of the database on the local machine to be connected to. There is no need to set this if you using Oracle Instant Client, or always pass the connection parameter to. LDLIBRARYPATH Set this (or its platform equivalent, such as DYLDLIBRARYPATH, LIBPATH, or SHLIBPATH) to the location of the Oracle libraries, for example $ORACLEHOME/lib or /usr/lib/oracle/11.1/client/lib. This variable is not needed if the libraries are located by a different search mechanism, such as with ldconfig or with LDPRELOAD.
NLSLANG This is the primary variable for setting the character set and globalization information used by the Oracle libraries. ORASDTZ Sets the Oracle session timezone. TNSADMIN Contains the directory where the Oracle Net Services configuration files such as tnsnames.ora and sqlnet.ora are kept.
Not needed if the connection string uses the Easy Connect naming syntax such as localhost/XE. Not needed if the network configuration files are in one of the default locations such as $ORACLEHOME/network/admin or /etc.
Less frequently used Oracle environment variables include TWOTASK, ORATZFILE, and the various Oracle globalization settings like NLS. and the ORANLS. variables. Troubleshooting The most common problem with installing OCI8 is not having the Oracle environment correctly set. This typically appears as a problem using.
The error may be a PHP error such as Call to undefined function ociconnect, an Oracle error such as ORA-12705, or even an Apache crash. Check the Apache log files for startup errors and see the sections above to resolve this problem. While network errors like ORA-12154 or ORA-12514 indicate an Oracle network naming or configuration issue, the root cause may be because the PHP environment is incorrectly set up and Oracle libraries are unable to locate the tnsnames.ora configuration file.
On Windows, having multiple versions of Oracle on the one machine can easily cause library clashes unless care is taken to make sure PHP only uses the correct version of Oracle. A utility to examine what libraries are being looked for and loaded can help resolve missing or clashing library issues, particularly on Windows. Note: If the web server doesn't start or crashes at startup Check that Apache is linked with the pthread library. If you've followed the instructions and you can't even connect to the DB server, welcome to the Oracle hell. Most of the information you'll find is deprecated, incomplete, not for your platform, unnecessary or just plain wrong.
Typically, you won't need at all those complicate setups you'll read about and they'll probably make things harder. I suggest you get Systernal's 'Filemon' utility (for Windows, in Unix you may do with strace) and find out what exact config files and DLLs are being tried by php.exe (or httpd.exe if PHP runs as Apache module or.). Pretty often, the issue is that (e.g.) TNSNAMES.ORA does not have the correct line ending or Apache is looking for a DLL that does not even exist in your hard disc; learning that prevents you to waste time adding more and more useless environmental variables. Lost a day on trying to make work oci8 & pdooci extensions in php-fpm 5.3 on OpenSuSE 12.2 (64bit) with latest oracle instant client 11.2.0.3.0. Any of two works normally with generic instructions. But both extensions caused crash in ociconnect. Solution was simple add ORACLEHOME variable BEFORE running php-fpm.
/etc/profile.d/oracle.sh #!/bin/bash ORACLEHOME=/usr/lib/oracle/11.2/client64 LDLIBRARYPATH=$ORACLEHOME/lib NLSLANG=americanamerica.utf8 export ORACLEHOME LDLIBRARYPATH NLSLANG /etc/init.d/php-fpm. /etc/profile.d/oracle.sh # add this after rc.status (note: dot & space). After 'service php-fpm restart' works normally. Hope this helps. Great Solaris patch! Finally built.
Installing Flex And Bison On Windows
Here's some tips on connecting: Just made this on solaris8 32bit, actually works. 1) put everything in one directory 2) unsetenv ORACLEHOME 3) set the env vars LDLIBRARYPATH and SQLPATH and TNSADMIN(if you have it) to that directory. 4) use one of the other easy connection notations here docs/tech/sqlplus/10102/readmeic.htm These env vars worked when put at the top of apachectl script as well. To build you may have to fake it out with an ORACLEHOME var, but unset it later.
You may also have to fake out the build by putting header files where it is looking for them, e.g. In the rdbms/demo directory or some such other place. When running though, make sure you have only the files required in only one directory.
Oracle has not put up a link to the 32bit solaris sqlplus-you have to guess it-it's there though: instantclient-sqlplus-solaris32-10.1.0.3.zip.and don't forget to add '.world' on to the end of your SID. It's very common to have to specify DBNAME.WORLD to connect. I've had all kinds of errors with RedHat9(yuck), PHP 4.3.4RC1 and Oracle enterprice server 9.2.
For some time I thought that -with-oci8 wouldn't work with Oracle9 but that wasn't the case, the solution was many steps. Running Oracle 9i on a Solaris 9 (64 bit) platform with a Sun Server E250: Apache version 1.3.27 PHP version 4.3.1 I was first getting '.wrong ELF class: ELFCLASS64.' While doing a./configure with the -with-oci8 and -with-oracle parameters.
After some unsuccessfull searched I renamed the $ORACLEHOME/lib to $ORACLEHOME/lib.org and then renamed the $ORACLEHOME/lib32 to $ORACLEHOME/lib Thereafter it went passed this config, but now failed on not being able to find a libwtc9.so file which was in the $ORACLEHOME/lib directory (this message was displayed in the debug.log in the php source directory). After setting the Environment variable: LDLIBRARYPATH=$ORACLEHOME/lib I was able to compile without any errors and 'make' and 'make install' ran smoothly.
I only had to add the php type in the httpd.conf (in your apache conf directory eg. AddType application/x-httpd-php.php to get the php to work again. I had to then reverse the $ORACLEHOME/lib swop on top since php was now having problems with the 32 bit version of the library.so switched it back to 64 and my php script worked. Hope this helps some out there with similar problems.
Better to insert needed variables into apache(!) (or your webserver - respectively) start script. For example on UNIX systems /etc/init.d/apache would contain following lines before anything else: #!/bin/bash if -f oracle/.profile ; then source oracle/.profile fi The oracle/.profile has the appropiate settings to start an Oracle database so it is always up-to-date for PHP, too. (If settings are changed, don't forget to restart your webserver.) This way you just no need to worry what to include or define for PHP. Chemdraw software free download for windows 8 64 bit. I spent several hours tracking down error ORA 24374, which would result from only.SOME. of my select statements. This error would be caused if I made a query that would return any non-numerical value.
I am running an Apache 1.3.x webserver and PHP 4.2.1. The fix is to add entries in your httpd.conf file that would export your environment settings. I added these three lines and everything worked like a charm!
SetEnv ORACLEHOME /path/to/oracle/home SetEnv ORANLS33 /path/to/oracle/home/ocommon/nls/admin/data SetEnv NLSLANG AMERICAN Obviously, if your NLSLANG is different, you should set it to whatever your NLSLANG actually is. Ask your friendly DB admin for this information. Hope this helps someone who treads down the path that I just followed! For those of you who would like to install this extension on an RedHat/CentOS server.
It is actually pretty simple. Here is what you have to do: 1) Download the following RPM from Oracle: oracle-instantclient11.2-basiclite-11.2.0.2.0.x8664.rpm (Version number can be newer and check if you need the 64bit version or not). And then install it on the server. 2) yum install php-oci8 3) And as the last step you edit /etc/sysconfig/httpd and write the following line at the end: export LDLIBRARYPATH=/usr/lib/oracle/11.2/client64/lib/ (Attention: Path changes depending on the version you have downloaded from the Oracle website.).
Hi, I use Oracle Database 10g Express Edition Release 10.2.0.1.0 on a Linux workstation for dev purposes, along with Apache 2 and PHP5. So far I have used it on Kubuntu 8.04.
To get things working on a recently installed notebook with openSUSE 11.0 was a bit more complicated. So I hope someone will be able to benefit from our experiences. Here is our howto: # Use the package manager to install the packages php5-pear and php5-dev, if not installed yet.
# Download the instantclient111, zip files basic, sdk, sqlplus from the Oracle web site # Switch to user root here, since not all commands to some work sudo # Unzip these files to /opt/oracle/. # As a result you will see a dir instantclient111 appearing. Ln -s /opt/oracle/instantclient111/libclntsh.so.11.1 /opt/oracle/instantclient111/libclntsh.so ln -s /opt/oracle/instantclient111/libclntsh.so.11.1 /usr/lib/libclntsh.so ln -s /opt/oracle/instantclient111/libnnz11.so /usr/lib/libnnz11.so ldconfig # to make sure the system will be able to find the libs pecl install oci8 # interactively enter option 1, # then instantclient,/opt/oracle/instantclient111, # then enter # if needed, add extension=oci8.so to your php.ini /etc/init.d/apache2 reload # finished! Kind regards, Nico den Boer. Some notes to save somebody some grief: Installing the Oracle libraries and access module into an existing PHP5 installation on Debian etch without rebuilding php.
First grab the Linux instantclient from oracle.com - you'll also need the client SDK kit. Here I'm using instantclient 11.1 create a directory for these such as /home/oracle and unpack both of them to that directory. Go into the oracle directory (and into the instantclient111 directory) and create a symlink: $ ln -s libclntsh.so.11.1 libclntsh.so Grab the oci8 PECL package and unpack it somewhere (/oci).
Make sure you have the following packages (in addition to php5, php5-cli, apache2, etc). Php5-dev libaio1 php-pear Go to the oci8 directory (/oci/). You need to run 'pecl build' once to create the configure script. $pecl build But the problem is that pecl build will claim the files are installed and they are not. I wasted half a day on this one. Now go into the oci8-1.3.0 directory and build again by hand: $ cd oci8-1.3.0 $./configure -with-oci8=instantclient,/home/oracle/instantclient111 $ make Fix any errors/warnings before continuing Don't make install, which won't work.
$ cp./modules/oci8.so /usr/lib/php5/20060613+lfs Replace 20060613+lfs with whatever module directory has been setup for you in /usr/lib/php5 Create /etc/php5/conf.d/oci8.ini: - extension=oci8.so - Now run the php cmdline in verbose mode (php -v) and see if everything loaded. Fix it if it didn't. You may need some env variables setup in your /etc/init.d/apache2 file to make everything work and actually execute queries, but a phpinfo at this point should show your oci8 extension. See the php.net Oracle pages if you need help with the env variables.
Restart the web server $ /etc/init.d/apache2 restart. # Here's what it took to get it going for me on Red Hat on # x8632 w/ 10gr2 and php5.1.2 # I sincerely appreciate all of the other poster's notes. # It was a combination of a few # of them to get mine configured.
My note should reflect this: # install the instantclient basic and sdk like this # note: the original poster had you install into a lib subdirectory, # but when I tried this it couldn't find the sdk files. So I moved # the files in lib into the parent directory as # shown below. Estoreic (note from 15-May-2006 10:54) is right.
There seems to be a problem with the oci8-api-functions in php 4.4.x. There are error-messages like these in the errorlog: child pid 22297 exit signal Segmentation fault (11). glibc detected. double free or corruption (out): 0x9f4730. glibc detected. double free or corruption (!prev): 0x111d90. glibc detected.
corrupted double-linked list: 0x111d50. using php 4.4.x with oracle 10.x is impossible, until you do the following: 1. Download latest oci8-package from 2. Extract package somewhere 3. Go to php-4.4.x-source directory 4. Rm -rf ext/oci8 5. Cp extraceted oci8-1.2.x directory to/as ext/oci8 6.
Make distclean 7./buildconf -force 8./.configure (with the options you need) 9. Only for x8664: create pear-install.ini: - PHP memorylimit = 128M; Maximum amount of memory a script may consume (8MB) - 11. Edit Makefile: replace: PEARINSTALLFLAGS = -n -dshortopentag=0 -dsafemode=0 with: PEARINSTALLFLAGS = -cpear-install.ini -dshortopentag=0 -dsafemode=0 12. Make install have fun! Oracle connections will work now! To compile PHP 4.4.2 with OCI8 / Oracle 9i / AIX 5.2 (64-bit) / GCC PHP will automatically compile against the Oracle 64-bit libraries, which PHP being a 32-bit app, will cause 'make' to fail (though it will configure fine).
Here's how to avoid this: 1. Replace your PHP's ext/oci8 directory with the latest ext/oci8 directory downloadable from PECL - then remove the old directory entirely 2.
Rebuild configure by running:./buildconf -force.in PHP's root directory. This will rebuild the configure script. Using a tool like sed, in your configure file replace all instances of /path/to/oracle/lib with /path/to/oracle/lib32 - note, this may require GNU's autoconf, m4 and gnumake.
Export LDLIBRARYPATH=/path/to/oracle/lib32 5./configure -with-oci-8=/path/to/oracle (and any other options) Then, the usual make and make install. # here's what it took to get it going for me on rhel4 on x8664 w/ 10gr2 and php5.0.5 # hopefully this will save someone a little grief # first you must install the 10.2 full client in /app/oracle/product/10.2.0/db1 # follow all the instructions. This part will be a bitch. I spent ages trying work out why I was getting the following message when when using ocilogon on Windows 2000 using PHP 4 and 5: ORA-03106 Fatal two-task communication protocol error This problem is occurs when PHP cannot find ORACLE client environmental variables. The environmental variables can be set in several ways: 1. Within the root 'Directory' directive on Apache httpd.conf: SetEnv ORACLEBASE 'c:/oracle' SetEnv ORACLEHOME 'c:/oracle/ora81' SetEnv NLSLANG 'americanamerica.WE8DEC' SetEnv NLSCHARACTERSET 'WE8DEC' SetEnv NLSNCHARCHARACTERSET 'AL16UTF16' or 2. Within Windows: Go to the Control PanelSystemAdvancedEnvironmental Variables Then enter a name value/pair for each of the variables.
Using putenv statements in the PHP file prior to using ocilogon. This is not ideal because the statements are required evertime you wish to connect to Oracle. For those trying to use the Oracle Instant Client 10g in a win32 environment, heres a nice easy howto.
If you fully read the docs properly and understand what your reading you will be able to set it up, but if like me you want a quick easy fix, heres how I did it. Download and install the Oracle Instant Client to where ever (lets say c: ora client ) 2. Add your connect info, copy a previously created or provided tnsnames.ora file to the above directory. Change Path in the Environment Variables area to add this directory to the path. C: ora client;%SystemRoot%; 4. Open regedit and add a Key called ORACLE to HKEYLOCALMACHINE SOFTWARE 5. To the ORACLE key add a string value called TNSADMIN and assign it the directory above (ie.
C: ora client ) So you end up with KEYLOCALMACHINE SOFTWARE ORACLE TNSADMIN = c: ora client 6. Set php to use Oci8 extension and bobs your uncle 7. Option 7 was required as the oci8 extension or php wouldn't pick up the path change. Also my problem was how to use other programs like sqlplus without creating extra Environment Variables etc the TNSADMIN / tnsnames.ora part makes that simpler and allows you to call things the same as you would before. PS: This should apply to all the Instant Clients. I haven't tried it with any others but 10g though.
Hope this helps. I had trouble with norwegian characters using oracle 8.7.1 / php 4something and Apache 2. The only trouble was that '?'
Appeared instead of the norwegian characters. The solution to it all was to add this to the apachectl script: export NLSLANG='norwegiannorway.WE8ISO8859P1' export ORACLEBASE='/home/oracle' export ORANLS33='/home/oracle/ocommon/nls/admin/data' export ORACLETERM='ansi' export ORACLEHOME='/home/oracle' export LANG='noNO' I'm not sure if all of these are necessary, but I took no change, and it works now:). This took me a lot of time to solve, so I'm placing it here for my future reference, and for somebody who finds it useful. I don't know if it will work on your environment, this is what I have:. Windoze Advanced Server 2003.
IIS 6. Oracle 8.1.7 So how I configured the whole thing? First do whatever the standard PHP configuration says.
It won't work, anyway. But it will help. I installed PHP on C: PHP; Oracle Home is in E: Oracle ora817. Install Oracle 8 client. NOTE: You must use an Oracle 8 client, I used an Oracle 9 client and for some reason (dll binding I guess), it didn't work. Copy $ORACLEHOME/bin/cli.dll into $WINDOWS/System32.
Modify your SQLNET.ORA file and change the line: code SQLNET.AUTHENTICATIONSERVICES= (NTS) /code by this one: code SQLNET.AUTHENTICATIONSERVICES= (NONE) /code I dunno WTF NTS is, so if somebody sends me an eMail and explain, I'll be thankful. But if you don't do this you'll get an ORA-12560 error. And that's it for Oracle. Now, the IIS configuration:. Open your IIS Administrator and 'Web Service Extensions', add a new extension as follows:. Extension Name: PHP.
Required Files (ADD): C: php extensions phpoci8.dll; c: php sapi php4isapi.dll; c: WINDOWS system32 oci.dll. Check 'Set Extension Status as Allowed' Now you can use your ocli. functions, or better yet, use PEAR::DB functions which was my ultimate goal, with PEAR::DB you can forget about declaring ORACLEHOME, ORACLESID and all that kind of things. Couple of notes about startup/shutdown on linux: (redhat, maybe others) export LDPRELOAD=/usr/lib/libpthread.so Caused the start/stop script to fail to stop the httpd process.
The LDPRELOAD environment var caused the 'ps' command to core dump. I went bald figuring that out. Easiest fix I could think of was to move all the oracle/php varialble exports so they are only set in the start section of the httpd script. Never thought setting those vars globally in the script would cause problems. That's what I get for thinking.
Flex And Bison On Windows
One other note: Make sure the httpd process is shutdown before Oracle. Eg: /etc/rc.d/rc0.d/K15httpd /etc/rc.d/rc0.d/K25Oracle Lingering connections to oracle may cause shutdown to take forever. Gl & hf -Joe. PHP 5.0.3 + Solaris 9 (UltraSPARC) + Apache 2.0.51 + Oracle 10g Instant Client 10.1.0.3 Thanks to Jakob's patch I got this combination working.
Here are some things that helped me: 1. After getting this: ld: fatal: file /opt/oracle/instantclient/libclntsh.so: wrong ELF class: ELFCLASS64 I realized that PHP is a 32-bit application and that all 3rd-party libraries need to be 32-bit as well. You need to download the 32-bit version of Instant Client (basic + sdk), even if you are running the 64-bit Solaris OS. My patch command syntax was a little different: patch -p0 -i php5ociclient.patch config.m4 Thanks again to Jakob for porting the patch over to PHP 5. ReCompiling PHP4 to have oracle 8 support (oci8) on Debian Linux, using the Oracle 10g client libraries. Log in as root.
PACKAGES REQUIRED: php4-dev php4 (source files) php4 module (might not be required, but it's what i had installed at the time) OTHER PACKAGE REQUIREMENTS: Oracle Client Libraries (i used Oracle 10g Server, but you should be able to use, as has been previously said, any set of the oracle client libraries from 8i onwards). make sure this is installed before recompiling php4. ENVIRONMENT REQUIREMENTS: - export ORACLEHOME=where u installed the oracle client - export LDLIBRARYPATH=$LDLIBRARYPATH:$ORACLEHOME/lib - export LDPRELOAD=libclntsh.so.10.1 (the version number at the end will correspond to the oracle version you previously installed. In my case, 10g is 10.1). vi /etc/ld.so.conf and add $ORACLEHOME/lib to the list of paths.
Then. run ldconfig to reload those changes to the system. (p.s. Make sure it's the full path, and not using any environment variables. /u01/app/oracle/product/10gRDBMS is my ORACLEHOME). STEPS: - cd /usr/src/PHP4 Version in my case, PHP4 Version = php4-4.3.8, so path was /usr/src/php4-4.3.8 - vi debian/rules these are the default compilation rules for php4. Find section labeled COMMONCONFIG =.
and add -with-oci8 (it should be near the top of the file). debchange -i (allows you to edit the change log for the versions of php. Btw - you should be in the php4 source code directory).
Give the version id something obviously unique. Don't forget to add a comment. When all is in readyness, then you should be able to go debian/rules binary to build the debian packages required.
The deb packages are built into the /usr/src directory. And depending on the default compilation options u choose, there should be a few. Find the deb package that corresponds to the main php4 module (php44.3.8-4.mark.1i386.deb for me), and run dpkg -i package name to install it. vi /etc/init.d/apache and add exports for $ORACLEHOME, $LDPRELOAD and $LDLIBRARYPATH. don't forget to restart apache /etc/init.d/apache to reload the php4 module. IF YOU GET.: if you get an error saying something about apache cannot load libclntsh.so.10.1, file not found, check the environment variables, for both the user, and in /etc/init.d/apache and also check ld.so.conf to make sure the $ORACLEHOME/lib path is in there, and has been reloaded (with ldconfig).
Editing ld.so.conf was the part that finally got it working for me. As you should be able to tell, the steps are pretty much the same as for all oracle versions 8i onwards, and all linux OS's. But with a few debian specific paths and commands thrown in. Can't compile php with Oracle 9i and apache on Solaris8?
For those of you who are having Oracle errors: ORA-12154 or ORA-12505 or ORA-01005 do the folowing: The folowing precedures have been tested when connecting to a HP UX with Oracle 7.x using of couse the OCI8 as the client interface. Add those lines to the web server config files or set and export those ones before the web server starts. On Apache add these lines to httpd.conf: SetEnv ORACLEHOME /usr/local/oracle SetEnv ORACLESID SetEnv LDLIBRARYPATH /usr/local/oracle/lib SetEnv TNSADMIN /usr/local/oracle/tnsnames.ora SetEnv TWOTASK /usr/local/oracle/tnsnames.ora SetEnv NLSLANG EnglishAmerica.WE8ISO8859P1 SetEnv ORACLEBASE /usr/local When calling the OCILogon do this: $db = ' (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =serveripordnsname)(PORT = 1521)) (CONNECTDATA= (SID = sid)) )'; The previous definition is a copy of the service definition that is stored in the tnsnames.ora file. Next, call the OCILogon function using the folowing format: OCILogon('user/password','password', $db); To avoid ORA-01005 error, set the NLSLANG environment variable to EnglishAmerica.WE8ISO8859P1 ( some other values may work.but we have found that this one works for us ) To avoid ORA-12154 and ORA-12505, use the service definition as the OCILogon third parameter. I'd like to thanks to a friend of mine a.k.a Rosa for the user/password tip. Regards Miguel Carvalho.
Platform: Solaris 10, Apache 2.2, Oracle 11 client It is well known that the Oracle Instant Client 11g libraries conflict with the OpenLDAP ones. If features of the 11g client libraries are vital (e.g. Needing SQLNET timeouts to work and/or needing to get Oracle service names from directory servers via LDAP - both required in my organisation) then in order to achieve a working oci8 and OpenLDAP setup it is necessary to preload the instant client library in the Apache startup script - e.g.: # Setup for Oracle 11 instant client ORACLEHOME=/usr/local/oracle/instantclient112 export ORACLEHOME # LDLIBRARYPATH=/usr/local/oracle/instantclient112:$LDLIBRARYPATH export LDLIBRARYPATH # LDPRELOAD=/usr/local/oracle/instantclient112/libclntsh.so.11.1 export LDPRELOAD. Do not underestimate the importance of NLSLANG in your environment.
The Oracle error 'ORA-03106: fatal two-task communication protocol error' is indicative of not having NLSLANG set. In my case, I had a successfully processing INSERT statement followed by a failing SELECT statement that was resulting in that ORA-03106 error. The successful INSERT implied that all Oracle environment settings were fine. Ultimately we found that the NLSLANG was not set, and I have to assume that only the SELECT of data back from the database actually needed it, and therefore it was the SELECT statement that triggered the failure. Though, that is all speculation.
What you (probably want) are Flex 2.5.4 (some people are now 'maintaining' it and producing, but IMO they've done more to screw it up than fix any real shortcomings) and (likewise). (Edit 2017-11-17: Flex 2.5.4 is not available on Sourceforge any more, and the Flex github repository only goes back to 2.5.5. But you can apparently still get it from a Gnu ftp server at.) Since it'll inevitably be recommended, I'll warn against using Bison. Bison was originally written by Robert Corbett, the same guy who later wrote Byacc, and he openly states that at the time he didn't really know or understand what he was doing. Unfortunately, being young and foolish, he released it under the GPL and now the GPL fans push it as the answer to life's ills even though its own author basically says it should be thought of as essentially a beta test product - but by the convoluted reasoning of GPL fans, byacc's license doesn't have enough restrictions to qualify as 'free'!