ORACLE PHP Could not connect, Can't make the Damn thing to work

Serialmouse

Please Help, couldn't get the damn thing to work.

Heres the Situation:
1) Oracle server is on another PC named V880-server
2) Oracle Client Web Server with PHP Apache on Linux OS (PC name is GroundZero, with SQL Plus (connects to server fine), accesses the server Oracle, V880-server's IP is already deifned in /etc/hosts file
3) Here are the TNSNAMES.ORA and LISTENER.ORA

TNSNAMES.ORA Network Configuration File: /opt/ora9/product/9.2/network/admin/tnsnames.ora

Generated by Oracle configuration tools.

V880-server =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.abc.de.f)(PORT = 1527))
)
(CONNECT_DATA = (SID = DEVT)(SERVER = DEDICATED))
)

LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora

Generated by Oracle configuration tools.

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.abc.de.f)(PORT = 1527)(QUEUESIZE=30))
)
)
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DEVT)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = DEVT)
)
)

CONNECT_TIMEOUT_LISTENER=0

4) Here's the Damn Code that don't work:

<?php
putenv('ORACLE_SID=DEVT');
putenv('ORACLE_HOME=/opt/ora9/product/9.2');
putenv('TNS_ADMIN=/opt/ora9/product/9.2/network/admin');
$dbuser="sms";
$dbpass="sql";
$dbname="V880-server";
$dbtable="PMIS.MEMBERS";

    echo getenv('ORACLE_SID');
    $db = ocilogon($dbuser,$dbpass,$dbname);
    if (!$db)
    {
            echo "No Connection";
    }
    $stmt = "SELECT * FROM ".$dbtable." WHERE LASTNAME='SINGUN'";
    $sql=ociparse($db,$stmt);
    ociexecute($sql,OCI_DEFAULT);
            echo "<html>";
            echo "<body>";
            echo "============================================================ <br>";
            while (ocifetch($sql))
            {
                    echo "============================================================ <br>";
                    ociresult($stmt,"LASTNAME");
                    echo ": End of Row<br>";
                    echo "============================================================ <br>";
            }
            echo "</body>";
            echo "</html>";

5) and Here's the errors

DEVT
Warning: ocilogon(): _oci_open_server: ORA-12541: TNS:no listener in /usr/local/apache/htdocs/richard2.php on line 16
No Connection
Warning: ociparse(): supplied argument is not a valid OCI8-Connection resource in /usr/local/apache/htdocs/richard2.php on
line 24
Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in /usr/local/apache/htdocs/richard2.php
on line 25

Warning: ocifetch(): supplied argument is not a valid OCI8-Statement resource in /usr/local/apache/htdocs/richard2.php on
line 29

6) Please Help me, I am really stuck and PULLING my HAIR Out!!!
:mad:

Feel Free to Email me your reply to serialmouse1@yahoo.com

Man, I'll worship you......
Thanks in Advance.......

Peace Out!!!

Serialmouse

TNSPING works on linux shell, TNSPING also works when invoked in PHP script using "system('tnsping v880-server');"

SQL PLUS also works fine and can connect and display contents of DB from server

I really could not still figure out what the hell is wrong, but I have seen web sites in PHP with Oracle as background, so PHP can work with oracle, its just a matter of configurations if not the code.

I am starting to doubt the LISTENER.ORA/Listener instance on Oracle server, TNSNAMES.ORA, PHP compilation, or my connection variables are out of f*cking whack!!!

LordShryku

1) You need to shorten you footer. Check the rules. They're sticky at the top of every forum.

2) Try changing your username to invoke the TNS protocol. Change it to username@TNS:tnsalias

Serialmouse

Footer is now gone

I think I tried that before, user@tnsname:TnasAlias,
still didn't work. am really lost by this. I Have seen PHP/ORacle Web Sites, and this is really frustrating that I can't figure out why I can't make mine work...

Serialmouse

We (our technical team, Sys Ads, and Sys Devs) were able to make PHP connect to oracle dbase server by:

1) copying all profiles of .bashrc for user ORACLE and placed them in user ROOT too.
2) some recoding also was done, I realized some errors on my code too, but connection was the main problem, and dirty hack done in number 1.
3) I also changed our TNSNAMES.ORA to only have in CONNECT_DATA value: SERVICE_NAME: DEVT

4) APACHE process is now running under user ORACLE, not a secure option, but was a dirty hack anyway that worked

Side Effects: NOBODY is no longer running APACHE, Apache sometimes experiences SEGMAENTATION FAULT now.

Any other Ideas Fellas???

Serialmouse

Hello Pips,

This is to help others like me out there.

We already tried making user NOBODY a member of OINSTALL group and DBA group, groups defined by user ORACLE, this didn't totally work, I experienced TNS: No Listener all the time. (which was a step closer because before was no TNS resolved, I also declared PUTENV() in script to emulate ORACLE environment variables at that moment)

And the Segmentation Fault is gone, we just upgraded to PHP 4.3.4, because a bug report on PHP 4.3.2 was found, it's got something to do with OCILOGON that causes it to SEGMENTATION FAULT, so people out there, this is SERIALMOUSE posting this solution for others to use and build upon on, because I really couldn't find solutions posted out there in dozens of sites I have found, including ORACLE sites. So here it is, no one else must go through what our tech team did.

I would like to thank our team for relentlessly finding solutions regarding Oracle PHP connections just to finish within a day before the deadline for presentation. The Sys Ads: Ewoks, Degz The Sys Devs SerialMouse, JohnnyDu (he found the Seg Fault reason, through almighty GOOGLE), and Godie, and the one that perfectly implemented our idea (Godie and me thought of the environment variables for Oracle user was needed, but user NOBODY was executing Apache, so we thought of making user ORACLE execute APACHE, even used PUTENV() to emulate to NOBODY the env vars of ORACLE but that was not enough cause not all environment variables were copied hehehehehe, even made NOBODY a member of ORACLE's groups at first) our IT Consultant who copied all Oracle .bashrc variables to user ROOT based on the previous theories we had.

We will still clean up this solution, along the way. I may post the updates on that some time later.

Peace Out!!

Serialmouse
Systems Developer
for
Wireless Applications Systems in the Philippines