Skip to Main Content

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!

connect as sysdba to pdb

bb_asJun 23 2021

Hello,
OS: Windows 10
DB: Oracle Database 18c Express Edition Release 18.0.0.0.0
I want to connect as sysdba to my pluggable database XEPDB1.
1st case:
sqlplus sys/password@localhost/xepdb1 as sysdba
show con_name
=> XEPDB1
So far, so good.
2nd case, WITHOUT password:
sqlplus sys@localhost/xepdb1 as sysdba
show con_name
=> CDB$ROOT
I am confused. The only difference is, that I specify a password in case 1 , but no password in case 2. In both cases I want to connect to "@localhost/xepdb1", but in case 2 I get connected to the container-database. Why?

Comments
Post Details
Added on Jun 23 2021
4 comments
12,158 views