PLM之家精品课程培训,联系电话:18301858168 QQ: 939801026

  • NX二次开培训

    NX二次开培训

    适合初级入门或想深入了解二次开发的工程师,本培训结合ufun,NXOpen C++,大量的实例及官方内部的开发技术对于老鸟也值得借鉴!.

    NX CAM二次开发培训报名 NX二次开发基础培训报名
  • PLM之家Catia CAA二次开发培训

    Catia二次开发培训

    Catia二次开发的市场大,这方面开发人才少,难度大。所以只要你掌握了开发,那么潜力巨大,随着时间的积累,你必将有所用武之地!

  • PLM之Teamcenter最佳学习方案

    Teamcenter培训

    用户应用基础培训,管理员基础培训,管理员高级培训,二次开发培训应有尽有,只要你感兴趣肯学习,专业多年经验大师级打造!

  • PLM之Tecnomatix制造领域培训

    Tecnomatix培训

    想了解制造领域数字化吗?想了解工厂,生产线设计吗?数字化双胞胎,工业4.0吗?我们的课程虚位以待!

PLM之家PLMHome-国产软件践行者

[TC问题解决方案] 88.Teamcenter 的账号infodba数据库oracle过期的处理

[复制链接]

2015-9-10 17:08:35 5365 0

admin 发表于 2015-9-10 17:08:35 |阅读模式

admin 楼主

2015-9-10 17:08:35

请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!

您需要 登录 才可以下载或查看,没有账号?注册

x
Teamcenter - Oracle 11g and the expiration date for "infodba" Oracle user
5 @. [. A$ W' [- c& q  L4 b2 k
Problem:
) H2 ]0 i8 x  ]; G2 x3 X+ @If your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
" T  n- `0 Z* {: X7 }8 sobtain the following message after 180 days., L. T: a1 V5 B2 G2 S
Login was unsuccessful.: Problems encountered logging into TCServer:3 m  A% J4 R9 h5 v0 F
... database
1 w/ W& G2 S8 w6 q/ v9 h* _Cause: Unable to bind to server running on localhost: 15720 @3 a3 [+ @! `

- v2 q# p8 X5 ]0 z* \% y1 P2 b1 MAnalysis:9 ]" z8 p' X6 x* [/ W* ]% J
This issue seems to be due to the Oracle 11g changes. All the Oracle services are started( S" B# q6 P$ N, o0 `3 o: E
correctly. However, when you try to connect to the database using sqlplus you can obtain the6 h( ?# s" Q7 t# g: ~# X
following error message:/ T/ `. z. W) C  M$ {
ORACLE_HOME=your_oracle_home
# M1 D" Z! A& V5 I( ?ORACLE_SID=your_sid
9 O* m: x; {: N6 o. r>%oracle_home%\bin\sqlplus /nolog
, h) p( A' v; q- L' J9 k4 gSQL> connect
( l' ~! A6 K& v$ s4 e& ~infodba$ G4 r7 U* u9 h( B6 u# [* z
infodba4 W6 j( n8 W( P- F9 C, m) F# T/ `7 k
ERROR:' t' Z2 d# f" X* o* p* Z! G
ORA-28002: the password will expire within 10 days" a& |& [- Z" {2 c; o
' j2 H$ T# y1 E& G6 b9 l$ S
In the user tcserver.syslog file we find the error message:  |1 T7 V- |6 Z( ^3 U1 r7 x" z* V1 ?& m
Connect failed (-28002) for 'infodba' at ***
! V: X9 C* q3 ~; D+ @" ^& eThe "infodba" Oracle user seems to be created using the default oracle profile which has an" G% O3 ]. v+ w5 c/ Y) h
expiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database
3 H9 y5 Y2 G/ S# I- San error message, ORA-28002, is sent and the connection fails./ V: u7 p  f% B2 {

4 S4 L( K6 t; mSolution:
# @( w  @6 H5 rFind the infodba profile using SQLPLUS:8 C9 I# B7 o/ @  U- n2 m4 B( y( A; w
SQL> select profile from dba_users where username='INFODBA';( c' n, S1 m$ ]  ^* j
List the profile caracteristics:, C. P  O! l( m/ G
SQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';0 d4 s: r3 N9 C( Y! x$ m
Check the PASSWORD_LIFE_TIME.
: {4 ^# n3 c& Z. VModify the profile and specify an unlimited PASSWORD_LIFE_TIME:
9 N, I: X9 ?6 {+ qSQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;- q/ E) o  n+ W0 `
Change the password. It will not expire again.
5 l! ?$ D( b$ YIf you don't change the password, it will expire because it was created using a different profile at2 ]6 }5 K5 a5 p: ^6 Q0 Z; D
the time.4 @0 _- S  H5 F1 A
SQL> select expiry_date from dba_users where username ='INFODBA';6 r9 C6 L3 s) j7 A. d/ D
=> you obtain an expiration date# t. M& h! P5 w5 M
SQL>alter user infodba identified by tempo ; ( define a temporary pwd) ; E7 Q: c7 M& ^: B* ~
SQL> alter user infodba identified by infodba ; ( specify your original infodba* S- o, V5 ~0 C; `1 ^+ V1 S( r1 o
password)4 x1 T5 H/ {/ Y8 x9 l( Q% |, y4 G  {* w
SQL> select expiry_date from dba_users where username ='INFODBA';
) P) X/ N, L6 B; }- C1 l0 G=> you have no expiration date.
$ d2 T4 I7 {% b8 [. m* G( r+ H* U
' M' m' F  g4 S# `# @1 j% B& s
% j% H0 k+ |+ \" u3 rRemarks:
5 G( O& J( ?( M) z7 j- v  b/ x( NBecause we have redefined the same original infodba password, the TC_DB_CONNECT variable
: t7 c4 @" ]# {in %TC_DATA%\tc_profilevars.bat is always alive and correct.
" s6 R! f& v4 ?: R: n" C2 L% d; `! vAnother modification can be done on the default profile:; B3 w. k) H; d$ e. O

; G, b+ K5 }! v8 G" v% c' W( UALTER PROFILE DEFAULT LIMIT
1 h4 C, B0 [7 b+ B( S FAILED_LOGIN_ATTEMPTS UNLIMITED# G$ o3 r- l. v2 ^& t1 `4 }  b
PASSWORD_LIFE_TIME UNLIMITED;) |% q" y+ C( H  a1 l" k

4 I7 [9 a5 B5 t) M0 p; U2 Y6 d9 S( O
上海点团信息科技有限公司,承接UG NX,CATIA,CREO,Solidworks 等CAx软件,Teamcenter,3D Experience等PLM软件,工业4.0数字化软件的实施\二次开发\培训相关业务,详情QQ 939801026 Tel 18301858168 网址 www.diantuankj.com/ doTeam.tech
回复

使用道具 举报

发表回复

您需要登录后才可以回帖 登录 | 注册

返回列表 本版积分规则

  • 发布新帖

  • 在线客服

  • 微信

  • 客户端

  • 返回顶部

  • x
    温馨提示

    本网站(plmhome.com)为PLM之家工业软件学习官网站

    展示的视频材料全部免费,需要高清和特殊技术支持请联系 QQ: 939801026

    PLM之家NX CAM二次开发专题模块培训报名开始啦

    我知道了