Oracle® Business Intelligence Data Warehouse Administration Console Guide > Common Tasks Performed in the DAC > Command Line Access to the DAC Server >

Using the Command Line to Access the DAC Server


Follow this procedure to use the command line to access the DAC server.

To use the command line to access the DAC server

  • At the command prompt, enter the following:

    dacCmdLine <method name> <optional execution plan name>

    where method name is one of the following:

    Method Name
    Description

    StartETL

    Starts an execution plan. You must specify an execution plan name.

    StopETL

    Stops the operation of an execution plan. You must specify an execution plan name.

    ETLStatus

    If you do not specify an execution plan name, the status of the execution plan that last ran is returned. If you specify an execution plan name, the status of the specified execution plan is returned.

    DatabaseStatus

    Verifies whether the DAC server can connect to all active database connections. You do not need to specify an execution plan name.

    InformaticaStatus

    Verifies whether the DAC server is able to ping all active Informatica servers.

    NOTE:  The method names are case insensitive. Execution plan names are case sensitive. Also, if the execution plan name contains spaces, place beginning and ending double quotes around the name.

    For example:

    Command Line
    Description

    dacCmdLine EtlStatus

    Returns the status of the execution plan that last ran.

    dacCmdLine EtlStatus Forecast

    Returns the status of the last instance of the Forecast execution plan.

    dacCmdLine StopEtl Forecast

    If the execution plan currently running is Forecast, the operation will be terminated. Otherwise, the request is ignored.

    dacCmdLine databasestatus

    Returns the health status of all the database connections as defined in the DAC repository from the DAC server.

    dacCmdLine InformaticaStatus

     

    Returns the health status of all the Informatica server connections as defined in the DAC repository from the DAC server.

Oracle® Business Intelligence Data Warehouse Administration Console Guide Copyright © 2007, Oracle. All rights reserved.