From: Bennett Leve (bennett.leve@oracle.com)
Date: Mon Oct 07 2002 - 00:40:08 CEST
Message-ID: <3DA0BBC8.FFDF462F@oracle.com> Date: Sun, 06 Oct 2002 15:40:08 -0700 From: Bennett Leve <bennett.leve@oracle.com> Subject: Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet pleaseadvise
Rob,
The invalid argument is because the SHMMAX value is not high enough for
the size of the SGA. To increase the size of the sga you would need to
modify the SHMMAX value. To do this you would need to:
# cd /proc/sys/kernel
# echo <value_in_bytes> shmmax
To make this change permanent you would want to add something to your
"/etc/init.d/boot.local" file to echo the value into this file everytime
the system rebooted. There may be a better way to do this but this is
the way I have always done it. Since you have 512mb of ram you could
probably get away with putting 400mb into this file. The variable
portion of your SGA, which is mostly the shared pool can exceed one
segment. It is best to make this large enough though to fit the whole
SGA into one segment.
-Bennett
rob wrote:
> well we are getting somewhere ;-)
>
> here is a session
> ############################################
>
> oracle@Nicole:/work/9ihome/bin> sqlplus '/ as sysdba'
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Sun Oct 6 14:41:11 2002
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Connected to an idle instance.
>
> SQL> select name from v$database;
> select name from v$database
> *
> ERROR at line 1:
> ORA-01034: ORACLE not available
>
> SQL> startup nomount pfile=/work/9ihome/dbs/init.ora
> ORACLE instance started.
>
> Total System Global Area 42741800 bytes
> Fixed Size 450600 bytes
> Variable Size 41943040 bytes
> Database Buffers 204800 bytes
> Redo Buffers 143360 bytes
>
> SQL> select name from v$database;
> select name from v$database
> *
> ERROR at line 1:
> ORA-01507: database not mounted
>
> SQL> shutdown immediate
> ORA-01507: database not mounted
>
> ORACLE instance shut down.
>
> SQL> startup pfile=/work/9ihome/dbs/init.ora
> ORA-27123: unable to attach to shared memory segment
> Linux Error: 22: Invalid argument
> Additional information: 1
> Additional information: 204996613
> SQL>
>
> ####################################
> here is output of dbs
>
> Nicole:/work/9ihome # cd dbs/;ls -a
> . .. init.ora initdw.ora lkORCL
>
> Nicole:/work/9ihome/dbs # cat lkORCL
> DO NOT DELETE THIS FILE!Nicole:/work/9ihome/dbs #
>
> I think these are just defaults because I have this dir on windows nt
> with 9i but the sid got built in admin I really dont think they were
> used to build the test sid they are just example files
>
> Im pretty sure I told install to use db9i as the sid
>
> my oradmin and oradata are on /oracle_store
> theis is a seperate disk
>
> I dont have admin or oradata in the home /work/9ihome they are in
> /oracle_store
>
> eg
> Nicole:/work/9ihome # df -m
> Filesystem 1M-blocks Used Available Use% Mounted on
> /dev/hdb5 1004 439 565 44% /
> /dev/hdb6 502 36 466 8% /boot
> /dev/hdb11 10001 2669 7332 27% /home
> /dev/hdb12 5004 33 4972 1% /local
> /dev/hdb9 5004 548 4457 11% /opt
> /dev/hda2 9264 33 9231 1% /oracle_store
> /dev/hdb7 5004 940 4064 19% /usr
> /dev/hdb8 5004 123 4881 3% /var
> /dev/hdb13 6730 3674 3056 55% /work
>
> The dbca only made it to 46 % cant we run it again...
>
> or any other suggestions
>
> many thanks for helping here....
>
> !!
> rob
>
> --
> How wonderful opera would be if there were no singers.
---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.4 : Sun Oct 06 2002 - 21:46:38 CEST