Solved

ora-01019 error

Posted on 1997-12-17
2
1,720 Views
Last Modified: 2012-06-27
After an sqlnet upgrade, we are getting ora_01019 errors
with our powerbuilder legacy applications when we try to
connect to a remote database.
0
Comment
Question by:hoppin
[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 3

Accepted Solution

by:
poncejua earned 100 total points
ID: 1081291
Hi hoppin,

The ORA-01019 implies that the user side memory allocator returned an error. In order to solve it you must increase the processes heap size or switch to the // old set of
calls.
 
This is a VERY confusing error to troubleshoot.  Either there really is a shortage of memory on the client side, (not usually), or the ORACLE_HOME and client Required Support Files, (RSF), for a specific version , (i.e. 7.1 or 7.2, etc...), have gotten corrupted.  This can also happen if the client has multiple Oracle homes.  
 
During installation, the Oracle Installer renames duplicate RSF files found in the path, for example:
-client has a networked Oracle_Home in the search path.
-client installs a new oracle product to a local oracle_home.
 
During the above installation, the installer detects that there is a version of the RSF available in the path, and renames components, (i.e. CORE3WIN.DLL -> CORE3WIN.OLD), to prevent conflict. This renaming is done in what the installer considers to be the duplicate, or old home.  In this example the
networked home is the old or duplicate.  Now the networked Oracle home directory is broken, at least for any applications using that particular RSF in question from that Oracle home directory.
 
The solution is painful. Either completely rip out ALL Oracle home directories and start over from scratch, or at a minimum, remove the local Oracle home directories, (and any references to them from the registry and/or any INI files).  Look in the ORACLE_HOME\BIN for the networked Oracle home directory
and re-name any/all files.  You should at this point use the installer to remove and re-install the RSF, (best to do all versions), thus causing the Oracle home directory to be re-validated.

I hope this helps you.

Best Regards,

Juan Manuel Ponce Martinez
DBA - Bridas S.A.P.I.C.
Buenos Aires - Argentina
0
 

Author Comment

by:hoppin
ID: 1081292
Nice job.  The only thing that would improve it is to
know if Powerbuilder has a take on this.  Nice work.  Thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

688 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