PLM之家精品课程培训

PLM之家精品课程培训

联系电话:18301858168   |   QQ咨询:939801026
NX二次开发培训

NX二次开发培训

UFUN/NXOpen C++和实战案例

适合初级入门或想深入了解二次开发的工程师,本培训结合ufun,NXOpen C++,大量的实例及官方内部的开发技术。
公众号二维码

关注公众号

点击扫描二维码免费在线高清教程

课程详情
Catia二次开发培训

Catia二次开发培训

市场需求大,掌握核心技术前景广阔

Catia二次开发的市场需求大,人才稀缺。掌握开发技能潜力巨大,随着经验积累将在汽车、航空等领域有所作为。
B站二维码

在线原创B站视频

点击关注工业软件传道士主页

课程详情
Teamcenter培训

Teamcenter培训

全方位培训,从基础应用到高级开发全覆盖

涵盖用户应用基础培训、管理员基础培训、管理员高级培训及二次开发培训等全方位内容,由多年经验讲师打造。
QQ群二维码

加入同行交流

点击扫描二维码加入QQ群

课程详情
×

PLM之家plmhome公众号

课程涵盖: PLM之家所有原创视频

×

关注B站视频

所有高清视频一览无余,全部在线播放学习

×

加入PLM之家QQ群

同行交流,疑问解答,更多互助

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

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

[复制链接]

2015-9-10 17:08:35 5418 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 user2 V: u& u" p. d/ U8 H! h

# F1 i: F; r5 a2 CProblem:8 |; Z( ^% I: Y% y9 X
If your Server is using Oracle 11g, the Teamcenter users may have a connection problem and
' G# D% f3 ?+ @obtain the following message after 180 days.3 D. B  P4 k" Z" O. v; H  g
Login was unsuccessful.: Problems encountered logging into TCServer:
5 X- d* K! y$ W3 Y* S( I ... database, w. u3 r& S$ n- X& @/ E! i& F, I
Cause: Unable to bind to server running on localhost: 1572$ n$ b& u/ t2 T1 x1 f
3 S: b6 d- o; B1 T2 Z
Analysis:
1 [' |( V2 g2 B3 r: X8 T* bThis issue seems to be due to the Oracle 11g changes. All the Oracle services are started# _  j# ?- }5 r5 N: ?# r# x
correctly. However, when you try to connect to the database using sqlplus you can obtain the
/ ?& Q8 P  x0 }+ y1 ^' s5 dfollowing error message:4 b& L) R8 u9 a2 ~% D9 z
ORACLE_HOME=your_oracle_home. C) Z0 _8 W; G3 i2 e& x
ORACLE_SID=your_sid
# w8 A) r9 F" O+ |2 V>%oracle_home%\bin\sqlplus /nolog
! o: h5 \% N% M1 X1 d1 C' ^3 YSQL> connect; u6 s6 r! Y5 I( U6 A
infodba
' N( [0 V1 r1 j, R. U. [infodba3 N! C4 }) C) q" I: _" t- }/ b% Y. A
ERROR:- {& w$ M# p$ c6 a, u
ORA-28002: the password will expire within 10 days3 Q$ h6 o: A- T2 \6 u6 x  c7 S
- d1 x, c) r  ^, Q6 M1 ]
In the user tcserver.syslog file we find the error message:
* |$ [& Q$ S* P% D5 NConnect failed (-28002) for 'infodba' at ***  K5 _/ W, B3 G: Q9 J
The "infodba" Oracle user seems to be created using the default oracle profile which has an% R/ d- L: O- K7 y
expiration date of 180 days. When the Teamcenter user tries to connect to the Oracle database- v* T. d9 t- t! W
an error message, ORA-28002, is sent and the connection fails.0 C" C8 F# j) [- T
9 c/ g. z3 j6 V
Solution:% E0 _3 m1 Q8 |! `) ?. U/ w! o; i
Find the infodba profile using SQLPLUS:
  ?1 q/ q" X* D# f) {SQL> select profile from dba_users where username='INFODBA';1 S. h. D+ B* Y- Y  t+ w1 E
List the profile caracteristics:
) P) \( @) z8 @SQL> select resource_name,liMit from dba_profiles where profile='DEFAULT';0 J, O+ i& y& t8 m
Check the PASSWORD_LIFE_TIME.4 B, ~. j4 [& g3 u4 V
Modify the profile and specify an unlimited PASSWORD_LIFE_TIME:" c9 @# l6 ?8 e
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;& h4 k& _. z% i" h+ x2 {; h
Change the password. It will not expire again.9 A1 i7 m3 ?/ d8 I; w; |3 a6 v
If you don't change the password, it will expire because it was created using a different profile at" u9 J% l) w# m3 ?# a7 R
the time.
9 k+ X6 H) s1 kSQL> select expiry_date from dba_users where username ='INFODBA';) K4 K& F% S& r
=> you obtain an expiration date
( V4 `7 I6 @  i, X# _( j+ GSQL>alter user infodba identified by tempo ; ( define a temporary pwd)
+ G1 k- f6 y7 z+ W- R. RSQL> alter user infodba identified by infodba ; ( specify your original infodba
: F& _% k/ l# t- s/ T7 \8 Y: s: g+ [8 Apassword)
2 t+ P7 w- Q+ {/ t6 L$ ^, MSQL> select expiry_date from dba_users where username ='INFODBA';7 o6 t7 D8 g* b4 }# p- r
=> you have no expiration date.  U; u+ s, d, `. ]2 M7 u
# X3 B# D  F5 u) E1 s+ ~* }

9 v6 I5 r) G! s3 l- t4 `Remarks:
9 ^; e' U0 C* J2 P6 YBecause we have redefined the same original infodba password, the TC_DB_CONNECT variable6 Z. g6 x. |# ^* [3 A) Z
in %TC_DATA%\tc_profilevars.bat is always alive and correct.
" k4 |4 j. L0 o6 z9 \/ m  sAnother modification can be done on the default profile:
+ Z2 g6 x) p  Q8 R  Q5 [7 D7 K! F8 J9 {, {8 }
ALTER PROFILE DEFAULT LIMIT: V% h3 f; d9 l- P1 D5 v
FAILED_LOGIN_ATTEMPTS UNLIMITED9 H0 |2 ~- |  e4 |' I3 W
PASSWORD_LIFE_TIME UNLIMITED;
+ j& ?* s7 I# \( u6 a! j' Q3 I+ T! `5 M+ L: z
上海点团信息科技有限公司,承接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二次开发专题模块培训报名开始啦

    我知道了