2 Replies Latest reply on May 14, 2013 12:36 PM by 1008798

    Attempted Connection to Oracle (linux 64bit) via IIS issues

      hopefully one of you guys can help me with this problem.

      The environment:

      Client/webserver (Windows 2000) with Oracle instantclient 11.2 installed and IIS running
      Remote Server (OS = Oracle Linux 6, database = 11.2.0 64Bit)

      The problem:

      I can connect to the database server via sqlplus & tnsnames no problem so the instance is started and the database is definitely up.

      C:\>sqlplus system@o11gr2ts

      SQL*Plus: Release Production on Tue May 14 10:26:03 2013

      Copyright (c) 1982, 2011, Oracle. All rights reserved.

      Enter password:

      Connected to:
      Oracle Database 11g Release - 64bit Production


      The error:-
      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

      PHP connection script:

      $db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)))(CONNECT_DATA=(SID=o11gr2ts)))";
      $db_conn = oci_connect("user", "pass", $db);

      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!.