Thanks Carl, We managed to get it working from the "Connections Console" on the AIE Console, Test connection is successful.
@@: rlohelper -ax $SERVER$ -ar "$TCPPORT$" -al "$zTmpAdminLogin$" -ap "$zTmpEncrypPasswd$" -os "1" -ol "$Oracle-OraLogin-Value2$" -op "$zTmpDB2EncPassV$" -oa "$Oracle-OraDbAlias-Value2$" -VCON -VPC -oh $Oracle-OraDbDir-Value2$ But from the Data exchange console - Test connection fails Error: Set fields active link running a process failed Host Name is CCSMTAPPSD01. AIE Service wakeup port not set in EIE:BackupLoadFlag form (ARERR 1603) The following process is called. $PROCESS$ @@: aiexfer -x "$SERVER$" -n "$zTmpInternalInstNm$" -rpcport "$TCPPORT$" -l "$zTmpAdminLogin$" -p "$zTmpEncPwd$" -b "$Data Exchange Name$" -VCON Restared AIE New port number has been assigned by the AIE when restarted, Regards, Madhu On Tue, Jan 28, 2014 at 5:06 PM, Carl Wilson <carlbwil...@gmail.com> wrote: > Hi, > Yes if the DB is external then you need to provide the directory to the > client (compatible version) that you are using connect to the DB. > > E.g. C:\oracle10G\product\10.0.2\client ... > > The AIE Plugin will then use the client to connect to the DB. > > The AIE User Guide has a screenshot of using the client to connect. > > Kind Regards, > > Carl Wilson > > http://www.missingpiecessoftware.com/ > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Madhu Krishnappa > Sent: 27 January 2014 15:52 > To: arslist@ARSLIST.ORG > Subject: AIE connectivity to external Oracle DB > > Trying to create a AIE Connectivity to external Oracle DB > > Would like to know, what value has to be provided to Oracle Database > Directory in the External Data Store connection store information? > > > Test connection is not successful. > > Read somewhere that we need to provide the Oracle Client Path, where AIE > is installed. > > Oracle Client Path : C:\oracle\product\11.1.0\BIN - Is this right? > Please help. > > > ARS 7.6.04 SP4 > AIE 7.6.04 > > Regards, > Madhu > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the > Answers Are, and have been for 20 years" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"