RE: error connecting from sqlplus

Dear Indira

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

Rao

--

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 

>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.

>

>Rachel

>

>>From: David Barbour <dbarbour_at_connectsouth.com>

>>Reply-To: ORACLE-L_at_fatcity.com

>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

>>Subject: RE: error connecting from sqlplus

>>Date: Mon, 18 Dec 2000 06:40:43 -0800

>>

>>Indira,

>>

>>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 

>>guess

>>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

>>512-681-9438

>>dbarbour_at_connectsouth.com

>>

>>-----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

>>

>>Romi

>>

>>

>

>_________________________________________________________________

>Get your FREE download of MSN Explorer at http://explorer.msn.com

>

>-- 

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>-- 

>Author: Rachel Carmichael

>  INET: carmichr_at_hotmail.com

>

>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: ListGuru_at_fatcity.com (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).