Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> odd behavior on client installation

odd behavior on client installation

From: EdStevens <quetico_man_at_yahoo.com>
Date: Wed, 03 Oct 2007 11:58:40 -0700
Message-ID: <1191437920.321396.267110@57g2000hsv.googlegroups.com>


Platform: Oracle 10.2 client on XP-Pro

I had been running the 10.2 instant client for some time, then decided to go back to a full client and noticed things I'd never seen before. I've done this hundreds of times over the years, so thought I had my understanding down pat. Here was my course of action:

Next I ripped Oracle off the machine again ... de-installed, deleted c: \oracle, etc. Then installed and selected for admin client. This time the net config wizard at the end actually prompted me for info. Investigating the directories showed the same as before - with both an \instant_client and a normal \product directory. This time the instant_client directory had the tnsnames file created by the net config wizard, and again, the setting of tns_admin in the registry seems irrelevant. Setting up client tracing and looking at the resulting trace file shows this:

[03-OCT-2007 13:29:45:182] --- TRACE CONFIGURATION INFORMATION FOLLOWS

---
[03-OCT-2007 13:29:45:182] New trace stream is C:\oracle\product
\10.2.0\client_1\NETWORK\trace\clientsqlnet_520_1.trc
[03-OCT-2007 13:29:45:182] New trace level is 6
[03-OCT-2007 13:29:45:182] --- TRACE CONFIGURATION INFORMATION ENDS
---
[03-OCT-2007 13:29:45:182] --- PARAMETER SOURCE INFORMATION FOLLOWS
---
[03-OCT-2007 13:29:45:182] Attempted load of system pfile source C:
\Oracle\instantclient_10_2\sqlnet.ora
[03-OCT-2007 13:29:45:182] Parameter source loaded successfully

Notice that the very first place it looked for sqlnet.ora was in the
instant_client directory.  When did this become normal behavior, and
what mechanism is telling it to look there rather than in ORACLE_HOME/
network/admin?

As a next step, I deleted the entire instant_client directory and
dropped my sqlnet and tnsnames files into ORACLE_HOME\network\admin
and removed tns_admin from the registry.  Everything connected first
time,and the trace file showed that the first place it looked for
sqlnet.ora was in ORACLE_HOME\network\admin.

So ...
1)	why is this instant_client directory being created?  I've never
seen it before without explicitly installing instant client.
2)	Why does the net configuration wizard fail when installing the run-
time client?
3)	Where is the beginning of the chain of events that tells sqlnet
where to begin looking for the config files sqlnet.ora and
tnsnames.ora?  I always believed it was ORACLE_HOME/network/admin
unless over-ridden by tns_admin in the registry or environment, but
this does not appear to be the case here.

A reference back to the doc that explains would be fine.
Received on Wed Oct 03 2007 - 13:58:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US