From: Arnold Bosch (Arnold.Bosch@einsa.com)
Date: Sun Oct 06 2002 - 21:22:44 CEST
Date: Sun, 06 Oct 2002 21:22:44 +0200 From: Arnold Bosch <Arnold.Bosch@einsa.com> Message-Id: <20021006211958.6265.ARNOLD.BOSCH@einsa.com> Subject: Re[2]: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet pleaseadvise
On Sun, 06 Oct 2002 14:59:43 -0700
rob <robert73@attbi.com> wrote:
> well we are getting somewhere ;-)
>
Rob,
It seems you have not set the Shared Memory and the Kernel Parameters
before running 'dbca' Try to install the SuSE orarun9.rpm file and
execute it before rerunning dbca (even if you get errors, the Shared
Memory and Kernel parameters are set). Rerun dbca and try to recreate
the DB.
Goodluck,
Arnold.
> 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
Arnold Bosch
-- http://www.einsamultimedia.com e-mail: Arnold.Bosch@einsa.com Tlf: +34 981 454 009 (direct) Fax: +34 981 495 680--------------------------------------------------------------------- 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:23:00 CEST