Raymond De Kock
asked on
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"
It gets the error :
ORA-01019: unable to allocate memory in the user side:cannot establish connection to "sys"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The memory on the server is 32GB. Got this from prtconf -v
ASKER
SGA target in pfile is sga_target=2080374784, pga_aggregate_target=94371 8400
Is there anything else you require?
Is there anything else you require?
ASKER
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
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 2149632
Variable Size 620761856
Database Buffers 1426063360
Redo Buffers 22716416
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Uninstalled the Client 10.2 and installed client 9.2 and it worked fine.
ASKER
How can I determine these values from the command line please?