This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be used to create a tns…
Read Full Recipe
My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 "invalid number" after an upgrade…
Read Full Recipe
Recently encountered a issue where we had to rename a diskgroup for 11.2 RAC containing OCR and Voting Disk.At this moment we had not created database . I had done…
Read Full Recipe
Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database files. Saurabh had earlier written articles on ora-1578. http://askdba.org/weblog/2008/04/physical-corruption-ora-1578-part-1/…
Read Full Recipe
I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would…
Read Full Recipe
This article is based on Pythian's aricle DOWNLOADING FROM OTN DIRECTLY TO YOUR DATABASE SERVER. Article tell's about using lynx (text based web browser available on linux) to generate the…
Read Full Recipe