This discussion is archived
2 Replies Latest reply: May 14, 2013 5:36 AM by 1008798 RSS

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

1008798 Newbie
Currently Being Moderated
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 11.2.0.3.0 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 11.2.0.1.0 - 64bit Production

SQL>

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 = 101.12.15.57)(PORT = 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!.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points