From: Michael Serbanescu <mserban@postoffice.worldnet.att.net>
Subject: Re: Shared Memory Error - shmat error, unable to attach sga
Date: 1998/04/04
Message-ID: <6g4j60$gj@bgtnsc02.worldnet.att.net>#1/1
Content-Transfer-Encoding: 7bit
References: <6g0i7k$5er$1@nnrp1.dejanews.com>
To: jkc@consultant.com
Content-Type: text/plain; charset=us-ascii
Organization: AT&T Worldnet
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server



Did you properly set the ORACLE_SID and ORACLE_HOME environment variables ? And 
I hope you did not forget to start up the instance before creating the database (in 
the Oracle world, DATABASE and INSTANCE are two entirely different things):

SVRMGR> startup nomount (starts up the instance without mounting the database)
SVRMGR> @crdbjunk.sql

Hope this helps.




Michael Serbanescu
-------------------------------------------------------------------------------
jkc@consultant.com wrote:
> 
> Hi,
> 
> I am installing Oracle8 on Solaris 2.6 (Sparc 2 with 64MB RAM) and getting the
> following message:
> 
> Does anyone know what causes this?    Thanks.   John
> 
> --- Error messsages following ----------------
> Oracle8 Enterprise Edition Release 8.0.3.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.3.0.0 - Production
> 
> SVRMGR> @crdbjunk.sql
> Connected.
> ORA-07307: sms1sg: shmat error, unable to attach sga.
> SVR4 Error: 22: Invalid argument
> Additional information: 1
> create database "junk"
> *
> ORA-01034: ORACLE not available
> Disconnected.
> SVRMGR>
> 
> < The contents of /etc/system is: >
> 
> * Shared memory parameters 40mb x 1024 x 1024
> set shmsys:shminfo_shmmax= 41943040
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=1
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semmsl=200
> 
> ---------------
> 
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/   Now offering spam-free web-based newsreading