?
Solved

Help with Error ORA-01019

Posted on 2003-03-21
7
Medium Priority
?
19,382 Views
Last Modified: 2013-12-11
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
Comment
Question by:illingd
[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
  • 5
  • 2
7 Comments
 
LVL 4

Expert Comment

by:bmoshier
ID: 8183733
What version of Oracle?
0
 
LVL 4

Expert Comment

by:bmoshier
ID: 8183797
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
 

Author Comment

by:illingd
ID: 8193929
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 4

Accepted Solution

by:
bmoshier earned 60 total points
ID: 8225102
> 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
 

Author Comment

by:illingd
ID: 8282710
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
 
LVL 4

Expert Comment

by:bmoshier
ID: 8285577
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
 
LVL 4

Expert Comment

by:bmoshier
ID: 8296043
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

770 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