Cloning Oracle home

When we migrate a database to new server due to out of support by vendor eg: physical server,it is good approach to clone the oracle home from source to destination and recover the database.It depends on individuals to install fresh database software or clone. Check the oracle home of the database locate to the oracleContinue reading “Cloning Oracle home”

Drop online redolog group

It is very dangerous when we deal with online redolog files in database which records the active transaction changes into it and needed for media ,block and crash recovery based on their states We have four usual states of redologs in a typical oracle database 1)active 2)inactive 3)current 4) unused active – require for instanceContinue reading “Drop online redolog group”

TNS:listener could not find available handler with matching protocol stack

Client use the user process and try to connect to the oracle database where PMON monitors and registers the incoming connections. PMON updates the service to the listener every now and then ,when a new connection connect to the database. PROCESSES is the parameter which allocates the maximum load for a connection. When the loadContinue reading “TNS:listener could not find available handler with matching protocol stack”

How to avoid ORA-00018 maximum number of sessions exceeded

Oracle doc says PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes. SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login SESSIONS specifiesContinue reading “How to avoid ORA-00018 maximum number of sessions exceeded”


Something went wrong. Please refresh the page and/or try again.

Follow My Blog

Get new content delivered directly to your inbox.

%d bloggers like this: