LITTLEBLACKDOG.COM

Guide Dog Joined: 08 Nov 2003 Posts: 8419 Location: MN

So here is the deal... I need to get a linux box talking to oracle, for some reports I wrote.

I have this working through ODBC on my windows box, which of course came with a package for the oracle client. No such luck on the linux box.

So I read up on it at php.net, and it seems the oracle instant client is the way to go... I install it compile PHP get everything working... only to later discover that we use an oracle names server, and that the instant client won't work with that... So now I'm trying to load the oracle full client on to slackware linux (not my choice) and failing as of friday. Has any one ever gotten something like this working before? any advice?

Posted: Sun Sep 23, 2007 11:32 pm Post subject:

http://adodb.sourceforge.net/

Guide Dog Joined: 08 Nov 2003 Posts: 8419 Location: MN

Lycander wrote:
http://adodb.sourceforge.net/

when the bottom layer doesn't work, neither does the top layer.

adodb is just another layer ontop of OCI8... and OCI8 doesn't work... neither does adodb.

Also I've never seen the drive for people to put so many freakin layers on database access any how?

Posted: Mon Sep 24, 2007 12:05 pm Post subject:

anglachel wrote:
Also I've never seen the drive for people to put so many freakin layers on database access any how?

SQL is a brain-dead half-language. The further away I am from it, the better.

Guide Dog Joined: 08 Nov 2003 Posts: 8419 Location: MN

So I have an sqlnet.ora, that works on windows.

Code: Select all

#SQLNET.ORA Network Configuration File


#





NAMES.PREFERRED_SERVERS =


  (ADDRESS_LIST =


    (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX.XXXXX.XXXXX.com)(PORT = 1575))


    (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX.XXXXX.XXXXX.com)(PORT = 1575))


    (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX.XXXXX.XXXXX.com)(PORT = 1575))


  )





NAMES.DIRECTORY_PATH = (ONAMES,TNSNAMES)





NAMES.DEFAULT_DOMAIN = XXXXX.XXXXX.com


NAMES.INITIAL_RETRY_TIMEOUT = 5

it is using the 8.7.1 client. on linux I could only go down to 10.2 for the client, I put the same slqnet.ora in place on the linux box, and It ain't connecting...

the server is version 9.2

and on linux I get

Code: Select all

ERROR:


ORA-12154: TNS:could not resolve the connect identifier specified

when I use sqlplus to try to connect...

now the instant client I was using at first didn't support ONAMES (oracle names) I don't know about 10.2 express client that I'm using now, but I've not found anything saying it doesn't and for 400MB's it ought to support lots of things, I would hope...

Guide Dog Joined: 08 Nov 2003 Posts: 8419 Location: MN

Code: Select all

NAMES.DEFAULT_DOMAIN = XXXXX.XXXXX.com

That was the one... once I commented that out everything worked fine, but it works fine with that part on windows... f'd up.