Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Memory Error - shmat error, unable to attach sga

Re: Shared Memory Error - shmat error, unable to attach sga

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1998/04/04
Message-ID: <6g4j60$gj@bgtnsc02.worldnet.att.net>#1/1

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_at_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
Received on Sat Apr 04 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US