Connecting to remote oracle database

admin

Administrator
Staff member
Dear All

I am trying to connect to an oracle 8.0 database using php 4 and apapche 1.3.17. I believe I have compiled everything ok (originally I was getting unknown function errors but that appears to have gone away). However I still can't connect. I'm using the following script:

<?php // oratest.php

putenv("ORACLE_HOME=/oracle/mowlem01/OraHome1");
putenv("ORACLE_SID=ORCL");

OCIInternalDebug(1);

if ($conn=OCILogon("edm@edm","edm")) {
echo "SUCCESS ! Connected to database\n";
} else {
echo "Failed :-( Could not connect to database\n";
}
OCILogOff($conn);
?>
<P>
<?php
phpinfo();
?>

and get the following error messages:

OCIDebug: _oci_open_server new conn=0 dname=

Warning: OCISessionBegin: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory in /usr/local/apache/htdocs/oratest.php on line 8
OCIDebug: _oci_open_session: FAILURE -> CLEANUP called
OCIDebug: START _oci_close_session: logging-off sess=0
OCIDebug: _oci_close_session: logging-off DEAD session
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called
OCIDebug: START _oci_conn_list_dtor: id=0
OCIDebug: END _oci_conn_list_dtor: id=0
Failed :-( Could not connect to database

I have two questions, I was hoping some one might answer.

Is there some where on the web where I can find a list of these oracle error messages?

Does any one know the cause of these messages and can you tell me what I'm doing wrong?


Many thanks

Paul
 
Back
Top