Re: Shared Memory Problem - Solaris 2.4 Oracle7.1.6

david_at_wsi.com (David Flinn) wrote:
>Usually, the following additions/modifications to your Solaris
>/etc/system file, followed by a reboot, should cure any shared
>memory hassles. Note that your choice of DB_BLOCK_SIZE in
>config.ora and your DB_BLOCK_BUFFERS maintain the majority of
>your SGA requirements. These Solaris parameters define the
>MAXIMUM number required. For instance, the shmmax parameter
>I have defined below allows a subroutine call to allocate
>at the most 256MB of space in shared memory.
>
>Hope this helps ...
Except, if you'll notice, oracle runs just fine as long as I'm user oracle.
Just for the sake of discussion, I changed my system parameters to the ones you suggested and there was no change in the symptom which is that if I'm not logged in as "oracle" sqlplus behaves exactly as if oracle wasn't running. You've given me some other clues, though. Thanks a lot for your help!

--
Gerry
Gerald Skerbitz <gsker_at_med.umn.edu> U of MN Med School Admin 6-5379
Home St. Paul,Ramsey County,Minnesota, USA