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.