Error: ORA-12514 when I try to connect

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