Database Administration (MOSC)

MOSC Banner

connect to a pdb from a cdb

Hello,

cannot connect to a pdb from a cdb

SQL> show con_name


CON_NAME

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

CDB$ROOT

SQL>

SQL>

SQL> select count (*) from tableowner.tablename@pdbname;

select count (*) from tableowner.tablename@pdbname

                             *

ERROR at line 1:

ORA-01017: invalid username/password; logon denied

ORA-02063: preceding line from pdbname





however when connected on the pdb it's OK

SQL> alter session set container=pdbname;


Session altered.


SQL> select count (*) from tableowner.tablename@pdbname;


 COUNT(*)

----------

 143486696

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center