Category Archives: Database Troubleshoot

database Troubleshoot

Resolved : ORA 00911 invalid character inline query C# or Java

Generally the following code we use to write as inline query OracleConnection conn = new OracleConnection(-myConnectionString-); conn.Open(); OracleCommand command = new OracleCommand(“select userid from usermaster;”, conn); var v = command.ExecuteReader(); OracleCommand command = new OracleCommand(“select userid from \”usermaster\”;”, conn); var … Continue reading

Steps to Call Stored Procedure with Parameters from C# .Net

Many Confusions while calling procedure from your Generally it’s because less practice of using oracle with .Net code. Following is the example. Hope it’ll be useful to you. Procedure : create or replace procedure ProcTest(param1 in varchar, param2 in … Continue reading

Hashbytes in SQL Server returns different value for different data type

If you are using Hashbytes ‘SHA1’ or ‘MD5’ algorithm for your password field make sure you are not changing database in insert procedure and select procedure otherwise you will not be able to find any error and also won’t be … Continue reading

Resolved : ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

You may be facing oracle is not accessible or not available from application or console. First and foremost try is to shutdown database and restart it. When you go for sqlplus startup C:\>sqlplus SQL*Plus: Release Copyright (c) 1982, 2005, … Continue reading

Cannot resolve the collation conflict between “Latin1_General_CI_AI” and “SQL_Latin1_General_CP1_CI_AS”

Collation is nothing but the set of rules that ensure proper use of characters for Language or Alphabet. If the fields you are comparing use different collation, you will get this error. select * from table1 a inner join table2 … Continue reading

The database is not accessible (ObjectExplorer) : Error Resolved

If you can access other databased from Sql Server Management Studio and have issue with one or two databases and getting error of The database is not accessible (ObjectExplorer) try out following steps Caution : This is generally happens when … Continue reading

MYSQL Error 1133: Can't find any matching row in the user table

Today while assigning right new user in mysql from command line. I got error 1133:can’t find any matching row in the user table GRANT ALL PRIVILEGES ON `mydb` . * TO ‘newuser’@’localhost’; After some troubleshoot I found that my ‘newuser’ … Continue reading