3 Replies Latest reply: Jan 23, 2013 12:00 PM by Bobfinan - Oracle-Oracle RSS

    Create TLOG on ORACLE DB FAILS

    915395
      I have an error preventing creation of TLOG on an Oracle Database

      the DB name is:
      "GPPDB"

      Schema name:
      "TLOG8"

      the UBBCONFIG TLOGDEVICE string is:
      TLOGDEVICE="Oracle_XA:Oracle_XA+Acc=P/TLOG8/tlog+SesTm=360+SesWt=360+SqlNet=GPPDB+LogDir=/home/dev/develop/gpp/env/xa+DB=GPPDB+DbgFl=0x0"
      TLOGNAME="TLOG8"

      tmadmin error is:
      crlog -m dev1
      TMADMIN_CAT:566: ERROR: local log creation failed

      ULOG:
      121930.el2gcn08.osc.uk.oracle.com!tmadmin.5142.3004925664.-2: TMADMIN_CAT:1330: INFO: Command: crlog -m dev1
      121930.el2gcn08.osc.uk.oracle.com!tmadmin.5142.3004925664.-2: LIBTUX_CAT:300: ERROR: tlogcreate: gpcrtbl: UNIX sys call error - 2

      can anyone help with this ?

      thx
      filippo
        • 1. Re: Create TLOG on ORACLE DB FAILS
          Bobfinan - Oracle-Oracle
          Hi Filippo,
          Your TLOGDEVICE is incorrect. It should be a path to the TLOD (e.g. TLOGDEVICE="/myuserpath/myappdir/TLOG")

          The Tuxedo 12c documentation is incorrect for the new paragraph added to TLOGDEVICE parameter definition.
          http://docs.oracle.com/cd/E18050_01/tuxedo/docs11gr1/rf5/rf5.html#wp3516409

          Where it imentions TLOGDEVICE it should have said OPENINFO. Something like this:
          "TLOGDEVICE = string_value[0..256] (up to 64 bytes for Oracle Tuxedo 8.0 or earlier)

          Specifies the Oracle Tuxedo filesystem that contains the DTP transaction log (TLOG) for this machine. The TLOG is stored as an Oracle Tuxedo system VTOC table on the device. If this parameter is not specified, the machine is assumed to not have a TLOG.

          To output tlog information into an Oracle database, you must use the following OPENINFO string to connect to an Oracle database:
          OPENINFO="DB:Oracle_XA: Oracle_XA+Acc=P/Scott/*****SesTm=30LogDit=/tmp" Oracle_XA is the published name of the Oracle XA interface. The series of five asterisks (*) in the OPENINFO string pertains to the encrypting of a password.
          Note: To use the Shared Applications Staging feature in MP mode, users must set different TLOGDEVICE values on different nodes."

          Where OPENINFO is a parameter you add in the GROUP section definitions.
          Sorry for the confusion,
          Bob Finan

          Edited by: Bob Finan on Jan 18, 2013 10:55 AM
          • 2. Re: Create TLOG on ORACLE DB FAILS
            Right Lv-Oracle
            hi, bob,
            The description for TLOGDEVICE of Tuxedo 12c documentation is correct, you give the incorrect link.
            http://docs.oracle.com/cd/E18050_01/tuxedo/docs11gr1/rf5/rf5.html#wp3516409 is the link of 11.1.1.2.0.

            Below is the correct link:
            For 11.1.1.3.0, please see http://docs.oracle.com/cd/E26665_01/tuxedo/docs11gr1/rf5/rf5.html
            For 12.1.1, please see http://docs.oracle.com/cd/E35855_01/tuxedo/docs12c/rf5/rf5.html

            The feature of write TLOG to Oracle database is provided since Tuxedo 11.1.1.3 on Linux Platform.

            /right.lv
            • 3. Re: Create TLOG on ORACLE DB FAILS
              Bobfinan - Oracle-Oracle
              Hi,
              OK, if your intent is to use an Oracle database instead of a filesystem for transaction logging then it is my mistake. This feature was added in Tuxedo 11.1.1.3.
              If that is what you need then the documentation does say that the TLOGDEVICE definition is required to start with "DB:".
              "To output tlog information into an Oracle database, you must use the following TLOGDEVICE string to connect to an Oracle database:
              TLOGDEVICE="DB:Oracle_XA: Oracle_XA+Acc=P/Scott/*****SesTm=30LogDir=/tmp"
              Oracle_XA is the published name of the Oracle XA interface. The series of five asterisks (*) in the TLOGDEVICE string pertains to the encrypting of a password."

              Regards,
              Bob

              PS:
              As in the Tuxedo OPENINFO parameter, the Acc,SessTM,LogDir (etc) open string options usage is specified by Oracle database.
              The TLOGNAME requirement is:
              "To output tlog information into an Oracle database, TLOGNAME must not be empty. If the TLOGs are stored in the same schema on the same database, the TLOGNAME must be unique for each log. You must make sure that there are no other programs using the table name TLOGNAME."

              Edited by: Bob Finan on Jan 23, 2013 9:56 AM

              Edited by: Bob Finan on Jan 23, 2013 9:56 AM

              Edited by: Bob Finan on Jan 23, 2013 9:58 AM