Running Oracle 8i on WindowsXP

Note: This is an old post in a blog with a lot of posts over a long span of time. The world has changed, technologies have changed, and I've changed. It's likely this is out of date, the code doesn't work, the ideas haven't aged well, or the ideas were terrible to begin with. Let me know if you think this is something that needs updating.

I installed Oracle 8i (8.1.6) on Windows XP Professional and noticed that it worked fine after I installed it, but after I rebooted the OracleOraHome8TNSListener would come up fine but the OracleServicePORTDB (my oracle instance) service would try to come up, but wouldn't come up fully. Yeah--that's super vague. In the XP Services applet, it would show up as Starting as opposed to Started. There was an ORACLE and an ORADRIM process running, though. So I was puzzled.

Hunting through google search results wasn't helpful. Finally found a post that mentioned Oracle 8i works fine under Windows XP Professional but that you have to manually start the services.

So if you switch those services to Manual startup, and then write yourself a nice batch script like this:

net start oracleorahome8tnslistener
net start oracleserviceportdb

(fill in your instance service name for the second one)--then it works fine.

Want to comment? Send an email to willkg at bluesock dot org. Include the url for the blog entry in your comment so I have some context as to what you're talking about.