Oracle Ride
  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
    • Registration
    • Feedback
  • Contact Me

ERRORS

Database ERRORS

ORA-12520: TNS listener could not find available handler for requested type of server

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…

By Ahmad, 1 year1 year ago
Database ERRORS

[INS-35950] Installer has detected an invalid entry in the central inventory

[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…

By Ahmad, 2 years2 years ago
Database ERRORS

ORA-00020: maximum number of processes exceeded

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…

By Ahmad, 2 years2 years ago
Database ERRORS

ORA-03135: connection lost contact

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…

By Ahmad, 2 years2 years ago

Posts navigation

1 2 Next
Oracle ACE
Oracle ACE Associate
Awarded Top 60 Oracle Blogs
Recent Posts
  • ORA-12520: TNS listener could not find available handler for requested type of server
  • Oracle GoldenGate 21c(21.3.0) is out for use!
  • Oracle 21c has only CDB-PDB Architecture
Categories
  • Career (1)
  • Cloud (7)
  • Data Guard (3)
  • Database (104)
  • ERRORS (6)
  • GoldenGate (11)
  • Interview Questions (44)
  • Oracle12c (7)
  • Oracle19c (7)
  • Oracle20c (2)
  • Oracle21c (5)
  • Performance Tuning (4)
  • Personal (2)
  • RAC (6)

Riaz Ahmad Ansari is an Oracle Consultant, Speaker, Blogger, YouTuber & Mentor.

He is famous for Ahmad’s nickname in the IT industry.

He has many years of experience as a production Oracle DBA managing all operating system based Oracle Databases.

He started working with Oracle Database starting from Oracle 9i to 10g/11g/12c18c/19c.

He has hands-on experience in real-world Production environments.

He is skilled with Oracle technologies such as Core DBA work, Data Guard, RMAN, Backup & Recovery, RAC, Cloud Control, and Performance Tuning.

  • Email
    ahmad@oracleride.com
  • Phone
    +91 9648108988
Follow Me
  • whatsapp
  • linkedin
  • facebook
  • twitter
  • youtube

Copyright ©️ 2020 OracleRide. All Rights Reserved.


  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
  • Contact Me
Developed and Maintained by Demunix