Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied

大家好，又见面了，我是你们的朋友全栈君。

问题背景描述：

SQL> alter session set container=pdbwyzc；  --切换pdb
SQL> define username=eoda
SQL> define usernamepwd=foo
SQL> create user &&username identified by &&usernamepwd;
SQL> grant dba to &&username;
SQL> grant execute on dbms_stats to &&username;
SQL> grant select on V_$STATNAME to &&username;
SQL> grant select on V_$MYSTAT   to &&username;
SQL> grant select on V_$LATCH    to &&username;
SQL> grant select on V_$TIMER    to &&username;
SQL> conn &&username/&&usernamepwd  --无法连接
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> select username, account_status from dba_users;  --查看用户状态正常
USERNAME		       ACCOUNT_STATUS
------------------------------ --------------------------------
EODA			       OPEN

解决方法：

SQL> select name,pdb from v$services;  --查看service_name

NAME
----------------------------------------------------------------
PDB
------------------------------
pdbwyzc
PDBWYZC
[oracle@luo ~]$ vi /u01/oracle/12c/network/admin/tnsnames.ora 
--添加以下段落
PDBWYZC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = luo)(PORT = 1524))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdbwyzc)
    )
  )
[oracle@luo ~]$ rlwrap sqlplus / as sysdba

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

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


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

SQL> alter session set container=pdbwyzc;

Session altered.

SQL> conn eoda/foo@pdbwyzc  --成功连接
Connected.