Solved

ora-01019 error

Posted on 1997-12-17
2
1,696 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now