I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDBA Knowledge Base  Print This    All Groups  

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.

Contribute a Documented Error

4 DBA, Databases, & Data Errors

Group: DBA, Databases, & Data


Topic: DBA & Data

Error #1: ORA-00900: invalid SQL statement
Posted By pande.dhiraj, Post #100708, KB Topic: DBA & Data




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.

Posted By Bryan Valencia, Post #102093, KB Topic: Microsoft SQL Server




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. 

Posted By Mike Prestwood, Post #102073, KB Topic: MS SQL 2008




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.

Posted By Mike Prestwood, Post #101966, KB Topic: Oracle 11g


Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech