The biggest problem with oci8 is having these four variables set:
$ORACLE_SID=SOMESID
$ORACLE_HOME=/home/beckman/oracle
$ORACLE_BASE=/home/beckman/oracle
$TNS_ADMIN=/home/beckman/oracle/network/admin
If those aren't set, then things won't work.
Please confirm that those environment variables are set in Apache or
whatever web server you are using. If they aren't, oci8 won't work.
Beckman
On Fri, 16 Jul 2004, Adam Williams wrote:
> Hi, I'm trying to connect to an oracle 9.20 database using:
>
> $conn = OCILOGON("dah50","dah50","zed2.aleph0");
>
> but I get the error ORA-12154
>
> Searching on google says my listener.ora or tnsnames.ora may have
> problems, but I think mine are correct. Can someone take a look and see
> if they are ok? Also, I can connect to the database from the command
> line:
>
> ORACLE>>sqlplus dah50/dah50@xxxxxxxxxxx
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jul 16 11:58:49 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
>
> so I'm not really sure what is going on. below are my tnsnames.ora and
> listener.ora:
>
>
> tnsnames.ora
> ------------
>
> zed2.aleph0=(description=
> (address=
> (protocol=ipc)
> (key=aleph0))
> (address=
> (protocol=tcp)
> (host=zed2.mdah.state.ms.us)
> (port=1521))
> (connect_data=(service_name=aleph0)(server=DEDICATED)))
>
>
>
> listener.ora
> ------------
>
> listener=(description=
> (address_list=
> (address =
> (protocol = ipc)
> (key = extproc))
> (address=
> (protocol=ipc)
> (key=aleph0))
> (address=
> (protocol=tcp)
> (host=zed2.mdah.state.ms.us)
> (port=1521))
> )
> )
>
> sid_list_listener=(sid_list=
> (sid_desc=
> (global_name=aleph0)
> (sid_name=aleph0)
> (oracle_home=/exlibris/app/oracle/product/920)
> )
> (sid_desc =
> (sid_name = extproc)
> (oracle_home=/exlibris/app/oracle/product/920)
> (program = extproc)
> )
> )
> startup_wait_time_listener=0
> connect_timeout_listener=20
> trace_level_listener=off
>
>
>
>
> and when I start the listener I get no errors.
>
> ORACLE>>lsnrctl stop ; lsnrctl start
>
> LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
> The command completed successfully
>
> LSNRCTL for Linux: Version 9.2.0.3.0 - Production on 16-JUL-2004 12:07:11
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting /exlibris/app/oracle/product/920/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 9.2.0.3.0 - Production
> System parameter file is
> /exlibris/app/oracle/product/920/network/admin/listener.ora
> Log messages written to
> /exlibris/app/oracle/product/920/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
>
> Connecting to (DESCRIPTION=(address=(protocol=ipc)(key=extproc)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.2.0.3.0 -
> Production
> Start Date 16-JUL-2004 12:07:11
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /exlibris/app/oracle/product/920/network/admin/listener.ora
> Listener Log File
> /exlibris/app/oracle/product/920/network/log/listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
> Services Summary...
> Service "aleph0" has 1 instance(s).
> Instance "aleph0", status UNKNOWN, has 1 handler(s) for this service...
> Service "extproc" has 1 instance(s).
> Instance "extproc", status UNKNOWN, has 1 handler(s) for this service...
> The command completed successfully
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@xxxxxxxxxxxxx http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
