Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: error connecting from sqlplus

RE: error connecting from sqlplus

From: Rachel Carmichael <>
Date: Mon, 18 Dec 2000 17:08:51 -0000
Message-Id: <>

A shared memory segment message has nothing to do with a lack of semaphores - there are several messages for those problems :)

Indira, try making your SGA smaller (lower the number of db_block_buffers, lower the shared_pool, the number of processes) until you can start the database.

Also... have your system administrator check the SHMMAX size in the kernel parameters... you might need to increase it if you really need the SGA to be the size it is.

For many flavors of Unix, if your SGA is larger than a SINGLE shared memory segment, the database won't start. Some (AIX is one I think, I've never worked with it) will allocate an additional memory segment if needed. But I don't think Digital Unix does. I know Solaris doesn't.


>From: David Barbour <>
>To: Multiple recipients of list ORACLE-L <>
>Subject: RE: error connecting from sqlplus
>Date: Mon, 18 Dec 2000 06:40:43 -0800
>I'm not at all familiar with Digital Unix, but it appears the error you're
>getting has to do with a lack of available shared memory segments. My
>is you have to increase the number of available semaphores. In Solaris,
>it's the semmns parameter in /etc/system. There should be a formula for
>figuring out the number of semaphores you need for the instance(s) on the
>box in your install documents, or you can check on OTN.
>Hope this helps.
>David A. Barbour
>Oracle DBA - ConnectSouth
>-----Original Message-----
>Sent: Monday, December 18, 2000 4:51 AM
>To: Multiple recipients of list ORACLE-L
>Dear List,
>try to connect using sqlplus, returned error
>Enter user-name: system
>Enter password:
>ERROR: ORA-01034: ORACLE not available
>ORA-07320: smsget: shmat error when trying to attach sga.
>Digital Unix Error: 13: Permission denied
>database already running
>-rwxrwxrwx 1 ora73 dba 784 Dec 18 17:17 sgadefdb733.dbf
>user group the same as oracle, oracle binaries already set
>correctly, anything else to check ?? please inform Thanks

Get your FREE download of MSN Explorer at Received on Mon Dec 18 2000 - 11:08:51 CST

Original text of this message