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

Pankaj kushwaha
1 min readJun 16, 2020

--

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.

--

--

Pankaj kushwaha
Pankaj kushwaha

Written by Pankaj kushwaha

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

No responses yet