从windows客户端sqlplus连接Oracle 12c PDB报错ORA-65162: The password has expired
看到The password has expired,感觉对应的错误码应该是ora-28001,此处却是出现的ORA-65162,感觉一头雾水
于是立即到mos(support.oracle.com)搜索一把,搜索结果只有2个,还是在Oracle Zero Data Loss Recovery Appliance Administrator's Guide这里
http://docs.oracle.com/cd/E55822_01/AMAGD/amagd_errors.htm#AMAGD1442
再想一想,ora-65开头的,之前从来没遇到过,再从如上网址中,搜索ora-65000
ora-65XXX是针对PDB的错误码
C:\Users\Administrator>sqlplus system/aaaaaa@to12c_pdb_pn1
SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 2月 13 09:28:27 2016
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-65162: The password has expired.
请输入用户名:
看到The password has expired,感觉对应的错误码应该是ora-28001,此处却是出现的ORA-65162,感觉一头雾水
于是立即到mos(support.oracle.com)搜索一把,搜索结果只有2个,还是在Oracle Zero Data Loss Recovery Appliance Administrator's Guide这里
http://docs.oracle.com/cd/E55822_01/AMAGD/amagd_errors.htm#AMAGD1442
ORA-65162: The password has expired.
Cause: The user's account expired and the password needs to be changed by connecting to the root of the multitenant container database
Action: Change the password or contact the DBA.
再想一想,ora-65开头的,之前从来没遇到过,再从如上网址中,搜索ora-65000
ORA-65000: missing or invalid pluggable database name
Cause: A valid pluggable database name was not present where required.
Action: Reissue the statement with a valid pluggable database name.
心里也就明白了一点,推测如下:
ora-65XXX是针对PDB的错误码