Doug Finner 8.Nov.11 08:50 AM a Web browser LC LSX LC LSX - All Releases Windows
VM 8.5.3 server on Windows Server 2008 R2
SQL Plus 10.2.0 and 8.1.7 are both installed.
I want to use the 8.1.7 system for doing lsxlc connections at the server level to Oracle. (we have this running on our 6.5.2 box).
I can log into Oracle dbs using SQL Plus.
DECs is running on the Dom server.
I've rebooted the server (full server reboot not just Dom restart).
If I search the server, I see any number of 'oci' folders.
When I try and use ndctest.exe to see if I can connect to oracle, I get the 'unable to load library oci' message.
If I run a scheduled agent to test for available connections, I see file, notes, odbce, oledb but no oracle or oracle8.
I can tnsping the oracle server I want to connect to.
What am I missing? What file(s) do I need, where do they live, and how do I convince Domino it can talk to Oracle.
I've searched this forum and not found anything definative so any tips would be helpful.
The oracle files are installed into
Oracle 10 was 'pushed' to the server rather than installed so I can't delete it using add/remove programs.
I have the 8.x installer but it won't allow me to de-install the 10.x client.
I can see the dcx files for noracle and noracle8 in my Domino server directory.
I have DECs in the add in and server tasks lines in my Note.ini file
I have oci.dll and ociw32.dll in two directories, one for the 10.2 client and again for the 8.1.7 client.
Found a universal installer for version 10 and uninstalled 10.
Deleted the c:\Oracle directory tree
Reinstalled into a new dir structure.
Confirmed PATH includes new path to the Oracle client bin dir.
Confirmed oci.dll and ociw32.dll are in the bin dir.
Confirmed SQL Plus can connect to my oracle server.
Still getting oci libray load error.
Startin' to get steamed...what the heck am I not doing right?
My server is 64 bit.
The installers are whatever IT provided me.
Any chance I'm running into a 32/64 bit issue?
Is there any way to tell from the setup.exe file I've been given if it's 32 or 64 bit or does it even matter?
Oh man...I bet that's it.
Off to find some 64 bit installers and try again.
FWIW, I'd still like to know if it's possible to tell what version of an installer you're running - anybody know?
This works on Windows 2008R2 64 bit. YMMV
Unistalled any full client using either the 'universal installer' if available or the unistall batch file in the uninstall directory (the setup.exe file is apparently no longer a universal installer/de-installer for version 11gR2).
The de-install should remove the Oracle client data from the PATH environmental variable. If you want to be sure, check and make sure it's gone and, if not, pull it from the PATH var.
Delete the directory tree that held the existing client.
I did a reboot just to make darn sure the client was flushed.
Copy the instant installer files(*) into a directory on the server.
Add this directory to the PATH variable
Add env vars for ORACLE_HOME and TNS_ADMIN that point to the same directory.
Copy in known good tnsnames.ora and sqlnet.ora files.
Reboot the server. VERY IMPORTANT...
(*) Instant installers are small packages of files that include things like oci.dll and provide all the required tools for Domino to connect to Oracle. Since I don't actually run the Oracle client on the server, I'm not sure if/how these work as a front end into Oracle or SQL Plus - talk to the Oracle folks for that...