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

admin

Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user
8 W5 C0 ]/ M7 W
; ]; c% J" y, F. x, C* pProblem:
If your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
: t! z7 o5 |1 u6 ^7 w/ R% q8 Cobtain the following message after 180 days.
- `3 g+ `! n' I3 B1 C, x- cLogin was unsuccessful.: Problems encountered logging into TCServer:
% ~$ K* c* A5 ?" X* z3 i ... database
- L$ ^  r# r' `! r; xCause: Unable to bind to server running on localhost: 1572
% Y5 E6 S5 K0 U" g
- p4 G# x: z5 f# R5 u" M0 ]Analysis:
This issue seems to be due to the Oracle 11g changes. All the Oracle services are started
  T) q8 Z- o8 Y" E( a" B: kcorrectly. However, when you try to connect to the database using sqlplus you can obtain the
following error message:
5 y5 z  W; l# M* F2 DORACLE_HOME=your_oracle_home
9 }, x( C3 G. N$ |) yORACLE_SID=your_sid
0 |+ Z6 T& S+ y$ u, I8 Z4 V>%oracle_home%\bin\sqlplus /nolog
SQL> connect
+ M: N0 |( L+ l" A7 ginfodba
infodba
. _, H" z2 Y* M( [6 b2 @ERROR:
ORA-28002: the password will expire within 10 days

In the user tcserver.syslog file we find the error message:
8 a. C: v* c! h( T7 ]Connect failed (-28002) for 'infodba' at ***
The "infodba" Oracle user seems to be created using the default oracle profile which has an
9 f: f! f( r3 c# mexpiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database
3 u2 k7 R$ S5 m: f1 Z- Aan error message, ORA-28002, is sent and the connection fails.

Solution:
Find the infodba profile using SQLPLUS:
SQL> select profile from dba_users where username='INFODBA';
List the profile caracteristics:
SQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';
Check the PASSWORD_LIFE_TIME.
8 t' ~5 a8 v) U6 Q5 {% SModify the profile and specify an unlimited PASSWORD_LIFE_TIME:
0 a5 e  {0 e  h# o! TSQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
& J/ T; b' d; ^" s+ {6 C' @2 PChange the password. It will not expire again.
If you don't change the password, it will expire because it was created using a different profile at
* t( e8 A6 C+ P6 ?the time.
SQL> select expiry_date from dba_users where username ='INFODBA';
4 Y7 X2 o$ q8 f; P+ F+ k=> you obtain an expiration date
SQL>alter user infodba identified by tempo ; ( define a temporary pwd)
$ y- N3 u# @' D5 }$ Z& c& |SQL> alter user infodba identified by infodba ; ( specify your original infodba
password)
; Y( s+ ]  G$ |+ _6 aSQL> select expiry_date from dba_users where username ='INFODBA';
=> you have no expiration date.
9 O0 ?: U; Q  e7 n

Remarks:
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.
# a; j& l9 e5 b" n  k% \  PAnother modification can be done on the default profile:
2 p( V: g, K: M: \2 \, C  x; K
8 @) j. r- F# G( Y3 B; X1 ^ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;

1 x8 e9 N( |; _( n+ s  R+ S3 q+ [