Oracle 9i Client and Nameserver

[holger.sachs]

Hi,

we have a problem with Oracle 9i Client and DOA.

- We have an Oracle 8i Nameserver and an Oracle 9i Client.
- 2 TOracleSession Components in the Application.

The first connect (Session 1) to a Database is fine.
The second connect (Session2) is not possible: (Could not resolve Service Name)

If the Database - Name is in the local TNSNAmes.Ora file then it works.

The Oracle 9i Client Tools are working with more then one connection (Enterprise Manager ...)

So I think it is a problem with DOA and Oracle 9i Client and 8i Nameserver.
(With the 8i Client it works fine, so Oracle must have changed something in the 9i Client)

Can anyone confirm this ??

TIA
Holger

 

[holger.sachs]

It also doesn't work with the Oracle 9i Nameserver.
Seems to be really a DOA Problem

Holger

 

[holger.sachs]

Can anyone confirm that this is a DOA Bug??

DOA will not work with Oracle 9i and Oracle Nameserver???

 

[Marco Kalter]

I can't confirm this, but I did get a problem report from an other user with exactly the same symptoms. In this case the user was able to fix it by deleting the TNS_ADMIN key.

He was not using a name server though, but the symptoms are the same: the first connection works, a secondary connection with the exact same user and database failed with 'ORA-12154: TNS: could not resolve service name'.

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

 

[holger.sachs]

Hi Marco,

 

[Roald Andresen]

Hello.

This is still an issue with Oracle9iR2. I do not have any TNS_ADMIN entry, so that certainly does not solve the problem in the general case. The problem is also evident in PL/SQL developer 5.0.1.480. Workaround in PL/SQL dev is to set Tools->Preferences->Options->Session Mode to Single Session.

Please look into this.

------------------

 

[benthicsoftware]

A customer of mine had the same problem which can also be tested as failing using SQLPlus (connect, disconnect, try to connect again.) Oracle supposedly has a fix.
I hope this helps! Here's the metalink info:

1. Reconnecting from a Session Fails with TNS-12154
Type: Note Doc ID: 165521.1
Score: 18% Modified Date: 24-MAY-2002
Status: PUBLISHED Platform: Generic issue Product: Oracle ODBC Driver

fact: Oracle Net 9.0.1
fact: Oracle ODBC Driver 9.0.1
fact: Oracle Names Server (ONAMES)
fact: MS Windows NT

symptom: Reconnection from a session fails

symptom: TNS-12154 / ORA-12154: TNS:could not resolve service name

symptom: Network name resolution happens through ONAMES

cause: This is
Reconnecting from a session in 9i net client on
Windows fails with ORA-12154

fix:

Install the 9.0.1.2 rdbms patchset
or
Do not use ONAMES for name resolution (use tnsnames.ora file instead)

Mark Ford
Benthic Software

 

[Roald Andresen]

Hi again.

As a (not trivial) comment to Mr.Ford: The Oracle bug mentioned is an Oracle 9.0.x bug. I am running Oracle 9.2.x, and the TNS-12154 problem still exists in DOA and PL/SQL Dev.

Reconnecting in SQL*Plus et.al. works just fine in 9.2.x.

What could be the case is that DOA and PL/SQL Dev. just need a rebuild with the 9.2 client libraries.

Roald Andresen

 

[Marco Kalter]

It may well be that a bug that is fixed in 9.0.1.2 is still present in 9.2.0.x. These releases are patched in parallel. I can't find any information about this though.

Direct Oracle Access in not built with any specific client library. It dynamically loads the client library from the primary oracle home.

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