Re: Connect php to oracle

Daniel Morgan wrote:

>
> Have you verified the environment variables ORACLE_HOME and ORACLE_SID
> are set correctly? Is the listener running? Is the service name correct?
> Have you verified the entries in tnsnames.ora?
>

Yes, ORACLE_HOME and ORACLE_SID are set correctly. I connect to the database using sqlplus or Enterprise Manager without problems, so my tnsnames.ora must be correct.

These environment variables has been set:

ORACLE_HOME     C:\oracle\ora92
Path            C:\oracle\ora92\bin
ORACLE_SID      newdb2
TNS_ADMIN       C:\oracle\ora92\network\admin
TWO_TASK        C:\oracle\ora92\network\admin\tnsnames.ora

Here are the oracle processes running on my linux databaseserver. As you see the listener is running.

[tore_at_redhat tore]$ ps -ef |grep oracle

oracle    3292     1  0  2003 ?        00:00:21 ora_pmon_newdb2
oracle    3294     1  0  2003 ?        00:00:09 ora_dbw0_newdb2
oracle    3296     1  0  2003 ?        00:00:08 ora_lgwr_newdb2
oracle    3298     1  0  2003 ?        00:00:37 ora_ckpt_newdb2
oracle    3300     1  0  2003 ?        00:03:19 ora_smon_newdb2
oracle    3302     1  0  2003 ?        00:00:00 ora_reco_newdb2
oracle    3307     1  0  2003 ?        00:00:00
/database/app/oracle/product/9.2/bin/tnslsnr LISTENER -inherit
oracle    4401     1  0  2003 ?        00:00:00 oraclenewdb2 (LOCAL=NO)
tore      8206  8172  0 21:26 pts/14   00:00:00 grep oracle

-- 
regards,
Tore Skogly
(frustrated php&oracle user)