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

admin

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

; M0 \4 a; }$ N4 X( K3 b

'SOA_MaxOperationBracketTime

Solution
  Q' D: `4 y- h) f* k% j3 i  I/ Q# u
( Y! b1 Z) M; k+ v' ?7 f主要是检查数据库是否OK，通过sql进行连接数据库，看是否正常。也有可能是数据库密码过期，看下面的处理
1 k& l% U3 r/ F) R4 B" m" f2 u



" `8 B. W+ N* A" [
! T9 n% X" @4 c. n

admin

Solution

$ h. U* l7 B, u/ M9 @This is due to the Oracle Password having expired and needs to be reset.
" N6 H1 B6 p% p  G3 z
Perform the following in a OS CMD window making the necessary changes for your
environment and directory structure.

3 u% `2 Z2 C7 _" a% f5 t- M+ l--
5 N( h! k- Y9 [% Y! i* Kset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
1 v3 l, O: p1 t+ G9 D& c% _
6 b# u! Z2 z: Q( B7 S* {set oracle_sid=tc
% S$ e7 Q9 w' n
%oracle_home%\bin\sqlplus /nolog
7 K; j0 `( m  S' d
connect / as sysdba

alter user infodba identified by infodba;

" u1 M0 y5 Z" P$ d3 \8 sselect expiry_date from dba_users where username='INFODBA';

select profile from dba_users where username='INFODBA';

& h( O2 n. v9 l' Z/ j- jalter profile default limit password_life_time unlimited;

select expiry_date from dba_users where username='INFODBA';
--
3 M9 h  ?) l- v. Z: r& b
Expected output in command window.
==
' T4 l9 q" v. ]1 H! u$ n/ P# ?! XC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
0 _9 A+ M$ {/ n7 J" |
C:\Users\<user id>>
C:\Users\<user id>>set oracle_sid=tc

C:\Users\<user id>>
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
8 D- ~- P9 x: u: D
, K& i3 h- ]( N8 b! `. D! qSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013

  T4 a3 Y/ N, r  X; E4 oCopyright (c) 1982, 2010, Oracle.  All rights reserved.
  z! `# k& u; B* o" B. ~. U+ q- N; d( q
. F5 M& {1 C: {, J  aSQL>
' `4 O; j$ {, `SQL> connect / as sysdba
( E& g# ^  ~! }: [  W9 f, }Connected.
SQL>
1 G3 T( }* M, _* l5 S% pSQL> alter user infodba identified by infodba;

User altered.

SQL>
) v+ q5 ?7 O% E- f5 gSQL> select expiry_date from dba_users where username='INFODBA';
2 X6 Y/ \. u4 e; D! p9 h; S
EXPIRY_DA
; h+ b7 u' R+ V- l1 y: a---------
1 L0 O" X+ |4 \7 n4 h0 D01-JUN-14
0 m6 G) W" H" K
SQL>
SQL> select profile from dba_users where username='INFODBA';

* f  X/ a( _9 A; I; EPROFILE
) Y4 a+ `+ j2 n% `* \- H------------------------------
DEFAULT

SQL>
SQL> alter profile default limit password_life_time unlimited;

# W' x" V0 h5 N8 Z! MProfile altered.
% K- m* i# c" D
  }. [! M$ A) J9 P: A7 JSQL>
SQL> select expiry_date from dba_users where username='INFODBA';
: H5 Z% K% @  m/ F2 @' L4 y& v
/ U3 y4 J. q+ T+ Q6 aEXPIRY_DA
  X9 D* G7 u7 J---------

SQL>
SQL>


- Y1 R5 Z& q: ~& ^0 G

陈小七

感谢分享

巴黎之夜1972

怎么解决