Using Oracle Name Server

[MikeBrice]

When I configure my client machine to use an Oracle Name server, the first request from each PL/SQL Developer window/session suffers a delay of 40-60 seconds with the status Initializing being displayed. If I use SQLPlus with the same client configuration there is no delay. If I use a local tnsnames file then again there is no delay from PL/SQL Developer.

Does anybody have any idea what may be going on ?

I am using V5.1.3.704 of PL/SQL Developer with V9.2 Oracle client components.

[This message has been edited by MikeBrice (edited 18 September 2003).]

 

[Marco Kalter]

It seems that you are running into this issue .

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

 

[MikeBrice]

Thank you for the feedback. I have looked at this and one or two other threads that seem to have a common theme, issues/difficulties when using an Oracle Name Server and PL/SQL Developer. I am not sure that my situation is identical as I never receive an error. The product functions correctly but there is just a very long and annoying pause of about 60 seconds before I get my results. The long pause occurs for the first command/statement in a PL/SQL Developer window, but all subsequent acitivity in the same window generates an immediate response.

 

[Christo Kutrovsky]

Setting this parameter in sqlnet.ora makes this problem far less of an issue:

NAMES.INITIAL_RETRY_TIMEOUT=1

However I have traced the talking between the oracle client and the oracle names server, and it appears that the client simply doesn't get the 1st request. The second request is 100% identical to the first one.

I am unable to reproduce the problem with any other tool.

Marco sais that it is an Oracle bug not a pl/sql dev. bug. To me it looks very much like an pl/sql dev. bug.

Marco, could you explain why you think this is an oracle bug ?

 

[Marco Kalter]

The Oracle Names Server is completely transparent to the client application (in this case PL/SQL Developer). Therefore it's not really possible to introduce a bug in an application that would only surface on an Oracle Names configuration.

This problem seems to be a residue of a fix for Oracle bug #2048583, which caused a TNS-12154 when connecting a secondary session.

 

[Christo Kutrovsky]

Thanks for the reply Marco.

I read the bug report on metalink, and it sais fixed in 9.0.1.2. I know you said it is a "residue" but I am unable to reproduce with sqlplus.

I've tested with the latest 9.2.0.5 patch.

Unless I am able to reporduce with sqlplus there is no way for me to open a tar and request a fix. I was wondering if you had any other information on how I could reproduce this without "third party products" so that I can open a TAR with Oracle.

Thanks.

 

[najdnera]

Bug is also present over here, i have to wait > 30 sec Initializing... on each new window.
1. Please once more from where does the bug originate
2. Apart from the cause can we expect a fix for the PL SQL developer?
3. NAMES.INITIAL_RETRY_TIMEOUT=1 does not work for me. Singe Session works. But then I I have to open PL SQLdev 6 times (also works fine...)