登陆物理standby时报错ORA-28032

最新推荐文章于 2024-09-19 18:46:03 发布

cuiyu3003

最新推荐文章于 2024-09-19 18:46:03 发布

阅读量965

点赞数

文章标签：数据库

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

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博客 ” ，链接：http://blog.itpub.net/16976507/viewspace-1263419/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16976507/viewspace-1263419/