Re: ORA-07307: sms1sg: shmat error, unable to attach sga

is /usr2 a mounted file system? I haven't seen any shmat errors happen to Oracle. but I get this error from some of my programs that are started off of mounted file systems. you may want to make sure /usr2 is a local file system.

In article <338078DF.499B_at_Rational.com> SRadford_at_PACorp.com writes:
>I am attempting to start an Oracle 7.3.3 database on a
>Sun IPC running Solaris 2.5.1. The database startup fails
>and the following message is written to os.log:
>
>--------------[ rdbms.ins 3674
>]---------------------------------------------
>Action: Using egrep to search for '%create_db_key_words%' in the file:
>/usr2/app/oracle/admin/PAC/create/crdbPAC.lst in order to determine if
>the
>'CREATE DATABASE' statement succeeded for the PAC database.
>Command: (egrep '^ORA-' /usr2/app/oracle/admin/PAC/create/crdbPAC.lst),
>Out=/usr
>2/app/oracle/product/7.3.2/orainst/os.log,
>Err=/usr2/app/oracle/product/7.3.2/or
>ainst/os.log
>{
>ORA-07307: sms1sg: shmat error, unable to attach sga.
>ORA-01034: ORACLE not available
>}
>Status: 0
>--------------[ rdbms.ins 3687
>]---------------------------------------------
>
>Any suggestions? Thanks in advance for any help offered.
>--
>Steve Radford Rational Software Corporation
>Unix/Network SysAdmin 8521 Six Forks Road, Suite 200
>SRadford_at_Rational.com Raleigh, N.C. 27615
>(919)870-8800 x353 http://www.rational.com
Received on Tue May 20 1997 - 00:00:00 CDT