配置.txt

TUXEDO连接数据库的例子

1、oracle的配置

    1．用internal用户（缺省的口令是oracle）进入SQLPLUS
       C:\>sqlplus internal/oracle
    2．运行ORACLE的安装路径下的/rdbms/admin/xaview.sql
       SQL> @d:\ora81\rdbms\admin\xaview.sql
    3．授权
       SQL>grant select on v$xatrans$ to public with grant option;
       SQL>grant select on v$pending_xatrans$ to public with grant option;
    4.	用system用户（缺省的口令是manager）连接并授权
	SQL>connect system/manager
	SQL>grant select any table to public;



2、修改TUXEDO安装路径的udataobj目录下的RM文件，加入一行：
Oracle_XA;xaosw;D:\oracle\ora92\rdbms\XA\ORAXA9.LIB D:\oracle\ora92\precomp\lib\msvc\oraSQL9.LIB

3、在TUXEDO用户下创建TMS文件:TMS_ORA9i：
buildtms -o C:\bea\tuxedo8.1\bin\TMS_ORA9i -r Oracle_XA

4、配置 UBBCONFIG
	*MACHINES节中增加：
	TLOGDEVICE = "D:\tuxedo\projects\dbconnect\log\TLOG"
	
	改*GROUPS节的配置为：
	DBGroup
		LMID=simple 	GRPNO=1 
		TMSNAME="TMS_ORA9i"	TMSCOUNT=5
		OPENINFO="Oracle_XA:Oracle_XA+SqlNet=CNC.DRAWING+Acc=P/cncnms/cncnms+SesTm=300+LogDir=."

5、重命名下列文件：
TUXEDO安装路径include目录下：
	把sqlca.h 改名为 sqlca.h.bbb
     	把sqlcode.h 改名为 sqlcode.h.bbb
     	把sqlda.h 改名为 sqlda.h.bbb

TUXEDO安装路径lib目录下：
	把libsql.lib 改名为 libsql.lib.bbb


6、用TMADMIN创建TLOG文件：

setenv

tmloadcf ubbsimple

D:\tuxedo\projects\dbconnect>tmadmin
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
No bulletin board exists. Entering boot mode.

> crdl -b 500 -z D:\tuxedo\projects\dbconnect\log\TLOG
Device created: D:\tuxedo\projects\dbconnect\log\TLOG

> crlog -m simple
crlog successfully completed.

> q


7、编译服务端程序：
proc dbserv.pc include=%TUXDIR%/include
buildserver -o dbserv.exe -f dbserv.c -r Oracle_XA -s DBCONNECT

8、编译客户端程序
buildclient -o dbcl.exe -f dbcl.c

9、启动TUXEDO应用系统，应能看到所有的SERVER都启动成功





-------

ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.

161334.1636:2808.0:
ORA-12535: TNS: 操作超时

161334.1636:2808.0:
xaolgn_help: XAER_RMERR; OCIServerAttach failed. ORA-12535.


-----