on 07-02-2008 9:19 PM
Hi all,
I'm doing an install of a Solaris 10.2, Oracle 10.2 system. During the Create Database phase, I am getting;
ORA-27102: out of memory SVR4 Error: 22: Invalid argument
Doing some research, and reading through the details here:
Link: [http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html]
I think my issue is my SHM parameters, reinforced by the repeated entry in the Oracle Alert log:
+WARNING: EINVAL creating segment of size 0x0000000085000000+*
+fix shm parameters in /etc/system or equivalent+*
when the create fails.
I am not familar with Solaris' new project mechanism, although from what I have read, it seems to be set up properly.
Here are my server details:
# prtconf | grep Mem
Memory size: 8192 Megabytes
# prctl -n project.max-shm-memory -i project 200
project: 200: QBI
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 10.0EB - deny -
system 16.0EB max deny -
And as for Oracle:
shared_pool_size = 1522029035
shared_pool_reserved_size = 152202903
pga_aggregate_target = 2705829396
sga_max_size = 3439329280
db_cache_size = 1159641169
During the course of troubleshooting, I have:
1 - Increased the amount of SHM allocated in the project. I have tried 16GB, 8 GB, 10 GB, 11GB etc, to no effect, so I reset it to 10GB (as seen above) and focused my efforts elsewhere.
2. SHARED_POOL_SIZE - I have decreased this by roughly 75% from the original value, again to no effect.
3. PGA and SGA sizes - I have increased these from the original values by an increment of 25%
Following the advice from the referenced blog (which does a good job of explaining the logic behind the actions) I have determined that the Alert log error message is telling me that it is lacking
2231369728
(Hex conversion value, which I think I need to read as 2GB, not 100% sure)
I've increased my project allocation, and the PGA sizes, did I just not do it enough?
Any advice?
Thanks for any input,
Troy Shane
Hi,
check following sap note
Note 546006 - Problems with Oracle due to operating system errors
Note 743328 - Composite SAP note: ORA-27102
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.