• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1259
  • 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"
0
Raymond De Kock
Asked:
Raymond De Kock
  • 5
2 Solutions
 
BawerCommented:
what is the physical memory on the server, and what is the memory allocation in Pfile,
0
 
Raymond De KockManaging DirectorAuthor Commented:
Hi Bawer,
How can I determine these values from the command line please?
0
 
Raymond De KockManaging DirectorAuthor Commented:
The memory on the server is 32GB. Got this from prtconf -v
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Raymond De KockManaging DirectorAuthor Commented:
SGA target in pfile is sga_target=2080374784, pga_aggregate_target=943718400
Is there anything else you require?
0
 
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
0
 
fcontrepoisCommented:
0
 
Raymond De KockManaging DirectorAuthor Commented:
Uninstalled the Client 10.2 and installed client 9.2 and it worked fine.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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