大家好，又见面了，我是你们的朋友全栈君。
问题背景描述：
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.
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/138637.html原文链接：https://javaforall.net
