I have recently installed DAC 11G with all the relevant combinations software (Oracle Database 11G, OBIEE 11G, DAC 11G and Informatica 9.1.0) on a 64 bit Windows server. Everything is working fine except for the DAC server. In version 11G, there is no separate component to start the server as we have it in earlier versions. When the Client option is clicked, it runs the server and opens the client but it is not really connected to the server.
If I go to the startserver.bat and execute it, I get the below message.
" Windows cannot find '-server'. Make sure you typed the name correctly, and then try again :
Content in the startserver.bat
title Oracle DAC Server
Rem Uncomment the below if you want to see a DOS window with messages.
Rem and comment out the JAVAW line.
Rem %JAVA% -Xms256m -Xmx1024m -cp %DACCLASSPATH% com.siebel.etl.net.QServer
Options I have tried:
I have also tried all combinations of updating the server name (system name) as localhost or the actual name of the system.
Update the config.bat with the server information but the error keeps popping up.
open command prompt and goto bifoundation\dac folder and run standaloneServerSetup.bat and follow the steps and specify the repository connection information and save changes and then restart the services....
I did and it is same as DAC server setup and i could able to Test that connection. Problem is the connection still showing Red plug. I have ServerPort as 4006 and Informatica port is 6005 and DAC Repository Name is DAC and Informatica Repository is SRIRST and integration service name is SRIINT. And Repository Configuration in DAC in Standalone mode is 3141.
Actually i see the status changed to Orange after reinstalling the DAC11 with all these setup. But still i have an issue with Informatica Servers. I could not able to connect them... I used the proper connections for Repository and Integration services... I am using 4006 as Integration ServerPort and 6005 as Repository port.
Do you guys see any issues with 64 bit informatica with 64 bit Oracle and ODBC connections? I have win 7 64bit OS and all 64 bit softwares. But i think informatica by default points to 32 bit ODBC. Not sure how to change this to 64 bit ODBC. 64 bit ODBC (odbcad32.exe) will be in c:/windows/system32 and 32 bit odbc(odbcad32.exe) will be in c:/windows/syswow64 folder... Right now i see informatica pointing 32 bit ODBC. Any body knows how we can point informatica to 64 bit ODBC? There is a powmart.ini file contains all these ODBCDLL files. Oracle=ORAODBC.DLL, but not sure where this file was referred in informatica installations. Anybody has any clue and how we can point informatica 64bit software to 64 bit ODBC?