The Oracle database server is down frequently ORA-1902 ORA-27300

Problems:
You should be a system configuration problem

Solution:
Take a look at /etc/security/limits.conf, oracle user’s nofile parameter is set, this is the 11g oracle official document recommended:
oracle soft nofile 1024
oracle hard nofile 65536
Of course, if your system is more special, you can change the larger point.
You should be a system configuration problem

Solution:
Take a look at /etc/security/limits.conf, oracle user’s nofile parameter is set, this is the 11g oracle official document recommended:
oracle soft nofile 1024
oracle hard nofile 65536
Of course, if your system is higher version like 12c or 18c special, you can change the larger point.

Thanks for reading this post.

Pankaj K.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Pankaj kushwaha

Pankaj kushwaha

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS