PHP: ora_logon - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ora_numcols ora_logoff

Last updated: Sat, 27 Jan 2007

view this page in

# ora_logon

(PHP 3, PHP 4, PHP 5 <= 5.1.0RC1)

ora_logon -- Open an Oracle connection

## Description

resource ora_logon ( string user, string password )

Establishes a connection between PHP and an Oracle database with the given username `user` and password `password`.

Connections can be made using SQL*Net by supplying the TNS name to `user` like this:

`<?php $conn = Ora_Logon("user@TNSNAME", "pass"); ?>`

If you have character data with non-ASCII characters, you should make sure that `NLS_LANG` is set in your environment. For server modules, you should set it in the server's environment before starting the server.

Returns a connection index on success, or `FALSE` on failure. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

add a note User Contributed Notes
ora_logon
premiere_fondation at yahoo dot fr
23-Dec-2003 08:59
`Hello,
I had the problem and the solution is this one :
Use OCILogon()
Instead of writing :
$db = ("INSTANCE_NAME");
Write the entire line corresponding to your oracle instance descriptor in tnsnames.ora file :
$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db.ip.address)(PORT = db.port)) ) (CONNECT_DATA = (SID = YOUR_DB_SID) ) )";
$con = OCILogOn("user", "password",$db);
This works perfectly.
Nicolas Corlieu.`
knitterb at blandsite dot org
11-Nov-2003 01:29
`You probably want to use the more modern OCILogon and other OCI functions for logging in to a database. Additional connection strings can also be found on the OCILogon page for documentation.`
php developer
05-Nov-2003 06:52
`I also goy the ORA-1245 error using ora_logon, but setting the ORACLE_HOME var so it showed up in both the Apache Environment and Environment sections in phpinfo didn't help the situation. The full error was "Warning: Oracle: Connection Failed: ORA-12545: Connect failed because target host or object does not exist in /path/to/script on line xx." Turns out I had the oracle client installed (which is required) and I had the environment correct (which is required), but I didn't have a local tnsnames.ora file setup, so the connection couldn't find the correct binaries to connect to oracle. Creating the tnsnames.ora file on the local server (db server is remote) and using the proper syntax of "ora_logon("user@tnsentry", "password");" worked for me. Note: ORACLE_HOME and ORACLE_SID were set in the script using putenv.`
Devon
11-Apr-2001 06:38
`In addition to above comments - I had a ORA-12545 error using ora_logon that I eventually found was simply a var/path problem - when you start up "apachectl start" make sure apache can find oracle!`
keithv at bzlninc dot com
14-Mar-2000 06:10
`In order to get this to work properly I needed to have the ORACLE_HOME variable set before starting the Apache web server. I put it in the /etc/profile file, but you can do it anyway you choose.`
add a note
ora_numcols ora_logoff

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST