88.Teamcenter 的账号infodba数据库oracle过期的处理

admin

Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user
0 O. Z' T4 X( k5 k; \" C
Problem:
( l2 ?% o' V5 e! W7 rIf your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
  C: @. {4 O5 X2 l; ?obtain the following message after 180 days.
Login was unsuccessful.: Problems encountered logging into TCServer:
% X% J/ D5 B+ H( P: e5 k ... database
4 @' y& b) ^2 ], |Cause: Unable to bind to server running on localhost: 1572

: P; ]* s% l4 e7 c3 b/ n, gAnalysis:
This issue seems to be due to the Oracle 11g changes. All the Oracle services are started
correctly. However, when you try to connect to the database using sqlplus you can obtain the
following error message:
6 N2 E$ q' c' r" kORACLE_HOME=your_oracle_home
ORACLE_SID=your_sid
1 [. z7 N7 a! G, G% r. f) F>%oracle_home%\bin\sqlplus /nolog
4 `' L* ?! x/ ]1 y" ?0 W& u' ^8 U0 PSQL> connect
4 y5 S# O1 Y1 l& x! s$ Q! e! |$ finfodba
' K1 i! I6 K5 t9 k$ O) iinfodba
  F! H6 h% e* D* `+ ?, Z# b, eERROR:
# J3 ?9 G3 F' u6 J: tORA-28002: the password will expire within 10 days
: N' w. S' ^; y
4 c4 M' ]5 H9 r# b( |In the user tcserver.syslog file we find the error message:
% }8 ], l  r3 r- f* CConnect failed (-28002) for 'infodba' at ***
& S& m# C: G9 x& u/ C' WThe "infodba" Oracle user seems to be created using the default oracle profile which has an
7 Y- W! ]3 M! f$ M! ?' @* T9 xexpiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database
an error message, ORA-28002, is sent and the connection fails.
7 i, a  g1 }. Q; n# e$ n% c1 o
Solution:
6 E; q9 u2 I. n0 V2 x4 DFind the infodba profile using SQLPLUS:
0 q( |1 K- l; GSQL> select profile from dba_users where username='INFODBA';
5 {4 z* n+ M% s! O& RList the profile caracteristics:
. x& Z7 D# }- U6 }+ J6 m5 ESQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';
Check the PASSWORD_LIFE_TIME.
Modify the profile and specify an unlimited PASSWORD_LIFE_TIME:
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
) ~4 C# {- S2 N0 b* i( mChange the password. It will not expire again.
0 H1 A) c6 H- a% M8 |If you don't change the password, it will expire because it was created using a different profile at
the time.
  Z" Y2 p! \2 a9 KSQL> select expiry_date from dba_users where username ='INFODBA';
2 k; O  [! d# Z  D=> you obtain an expiration date
SQL>alter user infodba identified by tempo ; ( define a temporary pwd)
SQL> alter user infodba identified by infodba ; ( specify your original infodba
password)
SQL> select expiry_date from dba_users where username ='INFODBA';
( k8 l3 b4 b- {7 F0 A=> you have no expiration date.
% R# _; H7 N$ x+ l+ w* b
8 [, `' _( x1 m  E2 W2 A, {6 O6 L
" p# G& ?( Q3 |- G4 |8 J" eRemarks:
Because we have redefined the same original infodba password, the TC_DB_CONNECT variable
in %TC_DATA%\tc_profilevars.bat is always alive and correct.
5 i. _/ @' }$ C  u# T* d2 X4 y! SAnother modification can be done on the default profile:
* t$ K4 c6 u; V5 q" h" H& s8 a$ C
' j7 C4 l7 W( Z4 s( GALTER PROFILE DEFAULT LIMIT
) J1 a4 e8 t, s% ?! `$ q) _ FAILED_LOGIN_ATTEMPTS UNLIMITED
8 I! e$ O  V& C2 |/ b PASSWORD_LIFE_TIME UNLIMITED;

! r; [2 P6 W; P9 q" i