3 Replies Latest reply: Aug 5, 2010 11:38 AM by Todd Little-Oracle RSS

    Creating SALT components

    745259
      HI,

      I am exploring a fresh install of Tuxedo 11g. I tried executing some samples under SALT and was successfully able to do so.

      I am keen on executing the BankApp which has been given under the ATMI samples. Could someone please help me with the steps to convert this App to SALT?

      What can be other simple scenarios that can be developed using SALT?
        • 1. Re: Creating SALT components
          Ed Heeren-Oracle
          Mav,

          There are many ways in which bankapp could potentially be extended to make use of SALT capabilities. bankapp could be extended to transmit information across GWWS, it could be extended to offer SCA services, or it could be extended in other ways.

          The $TUXDIR/samples/salt/wsrmapp extends bankapp to work with the Tuxedo Service Metadata Repository Server and with the GWWS SALT gateway. This sample shows WebLogic and thin Java web service client programs.

          Several SCA samples are available under $TUXDIR/samples/salt/sca . None of these samples are based on bankapp, but that comes closes to offering functionality similar to bankapp is the uBikeSCA sample.

          Note that Oracle product installers do not install samples by default, so please make sure that your administrator has chosen to install samples when installing Tuxedo and when installing SALT.

          Ed
          • 2. Re: Creating SALT components
            745259
            Thanks a lot for the Detailed response Ed.

            I am configuring the wsrmapp and have updated the setenv file for Linux Platform as follows

            # (c) 2007 BEA Systems, Inc. All Rights Reserved.
            # Copyright (c) 2007 BEA Systems, Inc.
            # All Rights Reserved

            # THIS IS UNPUBLISHED PROPRIETARY SOURCE CODE OF
            # BEA Systems, Inc.
            # The copyright notice above does not evidence any
            # actual or intended publication of such source code.

            export GWWS_HOST=BG4BORACAPSRV1W
            export GWWS_PORT=8002
            export IPCKEY=123456
            export TUXDIR=/u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1
            export JAVA_HOME=/u02/app/oracle/Middleware/jrockit_160_17_R28.0.0-679
            export WL_HOME=/u02/app/oracle/Middleware/wlserver_10.3
            export ANT_HOME=/u02/app/oracle/Middleware/modules/org.apache.ant_1.7.1

            export MAKE=make
            export MAKEFILE=makefile

            export PATH=$TUXDIR/bin:$ANT_HOME/bin:$WL_HOME/server/bin:$JAVA_HOME/bin:$PATH
            export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH
            export SHLIB_PATH=$TUXDIR/lib:$SHLIB_PATH
            export LIBPATH=$TUXDIR/lib:$LIBPATH

            #
            # setting a running Weblogic Server
            #
            export WL_SERVER_HOST=BG4BORACAPSRV1W
            export WL_SERVER_PORT=7001
            export WL_SERVER_NAME=AdminServer
            export WL_ADMIN_USER=####
            export WL_ADMIN_PASS=####


            I am getting the following error messages when i do a "ant all"

            [orafusion@BG4BORACAPSRV1W wsrmapp]$ ant all
            Buildfile: build.xml
            Trying to override old definition of datatype clientgen

            init:

            buildtux:
            [exec] make: makefile: No such file or directory
            [exec] make: *** No rule to make target `makefile'. Stop.
            [exec]
            [exec] CMDTUX_CAT:1800: WARN: Server RESTART set to Y and MAXGEN set < 2 on server entry TMMETADATA
            [exec] CMDTUX_CAT:883: ERROR: tmloadcf cannot run on an active node
            [exec] Parsing configuration "/u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/gwws.dep" (08-04-2010 06:58:45:943)
            [exec] Parse succeed (08-04-2010 06:58:45:986)
            [exec]
            [exec] tmadmin - Copyright (c) 1996-2010 Oracle.
            [exec] Portions * Copyright 1986-1997 RSA Data Security, Inc.
            [exec] All Rights Reserved.
            [exec] Distributed under license by Oracle.
            [exec] Tuxedo is a registered trademark.
            [exec]
            [exec] >
            [exec] TMADMIN_CAT:512: ERROR: Cannot create device /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/bankdl1, start 0, size 2560 on /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/bankdl1
            [exec] >
            [exec] >
            [exec] echo on
            [exec] create database bankdb with ( DEVNAME='/u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/bankdl1',
            [exec] IPCKEY=80953, LOGBLOCKING=0, MAXDEV=1,
            [exec] NBLKTBL=200, NBLOCKS=2048, NBUF=70, NFIELDS=80,
            [exec] NFILES=20, NFLDNAMES=60, NFREEPART=40, NLCKTBL=200,
            [exec] NLINKS=80, NPREDS=10, NPROCTBL=20, NSKEYS=20,
            [exec] NSWAP=50, NTABLES=20, NTRANTBL=20, PERM='0666',
            [exec] STATISTICS='n'
            [exec] )\g
            [exec] sql: Operation 'LIBSQL_CAT:45: create database': fs error
            [exec] sql: LIBDUX_CAT:13: illegal database name--not found or not unique
            [exec]
            [exec]
            [exec] create table BRANCH (
            [exec] BRANCH_ID integer not null,
            [exec] BALANCE real,
            [exec] LAST_ACCT integer,
            [exec] LAST_TELLER integer,
            [exec] PHONE char(14),
            [exec] ADDRESS char(60),
            [exec] primary key(BRANCH_ID)
            [exec] ) with (
            [exec] FILETYPE='hash', ICF='PI', FIELDED='FML',
            [exec] BLOCKLEN=1024, DBLKS=8, OVBLKS=2
            [exec] )\g
            [exec] sql: Operation 'create table': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] create table ACCOUNT (
            [exec] ACCOUNT_ID integer not null,
            [exec] BRANCH_ID integer not null,
            [exec] SSN char(12) not null,
            [exec] BALANCE real,
            [exec] ACCT_TYPE character,
            [exec] LAST_NAME char(20),
            [exec] FIRST_NAME char(20),
            [exec] MID_INIT character,
            [exec] PHONE char(14),
            [exec] ADDRESS char(60),
            [exec] primary key (ACCOUNT_ID)
            [exec] ) with (
            [exec] FILETYPE='hash', ICF='ST', FIELDED='FML',
            [exec] BLOCKLEN=1024, DBLKS=100, OVBLKS=25
            [exec] )\g
            [exec] sql: Operation 'create table': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] create table TELLER (
            [exec] TELLER_ID integer not null,
            [exec] BRANCH_ID integer not null,
            [exec] BALANCE real,
            [exec] LAST_NAME char(20),
            [exec] FIRST_NAME char(20),
            [exec] MID_INIT character,
            [exec] primary key (TELLER_ID)
            [exec] ) with (
            [exec] FILETYPE='hash', ICF='ST', FIELDED='FML',
            [exec] BLOCKLEN=1024, DBLKS=8, OVBLKS=2
            [exec] )\g
            [exec] sql: Operation 'create table': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] create table HISTORY (
            [exec] ACCOUNT_ID integer not null,
            [exec] TELLER_ID integer not null,
            [exec] BRANCH_ID integer not null,
            [exec] AMOUNT real
            [exec] ) with (
            [exec] FILETYPE='heap', ICF='ST', FIELDED='FML',
            [exec] BLOCKLEN=1024, DBLKS=800, OVBLKS=10
            [exec] )\g
            [exec] sql: Operation 'create table': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] create index ANAMEIDX on ACCOUNT (LAST_NAME, FIRST_NAME, MID_INIT)
            [exec] with (
            [exec] BLOCKLEN=1024, DBLKS=0, FILETYPE='BTREE',
            [exec] ICF='ST', LINKNAME='name_acct', LINKTYPE='indx',
            [exec] MULTIREC='n', OVBLKS=30, SPARSE='n'
            [exec] )\g
            [exec] sql: Operation 'create index (index file)': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] create index TNAMEIDX on TELLER (LAST_NAME, FIRST_NAME, MID_INIT)
            [exec] with (
            [exec] BLOCKLEN=1024, DBLKS=0, FILETYPE='BTREE',
            [exec] ICF='ST', LINKNAME='name_tell', LINKTYPE='indx',
            [exec] MULTIREC='n', OVBLKS=5, SPARSE='n'
            [exec] )\g
            [exec] sql: Operation 'create index (index file)': rm error
            [exec] sql: LIBDUX_CAT:454: invalid file name or file identifier
            [exec]
            [exec]
            [exec] \q
            [exec] crbankdb.sh successful.
            [exec] tmadmin - Copyright (c) 1996-2010 Oracle.
            [exec] Portions * Copyright 1986-1997 RSA Data Security, Inc.
            [exec] All Rights Reserved.
            [exec] Distributed under license by Oracle.
            [exec] Tuxedo is a registered trademark.
            [exec]
            [exec] > Echo now on.
            [exec]
            [exec] TMADMIN_CAT:512: ERROR: Cannot create device /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/TLOG, start 0, size 500 on /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/TLOG
            [exec] > crdl -b 500 -z /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/TLOG
            [exec]
            [exec] > q
            [exec] crtlog.sh successful.
            [exec] CMDTUX_CAT:6725: ERROR: Repository file /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/work/tux/bankapp.repos is locked by another program

            BUILD FAILED
            /u02/app/oracle/Middleware/Tuxedo1/tuxedo11gR1/TestSamples/samples/salt/wsrmapp/build.xml:116: exec returned: 1

            Can you please help me with this error?
            • 3. Re: Creating SALT components
              Todd Little-Oracle
              Hi,

              You might want to consider downloading the VirtualBox VM that is being used for the OTN Virtual Developer Day for Tuxedo. This VM includes the bankapp application modified to use Oracle database and includes access to some of the bankapp services via SOAP/HTTP using SALT. The GWWS is running on the brokerapp domain, so look in /home/vmuser/application/brokerapp/ for the SALT configuration information on how to expose bankapp services using SALT as web services. You can then extend that to use WS-ReliableMessaging if that's your intent (which I'm just guessing based upon your question about wsrmapp sample.)

              You can go to: http://www.oracle.com/goto/otnvdd to register (even for the North America event which has already passed) and then you'll have access to the VirtualBox VM. It's about a 2GB download. It also has some hands on labs in the image that may help you get started with SALT.

              Regards,
              Todd Little
              Oracle Tuxedo Chief Architect