admin 发表于 2014-7-20 12:27:14

43. 登录Teamcenter报错“'SOA_MaxOperationBracketTime'”

43. 登录Teamcenter报错“'SOA_MaxOperationBracketTime'”





Solution

主要是检查数据库是否OK,通过sql进行连接数据库,看是否正常。也有可能是数据库密码过期,看下面的处理







admin 发表于 2014-7-20 12:28:10

Solution

This is due to the Oracle Password having expired and needs to be reset.

Perform the following in a OS CMD window making the necessary changes for your
environment and directory structure.

--
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1

set oracle_sid=tc

%oracle_home%\bin\sqlplus /nolog

connect / as sysdba

alter user infodba identified by infodba;

select expiry_date from dba_users where username='INFODBA';

select profile from dba_users where username='INFODBA';

alter profile default limit password_life_time unlimited;

select expiry_date from dba_users where username='INFODBA';
--

Expected output in command window.
==
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1

C:\Users\<user id>>
C:\Users\<user id>>set oracle_sid=tc

C:\Users\<user id>>
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013

Copyright (c) 1982, 2010, Oracle.All rights reserved.

SQL>
SQL> connect / as sysdba
Connected.
SQL>
SQL> alter user infodba identified by infodba;

User altered.

SQL>
SQL> select expiry_date from dba_users where username='INFODBA';

EXPIRY_DA
---------
01-JUN-14

SQL>
SQL> select profile from dba_users where username='INFODBA';

PROFILE
------------------------------
DEFAULT

SQL>
SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL>
SQL> select expiry_date from dba_users where username='INFODBA';

EXPIRY_DA
---------

SQL>
SQL>


陈小七 发表于 2014-12-8 11:04:41

感谢分享

巴黎之夜1972 发表于 2016-7-12 12:21:19

怎么解决
页: [1]
查看完整版本: 43. 登录Teamcenter报错“'SOA_MaxOperationBracketTime'”