SQL Developer is a GUI client that should enable you to connect to pre-existing Oracle (and some third party) databases.
Oracle SQL Developer is NOT and DOES NOT come with a pre-installed database, so a "local connection" will not be possible until you install Oracle database software and create a local database.
To make a successful connection to a "remote" database you will need to know:
. Where the database is running, i.e. what server.
. What port the listener is listening on.
. What the service_name the listener has bee set up with for the database instance.
. A username and password to connect to.
Your school should have those details AND should have supplied them to you.
You can install an Oracle database on your local machine, if you so desire, from here - Oracle database download page:
Speak to your lecturerer/teacher to see if they have a preferred version they would like you to download/use.
If your goal is purely to practice writing Oracle SQL scripts then you can set up an account and use
livesql.oracle.com without installing anything.
to practice your SQL and PL/SQL writing as well as see examples of scripts others have written and posted.
You can click on "Code Library" and you'll even see a "Introduction to SQL".
I do have my school's login credentials and they work, they just don't work on my machine. When I attempt to create a connection, I get the error I posted above. And again I have gotten really no help in using this program, but I do thank you for providing me alternatives for practicing
Where is the DB you're trying to connect to? Is it on your own machine, inside a VM?
can you machine successfully ping the server where your database is running? if you're not on the same network, that could be the issue