Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied
来源:互联网 发布:羡慕别人知乎 编辑:程序博客网 时间:2024/06/05 23:55
问题背景描述:
SQL> alter session set container=pdbwyzc; --切换pdbSQL> define username=eodaSQL> define usernamepwd=fooSQL> 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 deniedSQL> select username, account_status from dba_users; --查看用户状态正常USERNAME ACCOUNT_STATUS------------------------------ --------------------------------EODA OPEN
解决方法:
SQL> select name,pdb from v$services; --查看service_nameNAME----------------------------------------------------------------PDB------------------------------pdbwyzcPDBWYZC[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 sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 3 14:28:31 2016Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analyticsand Real Application Testing optionsSQL> alter session set container=pdbwyzc;Session altered.SQL> conn eoda/foo@pdbwyzc --成功连接Connected.
0 0
- Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username /password;logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017: invalid username/password; logon denied
- ORA-01017:invalid username/password; logon denied
- ORA-01017 invalid username/password;logon denied
- ORA-01017: invalid username/password; logon denied
- oracle12c 可行的解决办法:ORA-01017: invalid username/password; logon denied
- ORA-0107 invalid username/password;logon denied
- 解决方法:ORA-01017: invalid username/password; logon denied错误
- Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied
- java.sql.SQLException: ORA-01017: invalid username/password; logon denied
- ORA-01017 invalid username/password;logon denied (密码丢失解决方案)
- 【数据结构与算法】Project 1: Linear List // 测试心得
- 背个小包遍地跑----01背包问题(C++)
- c++新手上路
- jQuery 居中弹出 iframe 插件编写
- 四、Linux--管道
- Oracle12c(PDB中) ORA-01017: invalid username/password; logon denied
- Oracle,day2,基础
- SVN 被锁定解决办法!!!
- 实现在eclipse中编译ns-3的详细步骤
- 开发自定义View
- Unreal Engine 4 C++ UMG自定义控件
- 五、Linux--信号量
- linux编程下signal()函数
- 【Java学习之代码学习】 Prog11_三数排序问题