0 Comments

Important Technical Links Powered by DBsGuru 5 (3)

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 525 total views,  1 views today

0 Comments

Solving ORA-00742 Log read detects lost write in Oracle 5 (1)

Solving ORA-00742 Log read detects lost write in thread 1 sequence 149 block 38233 In this post we will see how to solve ORA-00742: Log read detects lost write-in thread 1 sequence, You can encounter this error if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like […]

 520 total views

0 Comments

Starting and stopping an Oracle ASM instance for Noncluster Databases 0 (0)

Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called Oracle Instance.  The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and   background processes. […]

 383 total views

2 Comments

What is Cluster and How can we find if a Database is running on Cluster 4.6 (5)

What is Cluster and How can we find if a Database is running on Cluster Oracle Real Application Cluster provides its users to run a single database into multiple servers. These multiple servers act as a single system. It provides fast recovery at the time of any site failure. To avoid the outage and provide […]

 760 total views

3 Comments

How to increase Processes, Sessions and Transactions Initialization Parameters 4.8 (11)

Demonstration on how to increase processes, sessions and transactions parameter in Oracle. Whenever our processes utilized 100% then its NOT allowed any new sessions / connections to DB’s instances and we get below error : ORA-00020: No more process state objects availableORA-20 errors will not be written to the alert log forthe ORA-20 errors. Cause: All […]

 1,374 total views,  1 views today

Spread the love