Oracle12c(PDB中) ORA-01017: invalid username_password; logon denied

问题背景描述：

view plaincopy

1. SQL> alter session set container=pdbwyzc； –切换pdb
2. SQL> define username=eoda
3. SQL> define usernamepwd=foo
4. SQL> create user &&username identified by &&usernamepwd;
5. SQL> grant dba to &&username;
6. SQL> grant execute on dbms_stats to &&username;
7. SQL> grant select on V_$STATNAME to &&username;
8. SQL> grant select on V_$MYSTAT to &&username;
9. SQL> grant select on V_$LATCH to &&username;
10. SQL> grant select on V_$TIMER to &&username;
11. SQL> conn &&username/&&usernamepwd –无法连接
12. ERROR:
13. ORA-01017: invalid username/password; logon denied

14.

14. SQL> select username, account_status from dba_users; –查看用户状态正常
15. USERNAME ACCOUNT_STATUS
16. —————————— ——————————–
17. EODA OPEN

**解决方法：

**

view plaincopy

1. SQL> select name,pdb from v$services; –查看service_name

2.

2. NAME
3. —————————————————————-
4. PDB
5. ——————————
6. pdbwyzc
7. PDBWYZC
8. [oracle@luo ~]$ vi /u01/oracle/12c/network/admin/tnsnames.ora
9. –添加以下段落
10. PDBWYZC =
11. (DESCRIPTION =
12. (ADDRESS = (PROTOCOL = TCP)(HOST = luo)(PORT = 1524))
13. (CONNECT_DATA =
14. (SERVER = DEDICATED)
15. (SERVICE_NAME = pdbwyzc)
16. )
17. )
18. [oracle@luo ~]$ rlwrap sqlplus / as sysdba

20.

19. SQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 3 14:28:31 2016

22.

20. Copyright (c) 1982, 2014, Oracle. All rights reserved.

24. 25.

21. Connected to:
22. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
23. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
24. and Real Application Testing options

30.

25. SQL> alter session set container=pdbwyzc;

32.

26. Session altered.

34.

27. SQL> conn eoda/foo@pdbwyzc –成功连接
28. Connected.