hopefully one of you guys can help me with this problem.
Client/webserver (Windows 2000) with Oracle instantclient 11.2 installed and IIS running
Remote Server (OS = Oracle Linux 6, database = 11.2.0 64Bit)
I can connect to the database server via sqlplus & tnsnames no problem so the instance is started and the database is definitely up.
SQL*Plus: Release 184.108.40.206.0 Production on Tue May 14 10:26:03 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Release 220.127.116.11.0 - 64bit Production
However the client is also a webserver and when I try to connect to the DB via a webpage (php script) I get the following error:
Warning: oci_connect() [function.oci-connect]: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Process ID: 0 Session ID: 0
Unfortunately I'm stuck with using IIS instead of Apache as we have 3rd party software and related components which are IIS dependent.
Has anybody seen this one before? I know ora-01034 & ora27101 are commonly reported errors but I've yet to see them in this context. I've tested this against another Windows-based Oracle installation we have and the script connects fine. Any help gratefully received!.