Solved

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

Posted on 2010-09-18
7
1,228 Views
Last Modified: 2013-12-21
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
Comment
Question by:raydekock
  • 5
7 Comments
 
LVL 10

Assisted Solution

by:Bawer
Bawer earned 100 total points
ID: 33707481
what is the physical memory on the server, and what is the memory allocation in Pfile,
0
 

Author Comment

by:raydekock
ID: 33707685
Hi Bawer,
How can I determine these values from the command line please?
0
 

Author Comment

by:raydekock
ID: 33707744
The memory on the server is 32GB. Got this from prtconf -v
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:raydekock
ID: 33707774
SGA target in pfile is sga_target=2080374784, pga_aggregate_target=943718400
Is there anything else you require?
0
 

Author Comment

by:raydekock
ID: 33707786
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
 
LVL 9

Accepted Solution

by:
fcontrepois earned 200 total points
ID: 33741275
0
 

Author Closing Comment

by:raydekock
ID: 33771004
Uninstalled the Client 10.2 and installed client 9.2 and it worked fine.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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…
This video shows how to recover a database from a user managed backup
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now