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

x
?
Solved

ora-01019 error

Posted on 1997-12-17
2
Medium Priority
?
1,745 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 400 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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 …
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 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.

604 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