Oracle 10g Free Training : Oracle Database Startup using SQL Plus and Enterprise Manager: This tutorial explains how you can start the Database using SQL Plus and Enterprise Manager along with step by step screen shots.

Startup database through SQL Plus

Connect to an Idle instance using / as sysdba command.

Figure 15. Sqlplus Database login window

Execute STARTUP command to start the instance.

Figure 16. Sqlplus Database Startup window

Startup database through Enterprise Manager

After opening Enterprise Manager , you will see the following screen.

Figure 17. EM Database Startup window

Click on startup button in the above screen and following screen will showup.

Figure 18. EM Startup Database Login window

Click on OK after entering the required details.

You might receive following error after clicking OK Button.

RemoteOperationException ERROR: Wrong password for user

Please follow these steps to solve the error.

1. Click on START => Programs => Administrative Tools => Local Security Policy

(or also via START => Settings => Control Panel => Administrative Tools)

2. Under Local Policies on the left, select User Rights Assignment folder

3. Look at the right side of the window and scroll down to the "Logon as Batch Job" privilege and select it.

4. Either select Action from the menu bar then Security or right-click on the "Logon as a Batch Job" privilege then Security.


5. Select the Add button which evokes a Select Users/Groups box.

6. From the "Look In" field, select the local workstation/server.

7. Select the User that will be used as the EM OS (node) user.

8. Select Add then OK.

9. Verify that the "Local Policy Setting" checkbox has been checked.

Note:-This method will not work for Domain Users.

Figure 19. EM Startup Database Confirmation window

Next Page: Oracle Database Startup using SQL Plus and Enterprise Manager - Page 2