Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection. Action: Run “lsnrctl services” to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections. TNS listener could not find available handler Read more…
[INS-35950] Installer has detected an invalid entry in the central inventory Cause -: On existing server 11g database installed. I clean the things from OS. That’s why 11g entry was there in central inventory. If ORACLE_BASE is not set, and you are not using OFA, then the path to oraInventory Read more…
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…
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…