Hello Gobi21,
I suppose you still have CMOD 8.5.0.X and that you are working with Oracle, on a Unix server.
Does the SQLPLUS command works from the Unix command line as the CMOD Instance owner user?
Is the tnsnames.ora still correctly configured?
I'm asking such "trivial" questions, because maybe something changed in your environment, and the best way is to test and check every configuration files, and check all the connectivity.
Not only tnsping, but really also if sqlplus works, and enter in the database from the CMOD server.
It is worthless to test with TOAD, because TOAD is not on your server, and you cannot simply say, it works with TOAD so my server must work!!
That's maybe not your case, but I had some customers who told me that looking at me with serious eyes!! :-D
Sincerely yours,
Alessandro