Setup for Oracle under Windows

[Anon]

Well, I am loosing my hair... I decided to give a try to PHP accessing my Oracle 8i server.

At first I had problems with "ORA-12154: TNS:could not resolve service name" error. Finally got the solution. Now it shows "ORA-12699: Native service internal error" and I have no clue what is the reason.

I run Windows 2000 machine with Oracle 8i client and PHP 4.0.4. SQL Plus sees server ok, My Delphi apps see server too. PHP is the only one giving me headache.

Any help?

[Anon]

Hi:

What is your connect string ($db)? Can you tnsping your Oracle server from your PC?

Try putting in the IP address for your host in the connect string instead of the name. I had that problem installing in a similar environment here today and that fixed that problem.

JBSpider

Pedja wrote:

Well, I am loosing my hair... I decided to give a try to PHP accessing my Oracle 8i server.

At first I had problems with "ORA-12154: TNS:could not resolve service name" error. Finally got the solution. Now it shows "ORA-12699: Native service internal error" and I have no clue what is the reason.

I run Windows 2000 machine with Oracle 8i client and PHP 4.0.4. SQL Plus sees server ok, My Delphi apps see server too. PHP is the only one giving me headache.

Any help?

[kinglouie]

Hi,

Look if TNSADMIN environment variable is set to a directory that contains the file tnsnames.ora
Your Oraclehost should stand in this file.

!!! Take care that this file doesn't contain any linebreaks (put the content in one line). !!!
WinOracle has problems with Windows linebreaks.
Best regards,

King Louie