问题背景描述：
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.