Bypassing Oracle Client

[heuserj]

Have there been any thoughts since last spring about updating DOA to eliminate the need for the Oracle client and tnsnames? Core V3 has it and it seems to speed things up. I have only played with their trial version, but it looks like it would eliminate a lot of head aches when our WAN goes down or corporate networking messes things up. The Oracle Server is local but the DNS names server is across the country!

 

[Marco Kalter]

You can't bypass the Oracle Client (SQL*Net or Net8), but you can bypass the tnsnames. See this topic for an example.

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

 

[heuserj]

Does that mean that the Core product does require SQL Net? Both them and Merant (ODBC) claim that you do not need Oracle client software installed on the local pc and it talks directly to the Oracle server with TCP/IP. At our facility, we have problems with corporate network administrators changing tnsnames.ora constantly and when our WAN goes down we lose connections to our local Oracle servers since we cannot resolve server names since the DNS server is off site. That and the fact that Oracle networking is run off of the server tends to make initial logins very slow (45seconds to 2minutes). That is why I am interested in by-passing the client.
If I understand your first message correctly, even the Core Labs product needs the Oracle client but is just by passing the TNS names resolution part.

[This message has been edited by heuserj (edited 16 November 2001).]

 

[F.Hinlopen]

Core ODAC Net bypasses the Oracle client completely. Sounds like one more potential security threat to me, which Oracle should disallow.

------------------
Frans

 

[Joachim Rupik]

Yes, it is true - I don't know how they do it but it works!
You can connect to Oracle from PC without
Oracle Client installed!

Greetings,
Joachim Rupik