Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1268
  • Last Modified:

I get an ORA-01019 error on Solaris with a new installation of Sage Line 500. How do I solve this error?

This is a new installation of Oracle 11g and Sage L500. When Sage L500 tries to connect to the database,
It gets the error :
ORA-01019: unable to allocate memory in the user side:cannot establish connection to "sys"
Raymond De Kock
Raymond De Kock
  • 5
2 Solutions
what is the physical memory on the server, and what is the memory allocation in Pfile,
Raymond De KockManaging DirectorAuthor Commented:
Hi Bawer,
How can I determine these values from the command line please?
Raymond De KockManaging DirectorAuthor Commented:
The memory on the server is 32GB. Got this from prtconf -v
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Raymond De KockManaging DirectorAuthor Commented:
SGA target in pfile is sga_target=2080374784, pga_aggregate_target=943718400
Is there anything else you require?
Raymond De KockManaging DirectorAuthor Commented:
The following is from the SGA in Oracle:
SQL> select * from v$sga;    

NAME                      VALUE
-------------------- ----------
Fixed Size              2149632
Variable Size         620761856
Database Buffers     1426063360
Redo Buffers           22716416
Raymond De KockManaging DirectorAuthor Commented:
Uninstalled the Client 10.2 and installed client 9.2 and it worked fine.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now