Q

Have to reinstall Oracle8i on Windows XP each time I restart

Whenever I install Oracle8i on my computer when in the Windows XP OS, it works well, but only for that time until I shut down my computer, after which it disconnects and I have to re-install it again, every time I start the computer. How should I configure it to remain connected throughout?

I am a student in Kenya studying computer-based information systems. Whenever I install Oracle8i on my computer when in the Windows XP OS, it works well, but only for that time until I shut down my computer, after which it disconnects and I have to re-install it again, every time I start the computer. How should I configure it to remain connected throughout? This problem does not occur with Windows 2000.

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
This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close