I ran into a similar error on AIE. Our Oracle team patched to a version that no longer used tnsname.ora so I just had to remove the entire fqdn and used the short alias.
Instead of the SID being "db.tis.company.com" it is now just "db". The only way I could find the correct SID to use was to ping the name until I received a return then plugged that value into AIE. Of course I could not get the full story from the oracle team as to what happened when and why no one was informed but you know how those magical, mystical db gurus are. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, April 06, 2010 1:35 PM To: arslist@ARSLIST.ORG Subject: Re: AIE not connecting with rlohelper getting Error ORA-12514 ** 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:arsl...@arslist.org] On Behalf Of David Charters Sent: Tuesday, April 06, 2010 1:04 PM To: arslist@ARSLIST.ORG 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"_ _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"
