?
Solved

ora-01019 error

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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 video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

764 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