Go to the "Atrium Integration Engine" console. Then go to the "Configuration->Connections" link. You should be at the "Connections Console". Click on the "Oracle" tab. For each data exchange you have listed on the left you can configure the Oracle connection setting. You must do several things for it to work properly:
1. The SID/DB Alias must be configured in your TNSNames.ora file. 2. The path to the DB Directory must be correct. 3. Your Login/Password must be correct. At startup there is a aie001 startup script that contains the library paths in an environment variable called AIE_ORACLE_LIB_DIR make sure that is set. If missing reintsall AIE. Another thing to check (although I don't think this is it) is the eie.reg file in the conf directory of where you installed aie. In there should be an entry for your "Oracle" adapter. If it isn't there just reinstall AIE. That's about all I can think of. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of David Charters Sent: Tuesday, April 06, 2010 1:04 PM To: [email protected] Subject: AIE not connecting with rlohelper getting Error ORA-12514 ** I have a new installation of AIE running 7.1 Patch 8 running on a ARS 7.1 Patch 6. When I try to connect AIE to an Oracle 10G database I get the following error: *** ERROR *** ORA-12514: TNS:listener does not currently know of service requested in connect descriptor My DBAs tell me that my TNS:Listner is running fine. I can tnsping the databases from the Remedy server as well as SQL Plus into them so it seems like they should be fine. Does anyone have any suggestions on this? Regards, David Charters 317-331-8985 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
