Re: ORA-12645 Error Help...

CodeToad wrote:
> I am getting that error, ORA-12645, and reference to a parameter file error
> everytime I try to connect to a database at work via the Microsoft ODBC
> driver.
>
> So, I tried to do the connection via Win2k command shell, using
> sqlplus and got the exact same error. I am using copied TNSNAMES.ORA
> SQLNET.ORA files from a central file server (IFILE pointers), and I can
> tnsping
> the database servers, and other people on the network can connect using the
> same .ORA files and SQL*Net installation.
>
> Our DBA checked metalink, and the only reference it had to this error was if
> we were using some security parameters which we are not using.
>
> I even update the workstation to MDAC 2.7 and that made no difference,
> and I suspected it not since I got the error in sqlplus also.
>
> I cannot think of any other ideas to get this working, any suggestions?
>
> Desparate for some help.
>
>

[Quoted] Since you can tnsping, you have to assume your tnsnames.ora file is correct (unless you did tnsping from one oracle home and tried to [Quoted] connect from another oracle home). AFIK, tnsping does not read sqlnet.ora (just looks up the host/port in tnsnames.ora and sends an "are you there?" packet to the listener).

That pretty much narrows it down to something in your sqlnet.ora. What does your central sqlnet.ora file contain? Anything about authentication? You should be able to comment out the IFILE pointer to your central sqlnet.ora and try connecting (few parameters in this file are required). Received on Tue Jan 14 2003 - 18:18:22 CET