ora-12154

[jcmoreno]

We get ORA-12154 error from time to time . I have read Oracle notes about the problems
but none of them match with my problem because it only happens from time to
time.
We are using 3.4.6.1 version.
Do you know why? Is there any reports about this?

Thank you.

 

[Marco Kalter]

What are your Oracle Server and Oracle Net versions? Are you using Oracle Names?

------------------
Marco Kalter
Allround Automations

 

[jcmoreno]

Hi marco,
My Oracle server version is 8.1.7.2 and the error happens in the only versions what we have, 8.1.6 and 8.1.7.
We don

 

[Marco Kalter]

Is this a multi-threaded application with multiple sessions?

If not, perhaps you can enable Oracle Net tracing by setting "trace_level_client = USER" in the sqlnet.ora configuration file? The trace file should allow us to determine what is happening.

------------------
Marco Kalter
Allround Automations

 

[jcmoreno]

Hi Marco,
Our application is Multi-Thread with multiple sessions. We use DLL

 

[Marco Kalter]

Can you download the latest Direct Oracle Access version, set TOracleSession.ThreadSafe to True for all your sessions, and try again?

------------------
Marco Kalter
Allround Automations

 

[kope]

We have the same problem. Our multithreded application works few hours befor the error ORA-12154 comes. Then the program can't make any more connection, but from PLSQL it works. Only restart helps. It is a service and somtimes only the server reboot helps. (The service responses not.) We set in all session multithreded=true. Oracle client: v9.0.1, DOA: v3.4.6.1. From many other people i heard the same problem, without solution.

 

[Marco Kalter]

Can you upgrade to the current 3.4.6.2 version, set TOracleSession.ThreadSafe to True for all your sessions, and try again? If this doesn't help, let me know and we will investigate this further.

------------------
Marco Kalter
Allround Automations

 

[kope]

Hi Marco,

from where can i download it? Please, send a link!

Multithreded=true --> ThreadSafe=true, it was a mistake.

Yesterday i heard/red two other solution:

1) we must use critical section with logon/logoff,

2) with Oracle 8.0.6 it works fine.

Remark to 1: you wrote in past, that you plan to implement this critical section in the new version. Is it true?

Peter

 

[kope]

Hi Marco,

the link i have, sorry.

Little remark: you wrote on the download site: Direct Oracle Access 3.4.6.1, but there is a version 3.4.6.4

Peter