3 Replies Latest reply: Jul 28, 2014 12:48 AM by Phanikanth RSS

    Re: ODI 12c Colacated agent scripts error

    user9542546

      Hi

       

        I am currently working on ODI 12c colacated agent. I was trying to invoke encode.sh script for encrypting passwords after setting all the ODI variables in CommODIEnv.sh script.

      I am facing the below error with this execution .

       

      $ ./encode.sh "-INSTANCE=OracleDIAgent1"

      oracle.core.ojdl.logging.LoggingConfigurationException: ODL-52042: undefined property: ${domain.home}.

      Jul 24, 2014 12:49:13 PM oracle.odi.param.CliParameterReader <init>

      SEVERE: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

      org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:94)

              at oracle.odi.Encode.getOdiInstance(Encode.java:24)

              at oracle.odi.Encode.main(Encode.java:52)

       

      java.lang.RuntimeException: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.Encode.getOdiInstance(Encode.java:27)

              at oracle.odi.Encode.main(Encode.java:52)

      Caused by: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:94)

              at oracle.odi.Encode.getOdiInstance(Encode.java:24)

              ... 1 more

       

              DESCRIPTION

                      Encode a password. See Oracle Data Integrator documentation for the

                      detailed syntax.

       

              SYNTAX

                      encode.(cmd|sh) "-INSTANCE=<instance_name>" <password>

       

       

      So i have added a java variable into CommODIEnv.sh script called

      -Ddomain.home=/dbopt/mounts/apps/odi_12.1.3/user_projects/domains/odi_domain

      then executed it then getting below error :


      $ ./encode.sh "-INSTANCE=OracleDIAgent1"

      /apps/odi_12.1.3/odi/agent/internal/bin/commODIEnv.sh: line 195: -Ddomain.home=/dbopt/mounts/apps/odi_12.1.3/user_projects/domains/odi_domain: No such file or directory

      Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed

      oracle.core.ojdl.logging.LoggingConfigurationException: ODL-52042: undefined property: ${domain.home}.

      Jul 24, 2014 12:49:13 PM oracle.odi.param.CliParameterReader <init>

      SEVERE: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

      org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:94)

              at oracle.odi.Encode.getOdiInstance(Encode.java:24)

              at oracle.odi.Encode.main(Encode.java:52)

       

      java.lang.RuntimeException: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.Encode.getOdiInstance(Encode.java:27)

              at oracle.odi.Encode.main(Encode.java:52)

      Caused by: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null"

              at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:94)

              at oracle.odi.Encode.getOdiInstance(Encode.java:24)

              ... 1 more

       

              DESCRIPTION

                      Encode a password. See Oracle Data Integrator documentation for the

                      detailed syntax.

       

              SYNTAX

                      encode.(cmd|sh) "-INSTANCE=<instance_name>" <password>



      Appreciate your response.Thanks in advance.

        • 1. Re: ODI 12c Colacated agent scripts error
          Phanikanth

          Hi

           

          Hope below URL may helps you

           

          7 Configuring the Domain for the Colocated Standalone Agent (12c (12.1.3))

           

          http:// docs.oracle.com/middleware/1213/core/ODING/configure_col.htm#A1002310670

           

          Regards,

          Phanikanth

          • 2. Re: ODI 12c Colacated agent scripts error
            user9542546

            Thanks Phanikanth.

            Now the above issue has been fixed and running into another issue while executing startloadplan.sh script

             

            sh startloadplan.sh LPN_TEST  "-INSTANCE=OracleDIAgent1" DEV "-AGENT_URL=http://servername:20910/oraclediagent"

            2014-07-25 15:04:44.394 ERROR ODI-1651 Error while executing:

             

            In the log file..

            /apps/odi_12.1.3/odi/log/

             

            [2014-07-25T15:04:44.394-05:00] [odi] [ERROR] [ODI-1651] [oracle.odi.agent] [tid: 1] [ecid: 0000jhkjhkh0] Error while executing:[[

            oracle.odi.runtime.agent.invocation.InvocationException: ODI-1274: Agent Exception Caused by: ODI-1423: Warning connecting to Agent OracleDIAgent1: work repository WORKREP is not bound to the master repository.

            Caused by: oracle.odi.core.config.WorkRepositoryNotFoundException: ODI-10200: Work repository WORKREP wasn't found.

             

            Thanks in advance.

            • 3. Re: ODI 12c Colacated agent scripts error
              Phanikanth

              Hi

               

              Please check is WORKREP is mapped to master repository ?

               

              1.From ODI Studio > Topology > Work Repositories: click on the *connect* icon button, and for each of the two Work Repositories, display the database connection information (user, URL ) and note down this information.

              2.In Weblogic Admin Console, edit the definition of the odiWorkRepository Data Source and modify it according to the information from point 1.

              3.Stop and restart the WLS managed and admin servers.

              4.Open ODI console and re-attempt to connect to the ODI 11G Work Repository.

               

              Regards,

              Phanikanth