[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1249
  • 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
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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