[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

Title:	Oracle
Notice:	For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010
Moderator:	EPS::VANDENHEUVEL

Created:	Fri Aug 10 1990
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1574
Total number of notes:	4428

1526.0. "Oracle fail to start" by MSAM00::FOOSZEMUN () Tue Mar 11 1997 09:47

    Hi,
    
    	I got a call from a customer and they pass some error messages
    after failing to start Oracle.  I don't have a clue about Oracle.
    They wanted to know whether we can help them on the error messages 
    after they fail to start their Oracle.  They are
    running Digital Unix 3.2G.
    
    error:ora-01034:oracle not available
          ora-07320:smsget:shmat error when trying to attend sga
    
    DEC OSF/1 error:12:not enough space
    
    
    Sorry For Ignorance
    SMF

T.R Title User Personal
Name Date Lines

1526.1 check this ALFAM7::GOSEJACOB Tue Mar 11 1997 11:15 35

T.R	Title	User	Personal Name	Date	Lines
1526.1	check this	ALFAM7::GOSEJACOB		`Tue Mar 11 1997 11:15`	35
	re .0 here's some more information derived from the error messages they see: oerr ora 1034 01034, 00000, "ORACLE not available" // Cause: Oracle was not started up. Possible causes include the following: // - The SGA requires more space than was allocated for it. // - The operating-system variable pointing to the instance is // improperly defined. // Action: Refer to accompanying messages for possible causes and correct // the problem mentioned in the other messages. // If Oracle has been initialized, then on some operating systems, // verify that Oracle was linked correctly. See the platform // specific Oracle documentation. oerr ora 7320 07320, 00000, "smsget: shmat error when trying to attach sga." // Cause: Unable to attach segment. // Action: Check errno. sercose[0] returns segment id. Verify segment // exists and that permissions are correct. grep 12 /usr/include/errno.h #define ENOMEM 12 /* Not enough core */ This looks like the typical case where the Oracle kernel tries to allocate a larger SGA than possible. That can happen by hitting a number of limits. Make sure to check if the proc, vm and ipc parameters in sysconfigtab are set to accomodate the size of SGA they try to start up with. Also make sure you are not hitting the datasize and adress space limits in the current shell. Hope this helps Martin

re .0

here's some more information derived from the error messages they see:

oerr ora 1034
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages. 
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.

oerr ora 7320
07320, 00000, "smsget: shmat error when trying to attach sga."
// *Cause:  Unable to attach segment.  
// *Action: Check errno. sercose[0] returns segment id. Verify segment 
//          exists and that permissions are correct. 

grep 12 /usr/include/errno.h
#define ENOMEM		12		/* Not enough core */

This looks like the typical case where the Oracle kernel tries to
allocate a larger SGA than possible. That can happen by hitting a
number of limits. Make sure to check if the proc, vm and ipc parameters
in sysconfigtab are set to accomodate the size of SGA they try to start
up with. Also make sure you are not hitting the datasize and adress
space limits in the current shell.

Hope this helps

	Martin