Re: Oracle 9.2.0 Gentoo Linux - ORA 3113 on DB startup

Jasper wrote:

> Hi,
>
> I installed Oracle 9.2.0 on my Gentoo Linux box yesterday.
> Installation went
> smooth, but I can't create a database. I get an ORA-3113 on the
> startup nomount command.
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> startup nomount;
> ... waits for about 30 secs ...
> ORA-03113: end-of-file on communication channel
> SQL>
>
> I've set the kernel parameters as recommended in the installation docs
> :
>
> # cat /proc/sys/kernel/sem
> 250 32000 100 128
> # cat /proc/sys/kernel/shmmax
> 2147483648
>
> The alert log says :
>
> Sun Feb 9 16:19:51 2003
> Starting ORACLE instance (normal)
> LICENSE_MAX_SESSION = 0
> LICENSE_SESSIONS_WARNING = 0
> SCN scheme 2
> Using log_archive_dest parameter default value
> LICENSE_MAX_USERS = 0
> SYS auditing is disabled
> Starting up ORACLE RDBMS Version: 9.2.0.1.0.
> System parameters with non-default values:
> processes = 35
> shared_pool_size = 12582912
> control_files = /data/oradata/DB2/d01/control01.ctl,
> /data/oradata/DB2/d02/control02.ctl,
> /data/oradata/DB2/d03/control03.ctl
> db_block_size = 8192
> db_cache_size = 12582912
> db_file_multiblock_read_count= 16
> db_name = DB2
> optimizer_mode = choose
> star_transformation_enabled= true
> parallel_threads_per_cpu = 4
> parallel_automatic_tuning= TRUE
> query_rewrite_enabled = true
> query_rewrite_integrity = trusted
> pga_aggregate_target = 31457280
>
> Trace file says :
>
> /home/oracle/product/9.2.0/rdbms/log/db2_ora_1717.trc
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning option
> JServer Release 9.2.0.1.0 - Production
> ORACLE_HOME = /home/oracle/product/9.2.0
> System name: Linux
> Node name: anubis
> Release: 2.4.20
> Version: #5 Sat Dec 21 16:00:38 CET 2002
> Machine: i686
> Instance name: DB2
> Redo thread mounted by this instance: 0 <none>
> Oracle process number: 0
> 1717
>
> OPIRIP: Uncaught error 1034. Error stack:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> I did an strace of the oracle server process (which is spawned after
> the connect / as sysdba). I repeatedly get this message :
>
> --- SIGALRM (Alarm clock) ---
> rt_sigprocmask(SIG_BLOCK, [], NULL, 8) = 0
> gettimeofday({1044803565, 148746}, NULL) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={0, 10000}},
> NULL) = 0
> rt_sigprocmask(SIG_UNBLOCK, [], NULL, 8) = 0
> rt_sigreturn(0x1) = -1 EINTR (Interrupted system
> call)
> rt_sigprocmask(SIG_BLOCK, [ALRM], NULL, 8) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={0, 0}}, NULL) =
> 0
> rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
> gettimeofday({1044803565, 149087}, {4294967236, 0}) = 0
> gettimeofday({1044803565, 149142}, {4294967236, 0}) = 0
> rt_sigprocmask(SIG_BLOCK, NULL, [RTMIN], 8) = 0
> rt_sigprocmask(SIG_BLOCK, [ALRM], NULL, 8) = 0
> gettimeofday({1044803565, 149291}, NULL) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={1, 20000}},
> NULL) = 0
> rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
> semop(131073, 0xbfffca00, 1) = -1 EINTR (Interrupted system
> call)
>
> Looks like semop() is failing. But why...
>
> Any help ?
>
> Thx !

You mention kernel parameters and specifically note SHMMAX. Did you set all 9 of them? And did you reboot the box so that they would take effect before beginning the installation?

Daniel Morgan Received on Sun Feb 09 2003 - 11:35:45 CST