Solved

ora-01019 error

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

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

803 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