Have to reinstall Oracle8i on Windows XP each time I restart

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.

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top