Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Where to configure ORACLE_HOME

Where to configure ORACLE_HOME

Where to configure ORACLE_HOME

I have installed Apache 1.3.14 and PHP 4.0.4 on my Win98 platform. And then I have installed and configured Personal Oracle 7. I have set the TNSNAME. But I got error when executing the following code.

$conn = Ora_Logon("user123@ORA7", "abcdefg");
print $conn;

And the error is:

Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in c:\program files\apache group\apache\htdocs\dante\oracle.php on line 6

The username, password and TNSNAME is correct since I have tested them by connecting Oracle thru SQL *Plus. The error message shown above states that PHP cannot recognise the TNSNAME. And I have searched for the PHP Manual. I found that I may need to add the following line

-with-oracle =ORACLE_HOME DIR

to a file. The problem is, I do not I should add this line to which file...

Could anyone give me a hand? I would appreciate any comment and advice.

Million Thanks.


RE: Where to configure ORACLE_HOME

i beleive the  --with-oracle=oracle_home dir switch needs to be invoked when you compile php from source. oracle_home dir will be the path to where your oracle directory is.

ie: it can't be added after you install php on your system.  you will need to obtain a source version of php for windows, and compile it with the appropriate switches.

Andres Jugnarain
Wireless Editor

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close