43. 登录Teamcenter报错“'SOA_MaxOperationBracketTime'”

admin

43. 登录Teamcenter报错“'SOA_MaxOperationBracketTime'”
) \3 A; `' I0 [, z/ [* o7 P. t

3 k. F0 J- s+ q" f! ~

'SOA_MaxOperationBracketTime

! a; r9 z( p- n5 b# f5 A" m0 Z6 f

Solution

4 l5 `7 O6 ~! G3 X" U5 x2 O3 @; M4 x主要是检查数据库是否OK，通过sql进行连接数据库，看是否正常。也有可能是数据库密码过期，看下面的处理
/ |6 ~6 d0 A' I6 T( T. x; m9 ]0 Y) |

( X; f. n8 ?) P. D/ i
& }$ }0 D' ?0 \, R

" i0 ~( [' T) T/ Z4 g. {# \
5 K* u- j2 V" G

admin

Solution

This is due to the Oracle Password having expired and needs to be reset.
. Z8 M7 Y" s4 n' ^
9 y% K, E) z5 c& ^/ z' s7 bPerform the following in a OS CMD window making the necessary changes for your
environment and directory structure.
% ~5 D* ]- |1 N) z* h/ C
--
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1

1 M! `6 P7 i( b( s* M; Kset oracle_sid=tc

%oracle_home%\bin\sqlplus /nolog

connect / as sysdba
3 @$ f4 E) w* L5 p' h: Z
/ l! R/ v( h6 r+ i" Walter user infodba identified by infodba;

select expiry_date from dba_users where username='INFODBA';

+ e5 \, Z; h2 c  i6 h; F0 x: Vselect profile from dba_users where username='INFODBA';

alter profile default limit password_life_time unlimited;

select expiry_date from dba_users where username='INFODBA';
--

Expected output in command window.
==
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
+ X# m* B% X! \5 `
; X2 {: o: c+ N; o  sC:\Users\<user id>>
C:\Users\<user id>>set oracle_sid=tc
( x# v) ?0 C  P
C:\Users\<user id>>
3 F. V7 t% w0 E* X8 Y1 pC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
, E) x, x3 y# ?% Z5 V3 J
- b$ H+ l# F4 n# i: zSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
) }' P6 }0 `0 y* J8 n9 ]
' I* R! E3 k& B& aCopyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL>
SQL> connect / as sysdba
9 Q- g5 K" y8 |( @Connected.
0 n( @: Q- B0 ?0 p# c% v7 H; KSQL>
4 K. w3 V5 t1 E4 P  sSQL> alter user infodba identified by infodba;
- _2 T7 k) R$ M% K
6 D! q% E9 U1 H6 ~User altered.
  c/ N' Y9 Q8 A4 b& {
5 v! l  t% N' _SQL>
! {" L5 K1 s/ v7 @+ rSQL> select expiry_date from dba_users where username='INFODBA';
- X0 Y7 I/ H7 Q/ o9 {
7 o+ [! l9 Y6 H7 p% A$ BEXPIRY_DA
---------
; a9 u3 I) P, ]2 E- d01-JUN-14

$ @' U" D2 L/ |$ n% C7 v3 m7 Y5 VSQL>
# U% r  _! R! k8 S9 s/ X9 wSQL> select profile from dba_users where username='INFODBA';
! D. P- z! B7 A+ A. @% ?
PROFILE
------------------------------
DEFAULT

' ?* M: S* @9 }2 [0 ~SQL>
SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL>
SQL> select expiry_date from dba_users where username='INFODBA';
. v- U7 f9 x' W6 S
EXPIRY_DA
---------
2 m0 J1 f1 j4 F4 y& Z/ m' K1 v+ y
) Z; \9 d; S0 ^: k& R0 XSQL>
SQL>

- d/ W: N( [' [- D6 Y% e

陈小七

感谢分享

巴黎之夜1972

怎么解决