前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied

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

作者头像
全栈程序员站长
发布2022-08-23 15:01:36
3200
发布2022-08-23 15:01:36
举报

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

问题背景描述:

代码语言:javascript
复制
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

解决方法:

代码语言:javascript
复制
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.cn/138637.html原文链接:https://javaforall.cn

本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。
原始发表:2022年5月6,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档