Database Wisdom: Oracle

XE

Windows

Coming Soon!

*nix

Coming Soon!

Non-XE

Windows

To start and stop an non-Oracle XE database (by which I mean Standard Edition, Standard Edition One and Enterprise Edition), you need to start or stop the windows service. When you create an Oracle database, on Windows, Oracle creates several services for you. In 10g, you will have at least the database server, the database listener, the console (for OEM) and iSQLPlus. The only two services that you really need are the the server and the listener.

Because these are services, you can use the NET command to start and stop them. If you used the default Oracle database name of ORCL, you can cut and paste this text and put it in a DOS batch file:

net start OracleServiceORCL
net start OracleOraDb10g_home1TNSListener
net start OracleOraDb10g_home1iSQL*Plus
net start OracleDBConsoleorcl

If you did not use ORCL as the service name, replace the ORCL text in the above commands with the name of your database.

The Listener and iSQLPlus are both global on the machine, that is, you only need a single instance to service the entire box. The database service (the first command above) and the console (the last command above) are per database instance. That means that if you are running more than 1 database on your box, you will need more than one start and stop for each OracleService and OracleDBConsole.

You can stop Oracle with these commands:

net stop OracleOraDb10g_home1TNSListener
net stop OracleDBConsoleorcl
net stop OracleOraDb10g_home1iSQL*Plus
net stop OracleServiceORCL

*nix

Coming Soon!