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

I think it might be loading a wrong driver because of this:
[02/May/2008:14:36:07][936.1][-main-] Notice: nsoracle.c:918:Ns_DbDriverInit: driver `Oracle8' loaded.

Is any other version of Oracle installed in that server? If so, make sure you compile nsoracle with Oracle10 headers.

This thread might be helpful
http://www.openacs.com/forums/message-view?message_id=282605

Collapse
Posted by S Karlson on
We were able to find a workaround for the TNS lookup problem (see my reply downstream). However, with regard to your question-- no, there is no other version of Oracle installed on the server and we did compile with Oracle10 libraries.

From what I was able to find through research, the Oracle8 driver name is pretty much arbitrary and does not influence what database version the driver actually looks for. I did read that previous versions of AOLServer are picky about the driver name and the name of the nsoracle file itself, but that version 4.5 is not.