CODEWITHSUNDEEP
oracle11goracle-sqldeveloper
Caffeinated
Caffeinated

Reputation: 12484

How do you set-up the HR Database that comes with SQL Developer?

I'm stuck on this part:

enter image description here

Previous to this I successfully unlocked the HR database like so:

ALTER USER hr ACCOUNT UNLOCK;

then 

ALTER USER hr IDENTIFIED BY oracle

CREATE USER Adel identified by oracle;

grant connect, resource to Adel;

Upvotes: 0

Views: 265

Answers (1)

Jon Heller
Jon Heller

Reputation: 36902

Select "SID" instead of "Service name".

I can't tell if that's a real service, but if you installed Express Edition you should be able to connect to it with the SID xe.

Upvotes: 1

Related Questions