ORA-12012

I am getting this error :
ORA-12012: error on auto execute of job 131 ORA-12541

What is this error and what  would be step by step procedure to resolve this ?


LVL 1
amolghadgeAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The first error is just telling you a database job has failed.  The ORA-12541 is the important error code.  That one means you are trying to connect to a remote database and Oracle cannot locate a LISETNER on that server.

You can read the exact error message and resolution from the docs:
http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10744/net12500.htm

First:  You need to figure out what job number 131 is executing:
select what from dba_jobs where job=131;

Then you need to figure out what remote database the previous 'what' is trying to connect to and make sure the TNSNAMES.ora file is properly configured for that system.

If you aren't familiar with setting up Oracle networking, we'll need more information to get you up and going.  Let's hold off on that for now and concentrate on 'what' is running.  Please post back when you get the 'what' and 'where' information.
0
 
sivachirravuriTeam Lead Commented:
The job is failing because it doesnt have enough memory, how much memory does your machine have ?
0
 
slightwv (䄆 Netminder) Commented:
If sivachirravuri can post back what makes him think it's a memory problem given those 2 error message, I have no problem with a split.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.