SQL Developer

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!

Connecting using SID

Eslam_ElbyalyNov 27 2022

Hi. I am using SQL Developer Version 20.2.0.175. Oracle db XE 18C.
I am trying to connect using SID. My SID is "XE" according to the ORACLE_SID registry value.
my pluggable database is "XEPDB1".
When I try to connect to "hr" schema and set SID to "XE", it shows "invalid username/password" error. And I am pretty sure the username and pwd are correct. Actually, it connects normally when using service name "XEPDB1" instead of SID.
sys as sysdba connects either with SID or service name.
What causes the "invalid username/password" error when connecting with hr?

This post has been answered by cormaco on Nov 27 2022

Jump to Answer

Added on Nov 27 2022

#sql-developer

3 comments

2,162 views