ORA-01017:invalid username/password;Logon denied

 错误信息:ORA-01017:invalid username/password;Logon denied

检查本地登录成功

[oralu8@lu8db dbs]$ sqlplus 

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jun 16 16:33:52 2020

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

Enter user-name: sys as sysdba
Enter password: 
ERROR:
ORA-12532: TNS:invalid argument

--"" 密码中带有“@”符号或其他特殊符号,要给密码加上双引号
Enter user-name: sys as sysdba
Enter password: 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 

remote_login_passwordfile 参数为exclusive(启用口令文件,允许远程登录)

SQL> show parameter remote_login_passwordfile

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile         string     EXCLUSIVE

查看密码文件:

SQL> select * from  V$PWFILE_USERS;

no rows selected

说明密码文件没有设成功,设密码文件:

orapwd file=orapwLU8DB entries=10 password=1254878@1020 force=y  --注意ORACLE_SID 是大写的,否则不成功

再次查看密码文件:这时有内容了,再次远程用SYS 登录,成功

 

case 2:

[oralu8@mylu8 ~]$ rman target sapr3/sapr3@ZTZ2;

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Jun 19 15:10:42 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01017: invalid username/password; logon denied

solution :

SQL> grant sysdba to sapr3;

Grant succeeded.

 



posted on 2020-06-16 16:43  InnoLeo  阅读(2179)  评论(0编辑  收藏  举报