I installed Oracle 8i on my computer and it set up the sample database etc. and I could log on and create queries. However, when I shutdown my computer and restarted, the database was no longer available. I created an additional database and this was working fine until I shutdown the computer again(!).
As my explanation above demonstrates I am not too familiar with the workings of Oracle and was hoping someone could tell me if there is a solution to the problem described above?
You need to restart the database. On Windows XP, this is done via the control panel "Services" option. Locate the service called "Oracle Server XXX" and click on "Start". You can set it up to start automatically whenever the computer is started.