Dear all,
I am having trouble with the ListConnector method of LCSession
When I run it, it is not returning “oracle” or “pracle8” as one of the available/usable connections
We have Oracle installed on the client (10g)
DCTEST works fine when run
When we SQLPlus (logged on as the Notes user), we can connect to the data source OK
When I run a server agent that contains a Shell command to SQLPlus, everything works fine
There is an oracle.dcx file in the opt/ibm/notes/latest… directory
I am at a loss. How do I get script to see Oracle as a valid connector. When the script runs from my machine, Oracle is listed (I have the Oracle client installed)
Thanks in advance
(I have posted this here as well as the LEI forum - if anyone objects, I will remove it)
Mike
Subject: ODBC Conection Server or Client?
Are you connecting at the server level or client level?
Subject: Oracle LCConnector
Hi Don’t know if this wil help, but I recently was assigned to construct LEI activities to connect to Oracle and transfer data from Oracle to one of our Notes apps. The Oracle database was one that we hadn’t previously had a need to access. I was not able to successfully connect until one of our admins added the TSNAMES entry to the server TSNAMES set of files for that Oracle database. Here is a snapshot of the TSNAMES entry:
TNSNAMES.ORA Network Configuration File: c:\oracle\ora90\network\admin\tnsnames.ora
Generated by Oracle configuration tools.
ORAP020.sce.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = iocitsc15.sce.com)
(Port = 1526))
)
(CONNECT_DATA =
(SID = P020)
)
)
ORAP007.SCE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.SCE.COM) (PROTOCOL = TCP)(HOST = orap007.sce.com)(PORT = 1526))
)
(CONNECT_DATA =
(SID = p007)
(GLOBAL_NAME = ORAP007.SCE.COM)
)
)
Once that was put in place all went fine. I don’t remember if she had to bounce the server as well. Might be necessary.