According to the certification matrix, Oracle8i is not certified or supported for Windows XP, so you should consider
installing a certified release of Oracle such as 9i or 10g.
There is not enough information provided that explains why you feel you need to reinstall Oracle each time you restart your laptop. Do you have a database created on your laptop? If so, the problem may be that your database is not starting automatically when you turn on your laptop. The database is still there, but the service may not be started and/or the database may not be opened.
If you have a database created, the next time you start your laptop check to see if the service has started. If it has, check the oradim.log file to confirm that there were no errors starting the service. Next, check the database alert log to determine whether the database has opened successfully. If the database has not opened, log into SQL*Plus via the command line:
set ORACLE_SID=<SID> sqlplus /nolog connect / as sysdba startup;
If the database for some reason is already mounted but not opened, instead of issuing the startup command, issue this command:
alter database open;
You can modify the service to automatically start and open the database each time your laptop starts up. To do this, you can re-create the service with the oradim utility (after shutting down your database). You can use a command similar to the following:
oradim –edit –sid <SID> –startmode auto
Dig deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.