not able to connect to oracle

dnat · Post by **dnat** » Mon Feb 07, 2011 4:31 am

Hi,

I have a sequencer which calls another sequencer which in turn another sequencer. It has been running fine for a while without any issues. Now suddenly i am getting the ORA-12541 error when the job inside the sequencer is running.

I tried connecting the db through sqlplus and it just connects, so i restarted the job sequencer several times and all the time it failed.

The sequencer calls 5 jobs, the wierd part is that sometimes it fails in the first job, sometimes in the second. All the jobs connect to the db.

Could there be any specific reason for this.

Thanks!!

chulett · Post by **chulett** » Mon Feb 07, 2011 8:15 am

Talk to your DBA and what might have changed or be going on that would cause your listener problem.