ORA-01426 After Upgrade to 10g
Oracle seems to have a tendency to make small changes to database code which impacts application in a big way. Sad part is, these changes are not always documented properly.…
Read Full Recipe
11G:SYSASM role
Starting from Oracle 11g ASM, new privilege has been created for Administering Oracle ASM instances. This is called SYSASM role. You can continue using SYSDBA role to connect to ASM…
Read Full Recipe
New ASM Background Processes in 11G
Few hours back I installed Oracle Database 11g(Though still DB is yet to be created), so I started playing with the ASM instance. First thing I did was to check…
Read Full Recipe
11.1.0.6 ASM installation on Solaris fails -II
Some time back, I had written about CSS service not starting in my post 11.1.0.6 ASM installation on Solaris fails -I After doing some research, I came across Metalink Document…
Read Full Recipe
ORA- 4031 – A Case Study
Today I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not…
Read Full Recipe
Can ASM DiskGroup Be Renamed?
This was actually a question on Oracle forum which I had replied to. Basically the Poster, wanted to know if he could rename the ASM Diskgroup name by renaming/editing ASM…
Read Full Recipe