Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ORA 1013

Posted on 2001-06-12
2
Medium Priority
?
1,375 Views
Last Modified: 2008-03-03
I am executing my PL/SQL package in oracle 7.3.4. through DBMS_JOBS.  Sometimes in my test system i am getting this ORA 1013 error.  But the same package when i executed in production box this is not happening.  Can anyone suggest what is going on.  Nobody is cancelling the job, no interupt to the job.  
Looking farward to an answer.
thanks
0
Comment
Question by:sarathi_vp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
vanmeerendonk earned 0 total points
ID: 6185488
You say "sometimes"... have you looked at the difference
in differences in init.ora parameters between your test and production database?
0
 

Author Comment

by:sarathi_vp
ID: 6187425
Init.ora seems to be ok. most of the parameters are same and for some sizes are low for test.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question