首页 > 其他分享 >启动weblogic报ORA-28001解决方式

启动weblogic报ORA-28001解决方式

时间:2023-09-25 16:56:09浏览次数:42  
标签:LIFE WM6 28001 用户 weblogic ORA

Weblogic一个月不用,启动报如下错误(采用oracle数据库):

注:数据源配置:datasource.name.1=WM6_DS

<jta-data-source>jdbc/WM6_DS</jta-data-source>

<Sep 25, 2023 2:56:12 PM CST> <Notice> <WebLogicServer> <WL-000365> <Server state changed to STANDBY.>
<Sep 25, 2023 2:56:12 PM CST> <Notice> <WebLogicServer> <WL-000365> <Server state changed to STARTING.>
<Sep 25, 2023 2:56:12 PM CST> <Notice> <Log Management> <WL-170036> <The Logging monitoring service timer has started to check for logged message counts every 30 seconds.>
<Sep 25, 2023 2:56:12 PM CST> <Notice> <Security> <WL-090171> <Loading the identity certificate and private key stored under the alias DemoIdentity from the jks keystore file C:\Weblogic12.2.1.3\user_projects\domains\jzmd\security\DemoIdentity.jks.>
<Sep 25, 2023 2:56:12 PM CST> <Notice> <Security> <WL-090169> <Loading trusted certificates from the jks keystore file C:\WEBLOG~1.3\wlserver\server\lib\DemoTrust.jks.>
<Sep 25, 2023 2:56:12 PM CST> <Notice> <Security> <WL-090169> <Loading trusted certificates from the jks keystore file C:\PROGRA~1\Java\JDK18~1.0_2\jre\lib\security\cacerts.>
<Sep 25, 2023 2:56:13 PM CST> <Warning> <JDBC> <WL-001129> <Received exception while creating connection for pool "WM6_DS": ORA-28001: the password has expired

 

<Sep 25, 2023 2:56:13 PM CST> <Error> <Deployer> <WL-149231> <Unable to set the activation state to true for the application "WM6_DS".
weblogic.application.ModuleException: javax.transaction.SystemException: Failed to call registerLoggingResourceTransactions() weblogic.transaction.loggingresource.LoggingResourceException: weblogic.transaction.loggingresource.LoggingResourceException: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'WM6_DS'. The DBMS driver exception was: ORA-28001: the password has expired

 来源:https://blog.csdn.net/tkw951211/article/details/125365557

前言
登录数据库时,出现ORA-28001:the password has expired错误,原因是Oracle11g中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”所致,处理方式如下:

解决方式
首先登录数据库的dba用户
查看用户的proifle是哪个:
SELECT username,PROFILE FROM dba_users;

查看用户密码的有效期:
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

将密码有效期设为永久:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

修改后,还没有被提示ORA-28001警告的用户账号不会再碰到同样的提示;而已经被提示的用户账号必须再修改一次密码:
alter user imes_intf3 identified by imesintf3 account unlock;
ALTER USER jzmdDB identified by jzmdDB account unlock;
如上:用户:imes_intf3 密码:imesintf3

标签:LIFE,WM6,28001,用户,weblogic,ORA
From: https://www.cnblogs.com/long2050/p/17728292.html

相关文章

  • Oracle索引的维护
    https://www.cnblogs.com/learnspace/p/9238361.htmlhttps://blog.csdn.net/tianlesoftware/article/details/5680706https://blog.csdn.net/bless2015/article/details/84072703......
  • Oracle RMAN 保留策略
      OracleRAMN支持备份文件保留策略,方便DBA根据需要删除过期的备份文件,提供了时间窗口、备份次数2钟策略。   时间窗口:rman确保保留数据库能恢复到最近N天的备份文件CONFIGURERETENTIONPOLICY TORECOVERYWINDOWTONDAYS   备份次数:rman确保保留数据库......
  • Oracle process/session/cursor/tx/tm的简单学习
    Oracleprocess/session/cursor/tx/tm的简单学习Oracle的部署模式Oracle安装时有专用模式和共享模式的区别共享模式(Sharedmode):在共享模式下,会话可以同时读取数据库的数据,多个会话可以并发地进行读取操作。这意味着多个会话可以共享相同的数据快照,并且彼此之间不会阻塞。......
  • mysql数据库和oracle的优缺点
    MySQL和Oracle是两个广泛使用的关系型数据库管理系统(RDBMS),每种数据库都有其自身的优势和不足。MySQL的优点开源性:MySQL是一个开源的软件,用户可以免费使用和修改。这降低了成本,并有利于那些财务资源有限的公司。此外,开源社区的贡献也使得MySQL能够持续优化和更新。易用性:MySQL具有高......
  • Oracle中start with connect by prior 使用方法
    一、语法{CONNECTBY[NOCYCLE]condition[ANDcondition]...[STARTWITHcondition]|STARTWITHconditionCONNECTBY[NOCYCLE]condition[ANDcondition]...}解释:startwith:指定起始节点的条件connectby:指定父子行的条件关系prior:查询父行的限......
  • Centos7.9+Oracle11g 单机文件系统安装注意事项
    数据库软件(上传至/root目录)p13390677_112040_Linux-x86-64_1of7p13390677_112040_Linux-x86-64_2of7其他软件包(上传至/root目录)compat-libstdc++-33-3.2.3-72.el7.x86_64.rpmpdksh-5.2.14-37.el5_8.1.x86_64.rpm安装软件包#安装compat包rpm-ivhcompat-libstdc++-33-3.2.3-72.el7......
  • Mybatis 批量插入报ORA-00933: SQL 命令未正确结束
    MySQL中,批量插入数据到表,会在一定程度提高效率。insertintotable(column1,column2)values(value1,value2),(value1,value2)对于List<Map<String,Object>>类型的参数,使用mybatis实现上面语句需要用到动态SQL–foreach。<insertid="batchInsert"> insertinto${table_na......
  • 10. (单选题)下面哪个Linux发行版不使用RPM软件包 • A. Fedora • B. OpenEuler • C
    10.(单选题)下面哪个Linux发行版不使用RPM软件包A.FedoraB.OpenEulerC.DebianD.OpenSUSE正确答案:(单选题)负责openEuler版本发布的组织是A.SC(SecurityCommittee)B.TC(TechnicalCommittee)C.理事会D.ReleaseManagementSIG正确答案:2.(单选题)openEuler社......
  • invalid storage class for function
     编译中莫名奇妙来了几处invalidstorageclassforfunction, 而具体对应的函数都是没有问题的,不应该编译出错,直到搜到了这篇https://www.cnblogs.com/lamblabs/p/8473858.html说是少了括号导致,仔细一查新加的代码部分,果真一个while循环的括号对应到了函数结束的括号,......
  • Ubuntu20.04 ping Temporary failure in name resolution问题
    解决步骤vi/etc/systemd/resolved.conf将DNS的注释取消掉并改成8.8.8.8即可参考:https://blog.csdn.net/weixin_43354181/article/details/105352203......