0

enter image description here

I'm running Oracle sql developer 20.4 for the first time and I can't make a connection due to the error shown in the picture. Any idea how to solve this ? all suggested solutions are on Windows.

Yahyaotaif
  • 1,943
  • 1
  • 15
  • 17
  • 2
    most likely answer is because you do not actually have a database named XE running on your machine - sql developer is simply a client for talking to the database – thatjeffsmith Mar 01 '21 at 17:08
  • [Possible duplicate](https://stackoverflow.com/q/49707627/266304); except you'll *have* to use a VM (or a cloud solution), as Oracle DB doesn't run natively on macOS any more. – Alex Poole Mar 01 '21 at 17:30
  • Thank you all for the answers, I guess I will follow @AlexPoole solution as after research it seems the only one. – Yahyaotaif Mar 01 '21 at 17:51
  • 2
    some options here to help you get started https://www.thatjeffsmith.com/archive/2021/02/im-a-student-studying-oracle-and-i-need-a-database-help/ – thatjeffsmith Mar 01 '21 at 18:35
  • @thatjeffsmith thank you for the info ! After installing the oracle sql vm on virtual box, the icons look tiny, Do you have a solution for this issue ? I'm running Big sur – Yahyaotaif Mar 01 '21 at 19:41
  • 1
    You can resize the vm window, but I don't really use it and just connect from your Mac directly – thatjeffsmith Mar 01 '21 at 19:43
  • @thatjeffsmith are you suggesting that I keep the virtual box open and use the oracle sql developer I have on my mac to talk to each other ? but how ? – Yahyaotaif Mar 01 '21 at 19:55
  • 1
    that's exactly what i'm suggesting, make your connection properties user: HR password: oracle server: localhost port:1521 service: orcl – thatjeffsmith Mar 01 '21 at 19:59
  • 1
    @thatjeffsmith it worked, thank you again ! – Yahyaotaif Mar 01 '21 at 20:01

1 Answers1

1

As @thatjeffsmith said, if you want to learn and test something, search for "Unlocking HR schema". You will find a detailed instructions on how to unlock and connect to HR schema and then you can test anything you want.

best of luck to you.

S59
  • 35
  • 5