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

admin

Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user
1 @4 @# N, \& T9 \
1 Q/ ^* o4 I/ H# @( }* ?Problem:
: T# P& a" a  I. S1 lIf your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
, \2 I+ L9 v  g0 aobtain the following message after 180 days.
Login was unsuccessful.: Problems encountered logging into TCServer:
... database
Cause: Unable to bind to server running on localhost: 1572

% G$ Y* ~( l4 Y, Y  o9 B6 |Analysis:
5 K* w5 F+ [7 u- h; F& Q, \! L% RThis issue seems to be due to the Oracle 11g changes. All the Oracle services are started
. L7 |# Q0 F( k/ pcorrectly. However, when you try to connect to the database using sqlplus you can obtain the
following error message:
+ t) c, k' G9 nORACLE_HOME=your_oracle_home
1 E& J" S9 U) u% g& i- O2 R7 F+ TORACLE_SID=your_sid
5 q4 w7 T. p# b6 ^  ]>%oracle_home%\bin\sqlplus /nolog
SQL> connect
infodba
7 v$ j! Y" F+ J5 N- qinfodba
) \! i. C! D8 h9 D, h; ^ERROR:
7 X: z' m. D3 h" ?1 ^1 BORA-28002: the password will expire within 10 days
+ X- b5 T" i) O5 h- I& T* j
+ {7 R+ {, b2 p  x7 j! [In the user tcserver.syslog file we find the error message:
! o2 b8 O( }+ pConnect failed (-28002) for 'infodba' at ***
The "infodba" Oracle user seems to be created using the default oracle profile which has an
0 q" I' l  J& h' l' ^8 ^expiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database
8 X- Y+ D2 @2 p9 V1 |# h  Nan error message, ORA-28002, is sent and the connection fails.

; z# N1 Y  o* C2 dSolution:
$ K# ^8 {1 x9 \8 p# |! y' PFind the infodba profile using SQLPLUS:
SQL> select profile from dba_users where username='INFODBA';
; Z+ f8 s1 b/ B* I# d' n2 t2 X! rList the profile caracteristics:
$ D7 c# H! G9 u" R/ l% P4 @SQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';
& z7 w0 c. r0 UCheck the PASSWORD_LIFE_TIME.
Modify the profile and specify an unlimited PASSWORD_LIFE_TIME:
- C) y0 B/ e* X8 Q8 N$ t4 U* J9 WSQL> 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
the time.
SQL> select expiry_date from dba_users where username ='INFODBA';
=> you obtain an expiration date
$ ]9 o  u+ T6 Y5 fSQL>alter user infodba identified by tempo ; ( define a temporary pwd)
SQL> alter user infodba identified by infodba ; ( specify your original infodba
2 D' ~. g- N$ t$ Kpassword)
+ E, m; q. P$ f3 x) zSQL> select expiry_date from dba_users where username ='INFODBA';
=> you have no expiration date.

1 b# a, f& {1 }
Remarks:
- S5 G. b4 k+ ?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.
Another modification can be done on the default profile:

ALTER PROFILE DEFAULT LIMIT
# K' k* P- g4 a/ O2 b; J: P FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;
# \7 T% r2 k' s/ q  ~