Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't connect to PDB user

DBA092012Aug 16 2016 — edited Sep 7 2016

Hello everybody.

I can successfully connect to PDB user tms with SQL developer but i cant do this with sqlplus please advise

[oracle@test-node1 scripts_uis]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 16 12:46:03 2016

Connected to:

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> alter session set container=PDB1;

Session altered.

SQL> show con_name

CON_NAME

------------------------------

PDB1

SQL> select count(*) from dba_users where username='TMS';

COUNT(*)

----------

SQL> conn tms/tms

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL>

This post has been answered by DBA092012 on Aug 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2016

Added on Aug 16 2016

#database-key-features, #multitenant

11 comments

9,173 views