« Can I have Your Library Version, Please? | Main | Oracle AS: Upgrading the JDK (UPDATED) »

Oracle XE: Fixing the StopDB script on Windows

As a laptop computer user surely I give Oracle XE a try.

Most intriguing is the deinstallation process: no software remains on my disk. No manual work. Great!

I also start and stop server software on demand to fit this into my working habit. Here comes the point where Oracle XE is still lacking a complete solution. Instead of just stopping the database instance, it should also stop the TNS listener. But this could be fixed easily:

  • In your favorite text editor open the StartDB.bat and StopDB.bat

  • Copy the TNSListener line from StartDB.bat to StopDB.bat

  • Replace start by stop

  • Save the StopDB.bat and verify the changes by stopping and starting your XE instance from the Start Menu

Example:
net stop OracleXETNSListener
net stop OracleServiceXE

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on January 26, 2006 10:05 AM.

The previous post in this blog was Can I have Your Library Version, Please?.

The next post in this blog is Oracle AS: Upgrading the JDK (UPDATED).

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle