topic Memory windows question in Operating System - HP-UX

Memory windows question

Gerry Tully — Thu, 09 Jan 2003 16:33:11 GMT

I recently installed memory windows on an HPUX 11.0 system running Oracle 32 bit. When logging in and starting the databases as the user Oracle, everything is fine. When logged in as any other user, which we do to start one of the 4 instances, we get HPUX error 22, we get 'unable to attach shared memory segment'. What do I need to do? Thanks

Re: Memory windows question

James Murtagh — Thu, 09 Jan 2003 17:04:22 GMT

Hi Gerry,

Did you go with putting a seperate entry for each instance in the /etc/service.window file? Also, what is the value of the kernel tunable max_mem_window?

A user (process) can either create a unique window using one of the ids defined in services.window or can join an existing window. Sounds like you are trying to create a new instance using the id of a currently running window.

Regards,

James.

Re: Memory windows question

Gerry Tully — Thu, 09 Jan 2003 17:51:47 GMT

Jim, Thanks for the response. Yes, I did put the 4 instances in the services.window file. I changed the max_mem_window param to 6. Just wondering why as Oracle things are ok because none of the entries in the services.window file are called Oracle?

Re: Memory windows question

Steven Gillard_2 — Thu, 09 Jan 2003 17:54:43 GMT

You may need to run your sqlplus session as follows:

$ setmemwindow -i sqlplus ...

Regards,
Steve

Re: Memory windows question

James Murtagh — Thu, 09 Jan 2003 18:03:28 GMT

Hi Gerry,

HPUX errno 22 is EINVAL, or invalid argument. Doing a "man shmget" and looking at the EINVAL codes shows a few entries but it comes down to:

1)Key already exists
2)Size of segment is greater than system imposed maximum

If you are starting an instance in a unique window, ensure the instance SGA is no greater than 1GB or shmmax, whatever is less.

Regards,

James.

Re: Memory windows question

James Murtagh — Thu, 09 Jan 2003 19:03:58 GMT

Hi Gerry,

Maybe I didn't read the first post right...you are starting three of the instances as Oracle and one as another user? You can start this as Oracle but are just having problems as the other user?

In this case, you could probably work out what is wrong by checking the error code for the particular call, shmget/shmat etc, but you could always start this outside a window instead? As the other three are in windows I suspect your virtual address space issues are already resolved so this may be a quick solution.

Regards,

James.

Re: Memory windows question

Gerry Tully — Thu, 09 Jan 2003 20:15:37 GMT

I think we have the issue resolved using a combination of the info you guys supplied. Thanks much.