Forum OpenACS Q&A: Re: TNS Problem on Oracle 10g / Solaris x86 / Aolserver 4.5

Collapse
5: Re: TNS Problem on Oracle 10g / Solaris x86 / Aolserver 4.5 (response to 1)
Posted by S Karlson on 05/05/08 07:28 PM
Update:

We have found a workaround, which is to dump the entire database connection string into the server parameter file like this:


ns_param Datasource "\(DESCRIPTION = \(ADDRESS_LIST = \(ADDRESS = \(PROTOCOL = TCP\)\(HOST = Dev02\)\(PORT = 1521\)\)\) \(CONNECT_DATA = \(SERVICE_NAME = GCDEV.Dev02\)\)\)"

I guess that bypasses TNS name lookup? It looks a little clunky but AOLServer is talking to Oracle now.

Collapse
7: Re: TNS Problem on Oracle 10g / Solaris x86 / Aolserver 4.5 (response to 5)
Posted by Mario Aguado on 05/05/08 09:07 PM
Sk,
you have reason, localhost is only when oracle and aolserver are in the same machine. sorry, but I didn't read it before.

If you can connect with sqlplus and add the lines in Datasource work but you aren't connecting with database with the name then I think that tnsnames.ora aren't reading correctly by aolserver.

are Oracle environment variables for web user write correctly?

Review TNS_ADMIN variable and check persmissions for the folder and file.