Hi Friends, its been quite long time that we talked about technical articles….(its just because i got busy with new responsibilities). From now i will make sure, i will post some helpful posts regularly

Today, lets discuss about an error that occurs on windows box when you try to install patchset…

As we all know whether it is windows or unix machine, we need to stop all services before installing patchset software. Recently i was doing this in one of my prod env (windows box) and all of a sudden during installation, i got below error

“Error in writing to file D:\Oracle\product\10.2.0.2.0\bin\oraevrus10.dll”

I ignored this error thinking nothing will happen…but its my biggest mistake (thats the reason DBA should never think, he should know…and that knowing comes only by practise or testing in test machines)

After i ignore that error, everything went fine and when i try to run any command like sqlplus, dbca etc..i got below error message in a popup window

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

This will happen because of the error i ignored during installation and that error will occur because one of oracle service will not be stopped sometimes (thats why i hate oracle administration on windows box )

I fighted alot with that and finally came with an idea of re-installing the patchset again. But to do this, we need to reboot the server. I am having 3 more databases of other versions on the same machine, but i can’t proceed further without downtime which was even confirmed by oracle support.

I informed the client about this and to my luck i got downtime (please do remember, this might not happen always. so we need to very careful and whenever you are doing the same activity in future, make client aware that you may require downtime)

After reboot, i started OUI and reinstalled the files and it went successful….

Note: After installing patchset, don’t forget to upgrade your database