Re: Shared Memory Error - shmat error, unable to attach sga

That looks like a shared memory error resulting from one of three things (in my experience, which is not on solaris)

1-your sga is too big, not leaving enough memory for the connect

2-your user memory setting in the unix kernal is too large, such that there is not a segment of memory large enought for a user session (similar to 1)

3-your have too many processes and sessions going (possibly runaways?) to allow a new session to start.

Actually, 3 is the most probable, is can be cleaned up with a reboot (if you can't identify which processesses to kill), but I have seen 1 and 2 on occasion.

In article <6g0i7k$5er$1_at_nnrp1.dejanews.com>,   jkc_at_consultant.com wrote:
>
> Hi,
>
> I am installing Oracle8 on Solaris 2.6 (Sparc 2 with 64MB RAM) and getting the
> following message:
>
> Does anyone know what causes this? Thanks. John
>
> --- Error messsages following ----------------
> Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.3.0.0 - Production
>
> SVRMGR> @crdbjunk.sql
> Connected.
> ORA-07307: sms1sg: shmat error, unable to attach sga.
> SVR4 Error: 22: Invalid argument
> Additional information: 1
> create database "junk"
> *
> ORA-01034: ORACLE not available
> Disconnected.
> SVRMGR>
>
> < The contents of /etc/system is: >
>
> * Shared memory parameters 40mb x 1024 x 1024
> set shmsys:shminfo_shmmax= 41943040
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=1
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semmsl=200
>
> ---------------
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 03 1998 - 00:00:00 CST