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 RecipeAuthor: Amit Bansal
Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions.
Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
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
kfed in 11g
While carrying out Oracle Database 11g install, I noticed that kfed is automatically created. This is in contrast to 10.2 where you had to create it using "make" command. In…
Read Full Recipe