28 December 2009

The application failed to initialize properly (0xc0000142) when you try to open the Windows Command Prompt.

You might encounter the following error message when you try to open the Windows Command Prompt:
 
The application failed to initialize properly (0xc0000142)
According to my investigations done by using Google search, this error might be caused by Microsoft ISA Server or bugs inside the Command Prompt itself.
 
If you are very sure that your problem is not related to Microsoft ISA Server (please check from "Add/ Remove Programs", see whether you got installed this Microsoft ISA Server or not), then you can try to use the following hotfix. What I can tell you is, this fix resolved my problem:
 

10 December 2009

The procedure entry point could not be located in the dynamic link library oranl10.dll

You might encounter the following error when you trying to connect to the Oracle database by using SQL PLUS:

The procedure entry point could not be located in the dynamic link library oranl10.dll


The solution is as below:

a). Go to the Oracle Universal Installer.

b). Click the "Installed Products...".

c). System will prompt you a new screen called "Inventory".

d). Now, click the "Environment" tab.

e). In the "Home Name", please move up the original service name by using the arrow.

f). After that, click the "Apply" button and then "Close" button.

g). Exit the Oracle Universal Installer.

h). Try to connect to the Oracle database by using SQL PLUS now.

The request failed with HTTP status 400: Bad Request.

This problem occurred because of the URL consists of special character or space.

If the URL is hard-coded in your web.config, then you have to open your web.config and make sure the URL is OK.

05 December 2009

Wrap in Oracle

You are going to deploy a new package to your client. But you do not want to disclose the codes in that package, so what you need to do?

a). Go to the Windows command prompt.

b). Type the following command:

wrap iname=<input file> oname=<output file> edebug=wrap_new_sql

How to quick search in Package_Body?

You might have hundreds of packages in your Oracle database.

Now, you need to check a syntax in those package bodies. But you are not sure which packages are related.

Thus, you will need this command:

Select * From user_source Where text Like '%What_You_Want_To_Find%';