Trying to find a way to startup the Oracle database in windows? Here’s how we do it.

Oracle Windows processes are more difficult to manage as services, but there is an easy way to startup the Oracle database in windows.

At Bobcares, we often get requests from our customers regarding oracle as part of our Server Management Services.

Today, let’s get into the details on how our Support Engineers help to startup the Oracle database in windows.

How to startup Oracle database in windows

Oracle Database on Windows is a stable, reliable, and high performing system upon which to build applications. Oracle Database is not a typical Windows process and have to start up the database unless you previously shut it down. Now let’s go through the method that our Support Engineers follow to start up the database.

• Start the database by SQL command-Line.
• Start the database from the Desktop.

1. Startup Oracle Database Using the SQL Command Line

One of the most common jobs of the database administrator is to startup or shutdown the Oracle database. We followed the below steps to start the oracle database.

1. We open the terminal session or command window.

2. After that, we use one of the following commands to start the SQL and connect it to the database.

sqlplus

Then the sqlplus command prompts with the username and password to access the local database. Sometimes we used the below command to include the username and password when accessing the local database.

sqlplus username/password

If the database running on a remote system we used the below sqlplus command.

sqlplus username/password@host_computer_name

3. After that, the SQL Command Line prompt with the Connected to message which indicates that the database is started.

4. At the SQL prompt, we enter the SQL statements.

SQL>

5. After the execution of the SQL statement, we exit from the SQL Command-Line.

SQL> EXIT

2. Starting Up the Database from the Desktop

The procedures to start up the database in windows and Linux are entirely different. We quickly start up the database from the desktop by following the below steps.

1. We log in to the Oracle Database as a user who is a member of the Administrator group.
2. After that, we click the start button and then select the database.

Oracle startup errors

Although the startup process looks quite straight-forward, often users face some errors with the process. Let’s see how our Support Engineers fixed common errors.

1. Failure in processing system parameters

Recently, some of our customers had a problem with the database startup. While starting the database, they received the below error messages.

ORA-01078:failure in processing system parameters

On checking our Support Engineers found that the error is due to the failure of INIT.ORA parameters during system startup. Here, the customer puts some comments on the initialization parameter file (pfile). As a result, it caused the system parameters error. We removed the comments from the pfile and fix the ORA-01078 error.

2. Could not open parameter file

Similarly, sometimes the customers get an error in the parameter file error when trying to connect the database.

LRM-00109:could not open parameter file 

We fix the issue by creating an appropriate parameter file and start the instance again. We found that the error is commonly associated with corruption in the init.ora file (pfile or spfile), located in $ORACLE_HOME/dbs. 

[Need help to start the oracle database in windows? – We’ll help you]

Conclusion

So far, we saw how to startup the oracle database in windows. We also saw how our Support Engineers fix the error occur during the startup of the Oracle database.