Cause: Connections to the database have caused the current number of operating system processes associated with the Oracle Instance to exceed the PROCESSES database parameter (All process state objects are in use). Action: Increase the value of the PROCESSES initialization parameter. Solution: This is a temporary solution. If Prod is using Read more…
Hi My DBA Family, Today I want to share my Oracle Journey Secret. These are my 4 people in my life who inspired me.They are my Role Model. All are the best person. I want to thank all of them. I thought to share my Oracle journey through my blog. Read more…
The ORA-03135 error is common when 1) Server unexpectedly terminated or was forced to terminate. or 2) Server timed out the connection. Solution–: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly insqlnet.ora file. In my Case i set these 2 parameters Read more…
When we Grant the Select privilege on a V$ view we will get an ora-02030 error. As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view. We know that actual view created on the dynamic performance table that is V_$. The Read more…