DBA Errors Library

These Errors are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the DBA sub-topics.

4 DBA, Databases, & Data Errors

Group: DBA, Databases, & Data


Topic: DBA & Data

Error #1: ORA-00900: invalid SQL statement




Topic: Microsoft SQL Server

Error #2: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

Error: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.

The Solution: Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account".  Started the service, and bingo.





Topic: MS SQL 2008

Error #3: MS SQL 2008 Saving Changes Not Permitted

In MS SQL 2008, if you get a Saving Changes Not Permitted error, you can easily fix this error in Management Studio. Uncheck the Prevent saving changes that require table re-creation option. 





Topic: Oracle 11g

Error #4: nmefwmi.exe

Error: nmefwmi.exe has stopped working

Solution: This error is caused by a defect in 11g limited to Windows Vista. The nmefwimi.exe is an Oracle 11g service used by dbconsole (OaracleDBConsoleorcl). You can stop this service to stop this error then set it's Startup Type to Manual to prevent it from returning. Doing so will not affect your database. When you need to use dbconsole, start the service manually.

Also, check with Oracle for an update that fixes this issue.


www.prestwood.com For service: 916-726-5675
or support@prestwood.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 5/12/2021