TroubleShooting
[Tuxedo] oracle XA 구성 중 에러
최선을 다하자!
2022. 10. 25. 17:31
[Tuxedo]
GROUP절 OPENINFO 구성 중 에러 정리
기동하면서 ULOG와 XA.trc 에러메세지 확인
ULOG 확인
LIBTUX_CAT:466: ERROR: tpopen TPERMERR xa_open returned XAER_INVAL -> DB ID/PASSWD 제대로 적었는지 확인
LIBTUX_CAT:466: ERROR: tpopen TPERMERR xa_open returned XAER_RMERR -> DB 사용자 권한 문제
LIBTUX_CAT:250: ERROR: tpsvrinit() failed -> DB 사용자 권한 문제
LIBTUX_CAT:300: ERROR: _tlog_open: _gp_tblopen: UNIX sys call error - 2 -> DB 사용자 권한 문제
CMDTUX_CAT:825: ERROR: Process TMS_ORA19 at simple failed with /T tperrno (TPERMERR - resource manager error) -> DB 사용자 권한 문제
XA.trc 확인
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124355.3392.0:
xaogetmod: XAER_INVAL; Invalid xa_info string.
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124355.3393.0:
xaogetmod: XAER_INVAL; Invalid xa_info string.
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124522.3530.0:
xaolog: Could not open file in directory log_path
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124522.3530.0:
xaoopen: xa_info=Oracle_XA+Acc=P/jwchoi/********+SesTm=60+LogDir=log_path+DbgFl=15,rmid=0,flags=0x0
124522.3530.0:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production
124522.3530.0:
ORA-01045: user JWCHOI lacks CREATE SESSION privilege; logon denied
124522.3530.0:
xaolgn: XAER_RMERR; logon failed. ORA-1045.
124522.3530.0:
xaoopen: return -3
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124522.3533.0:
xaolog: Could not open file in directory log_path
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
124522.3533.0:
xaoopen: xa_info=Oracle_XA+Acc=P/jwchoi/********+SesTm=60+LogDir=log_path+DbgFl=15,rmid=0,flags=0x0
124522.3533.0:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production
124522.3533.0:
ORA-01045: user JWCHOI lacks CREATE SESSION privilege; logon denied
124522.3533.0:
xaolgn: XAER_RMERR; logon failed. ORA-1045.
124522.3533.0:
xaoopen: return -3
해결된 로그
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
141539.11601.0:
xaolog: Could not open file in directory log_path
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
141539.11601.0:
xaoopen: xa_info=Oracle_XA+Acc=P/jwchoi/********+SesTm=60+LogDir=log_path+DbgFl=15,rmid=0,flags=0x0
141539.11601.0:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production
141539.11601.0:
xaolgn: sqlxrc/sqlxss completed
141539.11601.0:
xaolgn: return XA_OK
141539.11601.0:
xaoopen: xaolgn completed
141539.11601.0:
xaoopen: return 0
141539.11601.0:
xaorecover: rmid=0, flags=0x1000000
141539.11601.0:
xaorecover: xids=0x221cbf50, count=100, rmid=0, flags=0x1000000
141539.11601.0:
xaofetch: fetchcb->xaorfrfs=2
141539.11601.0:
OCIStmtPrepare: Attempting
141539.11601.0:
OCIStmtPrepare: Succeeded
141539.11601.0:
OCIStmtExecute: Attempting
141539.11601.0:
OCIStmtExecute: Succeeded
141539.11601.0:
OCIStmtFetch: Attempting
141539.11601.0:
xaofetch: fetchcb->xaorfrfs=2
141539.11601.0:
OCIStmtPrepare: Attempting
141539.11601.0:
OCIStmtPrepare: Succeeded
141539.11601.0:
OCIStmtExecute: Attempting
141539.11601.0:
OCIStmtExecute: Succeeded
141539.11601.0:
OCIStmtFetch: Attempting
141539.11601.0:
xaoclrfb: cno=0, rmptr=0xc9f21060
141539.11601.0:
xaoclrfb: cno=0, rmptr=0xc9f21060
141539.11601.0:
xaoclrec: return (void)
141539.11601.0:
xaorecover: rtn 0
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
141539.11605.0:
xaolog: Could not open file in directory log_path
ORACLE XA: Version 19.0.0.0.0. RM name = 'Oracle_XA'.
141539.11605.0:
xaoopen: xa_info=Oracle_XA+Acc=P/jwchoi/********+SesTm=60+LogDir=log_path+DbgFl=15,rmid=0,flags=0x0
141539.11605.0:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production
141539.11605.0:
xaolgn: sqlxrc/sqlxss completed
141539.11605.0:
xaolgn: return XA_OK
141539.11605.0:
xaoopen: xaolgn completed
141539.11605.0:
xaoopen: return 0