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

admin

Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user
( ]5 ~( @9 i' ~, M$ h8 b7 ~( v
Problem:
If your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
6 X3 O2 M; i' N7 U' Dobtain the following message after 180 days.
Login was unsuccessful.: Problems encountered logging into TCServer:
& ~3 K9 L6 k+ u/ @ ... database
Cause: Unable to bind to server running on localhost: 1572
3 C& ^! T6 p1 v
8 M4 K: C/ W+ TAnalysis:
% P5 K6 _) j2 B( V% q4 f% ^  q% ]8 lThis issue seems to be due to the Oracle 11g changes. All the Oracle services are started
8 o8 F" u2 ]0 x5 u' {& G+ U1 F7 ^& ^7 ncorrectly. However, when you try to connect to the database using sqlplus you can obtain the
following error message:
ORACLE_HOME=your_oracle_home
& z( I7 N7 |% F3 s! \1 r9 Q$ s2 _ORACLE_SID=your_sid
/ b  c; `. u, \& n>%oracle_home%\bin\sqlplus /nolog
SQL> connect
/ a. b* g2 q! H) v0 Ninfodba
infodba
ERROR:
* G& r! j$ o* u8 b: `ORA-28002: the password will expire within 10 days

In the user tcserver.syslog file we find the error message:
Connect failed (-28002) for 'infodba' at ***
The "infodba" Oracle user seems to be created using the default oracle profile which has an
: x( E0 U  y  i$ pexpiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database
$ m- T  [) L; San error message, ORA-28002, is sent and the connection fails.
3 n) q+ _1 A0 M) m; e& E
Solution:
Find the infodba profile using SQLPLUS:
, J. i+ o( s$ aSQL> 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.
Modify the profile and specify an unlimited PASSWORD_LIFE_TIME:
% B' W* c& Q# `  i+ t- L2 F/ t9 nSQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Change 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
, _7 p) d- \# M/ W& g: cthe time.
SQL> select expiry_date from dba_users where username ='INFODBA';
=> 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';
=> you have no expiration date.
: m) f% x3 f$ B0 \/ F

Remarks:
' U8 X- T2 D- IBecause we have redefined the same original infodba password, the TC_DB_CONNECT variable
" y! d; n# {5 b" Pin %TC_DATA%\tc_profilevars.bat is always alive and correct.
Another modification can be done on the default profile:

ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
9 Z* r) ]( f+ E+ v& v PASSWORD_LIFE_TIME UNLIMITED;
$ d& _) ^3 {1 p) N9 |
3 h! G, E8 t; V& B3 J# X