Start with Oracle concepts. What is an instance, what are controlfiles, redologs, undotablespace, temptablespace, archivelogs.

You might consider Oracle Developer as free query tool

Basic troubleshooting tool for administration: sqlplus, couldn't get Enterprise Manager working most of the time.