环境
[oracle@pub19-node2 ~]$ sqlplus -v SQL*Plus: Release 19.0.0.0.0 - Production Version 19.5.1.0.0
问题描述
当使用orapwd修改密码文件之后,普通用户通过tnsnames.ora文件登陆数据库没有问题,当涉及sysdba使用
密码文件时则在输入正确密码之后,会报ORA-12514,在orapwd之前是没有这个问题的。
[oracle@pub19-node2 dbs]$ orapwd file=+datadg dbuniquename=orcl format=12 sys=password sysdg=password force=y
[oracle@pub19-node2 ~]$ sqlplus system@czhprimary SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 3 08:09:45 2020 Version 19.5.1.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Enter password: Last Successful login time: Sun May 03 2020 07:56:27 +08:00 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.1.0.0 SYSTEM@czhprimary >
[oracle@pub19-node2 ~]$ sqlplus sys@czhprimary as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 3