Tuesday, June 1, 2010

DAC server as service in 10.1.3.4.1

Today I had to create the DAC server as a service again, this time in a later version of the DAC and found that the libraries have changed.  To get the DAC server working in this version:


I had to use this command (you'd need to change this to point to your location for the jdk and the dac root directory):

javaservice -install "Oracle BI: DAC Service" "E:\Java\jdk1.6.0_13\jre\bin\client\jvm.dll" -Xms256m -Xmx1024m "-Djava.class.path=E:\OracleBI\DAC\bifoundation\dac\lib\msbase.jar;E:\OracleBI\DAC\bifoundation\dac\lib\mssqlserver.jar;E:\OracleBI\DAC\bifoundation\dac\lib\msutil.jar;E:\OracleBI\DAC\bifoundation\dac\lib\sqljdbc.jar;E:\OracleBI\DAC\bifoundation\dac\lib\ojdbc6.jar;E:\OracleBI\DAC\bifoundation\dac\lib\ojdbc5.jar;E:\OracleBI\DAC\bifoundation\dac\lib\ojdbc14.jar;E:\OracleBI\DAC\bifoundation\dac\lib\db2java.zip;E:\OracleBI\DAC\bifoundation\dac\lib\terajdbc4.jar;E:\OracleBI\DAC\bifoundation\dac\lib\log4j.jar;E:\OracleBI\DAC\bifoundation\dac\lib\teradata.jar;E:\OracleBI\DAC\bifoundation\dac\lib\tdgssjava.jar;E:\OracleBI\DAC\bifoundation\dac\lib\tdgssconfig.jar;E:\OracleBI\DAC\bifoundation\dac\DAWSystem.jar;E:\OracleBI\DAC\bifoundation\dac" "-Duser.dir=E:\OracleBI\DAC\bifoundation\dac" -start  com.siebel.etl.net.QServer -description "Oracle BI DAC Server Service" -current "E:\OracleBI\DAC\bifoundation\dac"

As you can see the libraries are completely different compared to my earlier post.

You must include the -current parameter, as otherwise the relative references to files will not work and so features such as integration with Informatica will not work correctly.

3 comments:

  1. Hi Mat,

    Thanks for posting useful technical articles.
    Am trying to create the DAC service for 10.1.3.4.1 dac vesion but ended with below error

    Unrecognised or incorrectly-ordered parameters for install command
    The last 2 parameters (from '-current') were not recognised
    JavaService install command parameters not valid, or incomplete.

    I copied javaservice.exe to DAC_HOME directory and run the following command .
    javaservice -install "Test Service" "D:\OracleBI101341\DAC\jdk\jre\bin\client" -Xms256m -Xmx1024m "-Djava.class.path=D:\OracleBI101341\DAC\bifoundation\dac\lib\msbase.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\mssqlserver.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\msutil.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\sqljdbc.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\ojdbc6.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\ojdbc5.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\ojdbc14.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\db2java.zip;D:\OracleBI101341\DAC\bifoundation\dac\lib\terajdbc4.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\log4j.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\teradata.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\tdgssjava.jar;D:\OracleBI101341\DAC\bifoundation\dac\lib\tdgssconfig.jar;D:\OracleBI101341\DAC\bifoundation\dac\DAWSystem.jar;D:\OracleBI101341\DAC\bifoundation\dac" "-Duser.dir=D:\OracleBI101341\DAC\bifoundation\dac" -start com.siebel.etl.net.QServer -description "Test Service" -current "D:\OracleBI101341\DAC\bifoundation\dac" .


    Can you please help me to fix this issue .

    Thx
    Vinod

    ReplyDelete
  2. the order of options at the end need to be switched around for the command to work. i.e., enter '-current' option before '-description' option and it should work.

    ReplyDelete