• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 19474
  • Last Modified:

Help with Error ORA-01019

We have got a problem on a Dynix system with ORA-01019 started happening
The Oracle documentation is not very helpful
Is this an appropriate place to look for help?
0
illingd
Asked:
illingd
  • 5
  • 2
1 Solution
 
bmoshierCommented:
What version of Oracle?
0
 
bmoshierCommented:
What is the full text of the ORA-01019 error?  I've found it can be:

ORA-01019 error retrieving text

and also

ORA-01019 unable to allocate memory in the user side

------

Are you using Perl when you get this problem?

One of the messages you can get when installing Perl to work with Oracle is:

Deleting ORA_NLS =
$(ORACLE_HOME)/ocommon/nls/admin/data because it is not already set in the
environment and it can cause ORA-01019 errors.

If this doesn't occur you can get ORA-01019 errors when using a Dynix system.

----

Since I don't know your version of Oracle and going back aways:


There was a bug 384042 pre Oracle 7.3.3 to do with oracle home settings / environment variables.

I would check NLS settings (ORA_NLS, ORA_NLS32 etc) are the same.

Do you have more than one Oracle home?
How are you connecting from the client side - ODBC / OCI / SqlPlus ?


----

Overall an ORA-01019 means that the client (ev_getdata) cannot communicate with the Oracle server. It is not caused by the usual types of communication problems though. A number of things can cause it. The most common cause is a version of SQL*Net that is incompatible with the import programs.  To be more specfic, we'll need more specific from you.  Remember you are our five senses.  If you don't tell us, we don't know.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram
0
 
illingdAuthor Commented:
OK - here are some details of our environment ...

(1) Operating system

'uname -a' gives this:

DYNIX/ptx numa02 4.0 V4.4.8 i386


(2) Oracle

starting SQL*Plus gives this:

SQL*Plus: Release 3.3.4.0.0 - Production on Mon Mar 24 09:15:29 2003

Oracle7 Server Release 7.3.4.0.0 - Production
With the distributed and parallel query options
PL/SQL Release 2.3.4.0.0 - Production


Both client and server are on the same machine and connexion is local, so I don't think SQL*Net is involved.


(3) Application

We are not using SQL*Plus or PL/SQL directly. We are working in an environment called OpenTool, where Cobol programs formerly hosted on a Honeywell mainframe have been ported on to a Unix system. Our programs are written/maintained as Honywell Cobol source, which is passed through a translator and then compiled as MicroFocus Cobol, all within the OpenTool environment. The OpenTool maps Cobol files on to Oracle tables and connects the application to the Oracle (as I understand it) using code built into the Cobol runtime system. This makes life a little complicated!


(4) Perl

As far as I know, Perl is not part of the equation.


(5) Failure scenario

We made a fairly trivial change to a Cobol batch program -- we are satisfied the code looks good, as Cobol source; it translates and compiles without errors of warnings. This is a program that was working fine before the change, and which still works fine when the change is backed out. The program starts to run OK and has made successful access, both read and write, to some files (i.e. tables) before it fails, so I don't think we have a connexions issue as such.
Then the program crashed, with the error message:

     ORA-01019: unable to allocate memory in the user side

(this message is coming out of some C code routine in the OpenTool environment).

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
bmoshierCommented:
> This is a program that was working fine before the
> change, and which still works fine when the change is
> backed out.

Sorry for the delay, I've been out of town (3 trips this week).

Obviously, the change is the problem OR causes a problem to occur in another area (e.g. finds a bug in Oracle).  Fact is when you remove the changes it works this is a clear sign the changes create or find the problem.

What does the change do?  Some thoughts:

Could it be causing the program to use more memory?

Could it be having Oracle send back more data (e.g. more columns and/or more rows)?

Could the *NEW* size of the program plus memory usage at run time exceed some operating system limit (e.g. 64K, 256K, etc.)?

---

Can you break this change into components you could apply individually?

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram
0
 
illingdAuthor Commented:
Looks like we have a memory usage problem.
Never properly got to the bottom of it, but it seems as though the change, although small, was just enough to push us into memory limits.
We worked around by removing some redundant code.
Thanks for suggestions
0
 
bmoshierCommented:
I'm glad my suggestions helped!


You can close (and award points/grade) by choosing the answer (see above) that helped you.  You'll have a link on the right hand side of EACH comment.  Find the comment you found most helpful and click on it.

This will insure two things:

1)  Those who read this issue in the future will know you found your solution and which comment helped you the most.

2)  I'll get more expert points.

Again thank you for the opportunity to help you.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram
0
 
bmoshierCommented:
Do you need additional help?

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

P.S.  If the above comment solves your problem, you can close the issue by clicking on the "Accept Answer" link on the right hand side of the acceptable answer.  This will help others determine the solution when they read the issue.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now