ITPub博客

首页 > 数据库 > Oracle > 登陆物理standby时报错ORA-28032

登陆物理standby时报错ORA-28032

原创 Oracle 作者:panpong 时间:2014-09-04 10:30:40 0 删除 编辑

6.登陆物理standby时Error code: ORA-28032

       使用非sys用户登陆物理standby时,报错ORA-28032,如下

[oracle@db2 ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 13 17:24:05 2014

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

 

ERROR:

ORA-28032: Your password has expired and the database is set to read-only

 

从11gR2文档error message中查询错误号竟然没有,无奈从网上查找如下:

Error code: ORA-28032

Description: Your password has expired and the database is set to read-only

Cause:
Your password expired and needs to be changed before your login request can be processed. Because the database is currently open in read-only mode, the password change operation cannot be performed on this database.

Action:
Log in to the primary database to change your password, then retry your login request at the standby database.

按照提示,首先有该用户登陆主库一次,然后再在备库登陆,就没有问题了;如果之前操作没有成功,则按照action操作,登陆主库并修改密码,然后再次登陆备库;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/16976507/viewspace-1263419/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: EVA6400诊断与排错
请登录后发表评论 登录
全部评论
数据库工程师,熟悉Oracle,Postgresql,MySQL等主流关系型数据库运维,调优,一直活跃在运维一线。了解Python,Django,简单自动化运维系统开发。

注册时间:2009-03-06

  • 博文量
    142
  • 访问量
    392343