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