Oracle Database 11gXE System Management On Microsoft Windows

On Microsoft Windows operating system, Oracle Database XE 11g can be set to run (operate) automatically or manually when the computer is turned on. If the given setting is automated then Oracle will be started automatically, but the computer will be booting longer than the manual setting.

Services Manager

The service manager is a feature of the Microsoft Windows operating system to perform the start-stop process of an existing app. In addition to setting the start-stop process, the services manager can also make settings in the application whether it runs automatically or not when the computer was first run. Setting Oracle Database XE can be done by utilizing services manager. Here are the steps to open the services manager page:

1. Click start (windows logo in the lower left corner), type services.msc in the search field of the program and press keypad Enter

2. On the Services manager page look for OracleServiceXE and OracleXETNSListener service names, make sure both are Started.

3. In Figure 1.11, OracleServiceXE service and OracleXETNSListener service are in Started status with Automatic startup type, which means that the service is automatically executed when the computer first turns on and is now running. If we want the startup type is not automatic, double click on the service name (eg service OracleServiceXE), change startup type to Manual then click OK.

The result is the startup type of service OracleServiceXE changed to Manual.

4. To start and stop the status of a service do right click on the service name (eg OracleServiceXE) and then click the Start option to run the service or click Stop to stop the service.

5. Make sure the OracleXETNSListener service is in Started state with startup type in both Automatic and Manual conditions.

  

Command Prompt Console

On Microsoft Windows operating system, apart from the services manager, the start and stop process of Oracle Database XE can also be done from the command prompt console (cmd) environment. Here are the steps to perform Oracle start-stop service settings from the command prompt (cmd):

1. Run a command prompt (cmd) by typing cmd after starting (logo window) then Run. Run the service listener by typing the net start OraclexETNSListener command terminated by pressing Enter. If the confirmation appears The OracleXETNSListener service was started successfully means that the service listener is in Started condition.

2. To run OracleServiceXE service type the net start command OracleServiceXE terminated by pressing Enter. If the confirmation appears The OracleServiceXE service was started successfully means the database is in Started state and ready to use.

3. Make a check by logging in using the System user then do a simple query, eg select count (*) from tab; such as illustration 1.18

In Figure 1.18 two commands are executed ie command to login and command to perform simple query. The result value 174 means there are 174 tables owned by the user System, if this figure appears meaning Oracle Database already in running condition.

Troubleshooting

The installation process does not always run smoothly, sometimes there is a problem with Oracle Database that we install after the installation process is complete. One of the problems that may be found is the service condition of OracleServiceXE and OracleXETNSListener in the services manager is already in Started state but the login is not successful. Here is one way of handling the problems that occur after the installation process is complete.

Eg found error message as in figure below

What can be done is to do a manual startup via SQL prompt by using a user who has SYSDBA privileges. The first step is to login to the database as SYSDBA by typing the sqlplus / as sysdba command line at the command prompt. After the SQL prompt appears type the shutdown immediate command, wait until the confirmation message appears ORACLE instance shut down.

Type the startup command to run the Oracle database again, wait until the Database confirmation message is opened. If a confirmation message appears Database opened means that the database is ready to be reused, but if it does not appear the database is not ready to be used and needs to be repaired in another way.

Thank You, Bobsis