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: aaaa wwwwww <>
Date: Mon, 18 Dec 2000 17:47:01 -0800
Message-Id: <>

Dear Indira

If U have more number of users getting connected U can reduce PGA by reducing sort_area thereby making room for many



On Mon, 18 Dec 2000 09:10:32  
 Rachel Carmichael wrote:

>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
>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
>Please see the official ORACLE-L FAQ:
>Author: Rachel Carmichael
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Mon Dec 18 2000 - 19:47:01 CST

Original text of this message