Follow on question - edit 3 Doug Finner 9.Nov.11 04:02 PM a Web browser LC LSX LC LSX - All ReleasesWindows
I am going to do two experiments today:
1. Full up 64 bit client install (pretty sure that'll work)
2. 'Instant client' install. The intent is to understand what files are needed for Notes to talk to Oracle and how to manually set things up.
I have tried #2 and the oci file is loading when I do ndctest but then I can't log into my Oracle db. I'm guessing it has to do with ndctest not 'seeing' tnsnames.ora and/or sqlnet.ora. I'm going to keep playing but if you know the magic formula, that'd be great.
Below is what I did.
----------------------
Created a directory: C:\OracleOCI\Version1020
Copied oci.dll into this dir
Set this dir as part of the Path statement.
Ran ndctest - oci loads (yeah!) but can't log into Oracle (sad face).
Copied known good tnsnames.ora and sqlnet.ora files into the directory above.
Same outcome on ndctest.
Rebooted box
Same outcome on ndctest.
How to I point ndctest to the tnsnames file?
<edit 1>
Wait...on a whim, I copied all of the files for the instant installer into the new directory and tried ndctest again. This time it tried connecting to my db but failed with a tns name resolution error so I'm rebooting to see what happens.
<edit 2>
Nope, close but no cigar. Here's the output from the test:
Oracle Connection Verification
Copyright 2005 IBM Corporation
--------------------------------------------
This utility will verify connectivity from this machine to the
specified Oracle Service. At the prompts, please enter a valid
Oracle username, password and service name.
loaded library oci
Username: UserName
Password: XXXXXXXX
Service Name: MyDb
Initializing Environment...success
Attaching to Service MyDb...
ORA-12154: TNS:could not resolve the connect identifier specified
Freeing Environment...success
Failed to verify Oracle connectivity, see message above
So still some kind of 'where's the db' issue and I'm back to how do I get ndctest to see the tnsnames file?
<edit 3>
The full up install of the 11g client does work but did require a couple of tweaks.
The 11g installer puts the sqlnet.ora and tnsnames.ora into the ..\Network\Admin\ directory.
Reboot now. This is important. If you run ndctest now, it'll work find the oci.dll but can't connect to the server and lsxlc code won't work at all.
I'd still love to know how to set this up so it works with the 'instant client' files only so if you know how to maket that work, please post.
Return to top
. . . . Follow on question - edit 3 (Doug Finner 9.Nov.11) 
Print this page
