Hi there, when I tried to use some third party software or Oracle Form Builder, I encountered with this error of ‘ORA-12524’.
Some database parameters were modified e.g. max_parallel_server but the error continued to appear.Â
Also, the server was trying to restart.Â
The error disappeared and reappeared one day later.
Any one help me to solve this issue?
Thanks in advance.
Hello Ronnya61,
Oracle connectivity libraries can not find the tnsnames.ora thus not connect to the database.Â
Please verify their KJS script for ulimit settings , default is 1024. Setting this to a lower value might limit the no. of file descriptors OS can handle.Â
This error relates to hitting max # of file descriptors. For each connection, oracle reads the tnsnames.ora file. If there's already max # of file descriptors open, then when it tries to open tnsnames.ora, you get the ORA 12154 error.Â
To prevent oracle from reading tnsnames.ora, you have to specify the entire description of the datasource and not just the datasource name in the connectÂ
string.Â
Regards,
Maddie.
The Solution is very simple you just need to check and verify KJS Script for ulimit setting and see if it adjust to lower value and you should know that the exact reason of this error is when oracle reads tnsnames.ora then this error will happen so to avoid this error we should banned Oracle from reading this so you need to specify your datasource description and take a look for this that if you find your tnsnames like this
SHStest_Oracle=(Description=(Address=Protocol=TCP)(Host=Kqahome)(Port=1521))(Connect_Data=SID=ORCl))
So you need to notice the change in that one and that should be like this as you need to specify your Shstest_Oracle so Take a look for that description
(Description=(Address=Protocol=TCP)(Host=Kqahome)(Port=1521))(Connect_Data=SID=ORCL))
So you can notice the difference and you also need to see if there use the object file and you should avoid descriptors failure due to close the file afterward
So To focus in your error you need to focus on opened file descriptors and see the number of your opened file descriptors if they near from 256Â
Hope This Solutions Helps YouÂ
