|
|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user4 [" R" ~3 b$ f! Z( x, V! _
" B+ i' o) _! x1 ~5 n+ [
Problem:6 `/ n$ {, J8 b
If your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
% r4 j% {1 H( |" v9 [obtain the following message after 180 days.. r8 V `: K f2 O K# D
Login was unsuccessful.: Problems encountered logging into TCServer:
' m7 H. W' c0 ]6 B6 d8 b& R8 D ... database6 M- P5 `" o7 v7 y0 s/ o' H3 u
Cause: Unable to bind to server running on localhost: 1572
) X/ U3 s- f8 D
6 M4 {" [" d" M2 k; p1 x8 u* yAnalysis:
$ K y5 u0 ~; U1 O( Y9 m$ |6 a: QThis issue seems to be due to the Oracle 11g changes. All the Oracle services are started
1 q7 Y; O+ @1 i1 [/ J+ `correctly. However, when you try to connect to the database using sqlplus you can obtain the- e6 j* ]& M1 t; n. @ ?
following error message:
v+ w- d: a8 I* Y; UORACLE_HOME=your_oracle_home
+ s' y6 I, x9 UORACLE_SID=your_sid& D# W6 F* U& t; L2 K6 r4 r/ j% ]
>%oracle_home%\bin\sqlplus /nolog) e. {/ U* i7 a( W! h2 f
SQL> connect
5 O+ Q C+ T) h( E( l( P: Binfodba
; i! ~$ S4 h' Uinfodba: K: t! f; C2 H5 R8 ?! N/ H
ERROR:
1 j# a: c |* P0 n" y3 m5 f# F: ^ORA-28002: the password will expire within 10 days: ~# k& ?0 Y4 F* U6 Z b1 t
+ x+ W* Y* x1 \- x" ^( n* i @
In the user tcserver.syslog file we find the error message:
; o: G) d1 |+ X& X; U/ a& ^0 j9 W ~; RConnect failed (-28002) for 'infodba' at ***# e: q& w3 b$ u
The "infodba" Oracle user seems to be created using the default oracle profile which has an" V" x. \* O. b ~- a9 F/ z2 K, N
expiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database, E) F* H& }. {" U
an error message, ORA-28002, is sent and the connection fails.* V8 H* b8 U( R! N7 u% u
1 G" w2 F% H% g, d
Solution:$ n3 R; Q- T* A5 g0 U8 U1 j
Find the infodba profile using SQLPLUS:2 o+ F7 P( |- X) I! F
SQL> select profile from dba_users where username='INFODBA';
* K5 Z9 e5 z: J9 f2 f" OList the profile caracteristics:1 U: A6 l& M" Z" O4 b
SQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';
3 T+ \- A4 f6 r' o8 {Check the PASSWORD_LIFE_TIME.$ y. M5 y+ h0 A u9 e' M
Modify the profile and specify an unlimited PASSWORD_LIFE_TIME:+ j: G( _5 N2 @) Y+ A
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;5 c! t7 {) @3 K% j, s1 i
Change the password. It will not expire again.4 m0 s0 |% a, r2 N1 M
If you don't change the password, it will expire because it was created using a different profile at4 V( Z' {8 L8 t
the time.6 B. F- c8 ]- P
SQL> select expiry_date from dba_users where username ='INFODBA';
7 C( m! q4 t' p/ j/ }=> you obtain an expiration date
9 ~6 S' ]- g' R" m+ X5 x4 b3 |, q: K" bSQL>alter user infodba identified by tempo ; ( define a temporary pwd)
8 X9 ]9 c& ^; Z! Y! |9 ]0 zSQL> alter user infodba identified by infodba ; ( specify your original infodba) _6 O. u+ T. T/ c3 k- ?% l k: y- c
password): o4 K5 X; S; n9 G% q
SQL> select expiry_date from dba_users where username ='INFODBA';' l2 E4 y) S# g1 [. g& Y1 {
=> you have no expiration date.
. Z9 A, h7 A2 ^- W' j7 B3 N {
5 _7 S% F6 P; y% m3 O
5 z6 `+ r, b V; w& [0 `. D9 iRemarks:
1 Z; M/ b7 b& ]( O0 K$ E1 eBecause we have redefined the same original infodba password, the TC_DB_CONNECT variable
" _, o( N6 `% z6 fin %TC_DATA%\tc_profilevars.bat is always alive and correct.
( A. k3 q- p' K0 WAnother modification can be done on the default profile:
, x' T' {9 _* O3 B3 _4 _8 u. z
, }' a7 B$ `" a3 D4 L3 GALTER PROFILE DEFAULT LIMIT
- W7 b k9 ~) X FAILED_LOGIN_ATTEMPTS UNLIMITED
9 Z2 e" j' @( P) g6 Z1 g5 ? PASSWORD_LIFE_TIME UNLIMITED;$ {/ O r/ u! L- I
. |3 l7 e$ R) R7 F6 c+ Q+ W
|
|