2 Replies Latest reply: Jul 18, 2001 1:02 AM by 807581 RSS

    How do u connect to an Oracle Database for the DBService in the fusion engine???

    807581
      Hi,
      1)how do u connect to an Oracle Database for the DBService in the fusion
      engine??? I'm using Oracle8.
      it gives me the followin error.

      Application: WFDatabaseSvc_cl1
      Platform: PC / NT
      Partition: WFDatabaseSvc_cl1_Part1
      Generated: 06-Nov-2000 17:02:00
      By: ftexec Forte Version 3.0.N.0

      Process ID 339

      Attached to manager for node SON1060.
      registering agent anchor
      /WorkFlow/centrale/ceengine/Agents/DatabaseService_DBUnit
      03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Connecting to Oracle database
      ForteDB, user: SYSTEM, password: MANAGER
      03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Error connecting to database
      03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: SQLNet V1 style connection is no
      longer supported. Please use SQLNet V2 connection syntax.
      SYSTEM ERROR: SQLNet V1 style connection is no longer supported. Please use
      SQLNet V2 connection syntax.
      Class: qqdb_RemoteAccessException with ReasonCode: DB_ER_DBMSCONNECTION
      Error #: [804, 18]
      Detected at: qqdb_OracleVendorInfo::DoOrlon
      Error Time: Tue Jul 03 10:46:37
      Exception occurred (locally) on partition "WFDatabaseSvc_cl1_Part1",
      (partitionId = 6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc, taskId =
      [6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc.10]) in application
      "WFDatabaseSvc_cl1", pid 339 on node SON1060 in environment centrale.
        • 1. Re: How do u connect to an Oracle Database for the DBService in the fusion engine???
          807581
          The sytax for specifying the Oracle database is: @[TnsResourceName]

          "secnews.netscape.com" <cthr@sonata-software.com> wrote in message
          news:9j3inf$f51@secnews.netscape.com...
          Hi,
          1)how do u connect to an Oracle Database for the DBService in the fusion
          engine??? I'm using Oracle8.
          it gives me the followin error.

          Application: WFDatabaseSvc_cl1
          Platform: PC / NT
          Partition: WFDatabaseSvc_cl1_Part1
          Generated: 06-Nov-2000 17:02:00
          By: ftexec Forte Version 3.0.N.0

          Process ID 339

          Attached to manager for node SON1060.
          registering agent anchor
          /WorkFlow/centrale/ceengine/Agents/DatabaseService_DBUnit
          03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Connecting to Oracle database
          ForteDB, user: SYSTEM, password: MANAGER
          03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Error connecting to database
          03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: SQLNet V1 style connection is no
          longer supported. Please use SQLNet V2 connection syntax.
          SYSTEM ERROR: SQLNet V1 style connection is no longer supported. Please
          use
          SQLNet V2 connection syntax.
          Class: qqdb_RemoteAccessException with ReasonCode:
          DB_ER_DBMSCONNECTION
          Error #: [804, 18]
          Detected at: qqdb_OracleVendorInfo::DoOrlon
          Error Time: Tue Jul 03 10:46:37
          Exception occurred (locally) on partition "WFDatabaseSvc_cl1_Part1",
          (partitionId = 6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc, taskId =
          [6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc.10]) in application
          "WFDatabaseSvc_cl1", pid 339 on node SON1060 in environment centrale.
          • 2. Re: How do u connect to an Oracle Database for the DBService in the fusion engine???
            3004
            Put @ before the database name. This should fix your problem.

            "secnews.netscape.com" <cthr@sonata-software.com> wrote in message
            news:9j3inf$f51@secnews.netscape.com...
            Hi,
            1)how do u connect to an Oracle Database for the DBService in the fusion
            engine??? I'm using Oracle8.
            it gives me the followin error.

            Application: WFDatabaseSvc_cl1
            Platform: PC / NT
            Partition: WFDatabaseSvc_cl1_Part1
            Generated: 06-Nov-2000 17:02:00
            By: ftexec Forte Version 3.0.N.0

            Process ID 339

            Attached to manager for node SON1060.
            registering agent anchor
            /WorkFlow/centrale/ceengine/Agents/DatabaseService_DBUnit
            03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Connecting to Oracle database
            ForteDB, user: SYSTEM, password: MANAGER
            03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: Error connecting to database
            03-Jul-2001 10:46:37: OFHDBMgr.ConnectDB: SQLNet V1 style connection is no
            longer supported. Please use SQLNet V2 connection syntax.
            SYSTEM ERROR: SQLNet V1 style connection is no longer supported. Please
            use
            SQLNet V2 connection syntax.
            Class: qqdb_RemoteAccessException with ReasonCode:
            DB_ER_DBMSCONNECTION
            Error #: [804, 18]
            Detected at: qqdb_OracleVendorInfo::DoOrlon
            Error Time: Tue Jul 03 10:46:37
            Exception occurred (locally) on partition "WFDatabaseSvc_cl1_Part1",
            (partitionId = 6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc, taskId =
            [6E177A00-5E58-11D5-8330-E8174C9EAA77:0x1dc.10]) in application
            "WFDatabaseSvc_cl1", pid 339 on node SON1060 in environment centrale.