Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 1 Sep 2007 00:26:30 +0300
From:      Dimych <dima@kod.ua>
To:        freebsd-database@freebsd.org
Subject:   Oracle 10g/9i on FreeBSD 6.2
Message-ID:  <1861713279.20070901002630@dimych.sumy.ua>

next in thread | raw e-mail | index | archive | help
Hi

I installed Oracle 10g (10.2.0.4) on my FreeBSD box (6.2-RELEASE). All required
actions done (Kernel configuration, linux emulation, linux_base,
additional linux packages). Install successful (yes, binary linking
too successful), but database creation from DBCA don't start. I create
database creation scripts using DBCA, and trying to run it. And receive
following in sqlplus at beginning on database creation script:

SQL> startup nomount pfile="/u01/app/oracle/admin/bill/scripts/init.ora";
ORA-00443: background process "PMON" did not start

sqlplus was run by user oracle from shell /compat/linux/bin/bash.

Environment variables:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0.1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORACLE_SID=BILL
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
PATH=/compat/linux/bin:/compat/linux/sbin:/compat/linux/usr/bin:/compat/linux/usr/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:$ORACLE_HOME/bin;
PS1='oracle-bsd>'
NLS_LANG=RUSSIAN_CIS.CL8KOI8R
ORACLE_TERM=vt220; export ORACLE_TERM
ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data

Kernel options:
options         COMPAT_LINUX
options         SEMMAP=128
options         SEMMNI=128
options         SEMMNS=32000
options         SEMOPM=100
options         SEMMSL=250
options         SHMMAXPGS=262144
options         SHMMNI=4096
options         SHMSEG=4096
options         MAXDSIZ="(1024*1024*1024)"
options         MAXSSIZ="(1024*1024*1024)"
options         DFLDSIZ="(1024*1024*1024)"

I make ktrace and linux_kdump on oracle process. This is part of it
with error:

 72051 oracle   0.000025 CALL  linux_execve(0xbfbfab1c,0xbfbfa7a0,0xcbff348)
 72051 oracle   -1.999974 NAMI  "/compat/linux/u01/app/oracle/product/10.2.0.1/bin/oracle"
 72051 oracle   0.000053 NAMI  "/u01/app/oracle/product/10.2.0.1/bin/oracle"
 72051 oracle   0.000037 NAMI  "/compat/linux/lib/ld-linux.so.2"
 72051 oracle   0.000328 RET   linux_execve 0
 72051 oracle   0.000090 CALL  linux_brk(0)
 72051 oracle   0.000018 RET   linux_brk 213807104/0xcbe7000
 72051 oracle   0.000015 CALL  linux_fcntl64(0,0x1,0)
 72051 oracle   0.000016 RET   linux_fcntl64 -1 errno 9 Bad file descriptor
 72051 oracle   0.000016 CALL  linux_open(0x4cb8e9fe,0x20001,0)
 72051 oracle   0.000019 NAMI  "/compat/linux/dev/full"
 72051 oracle   0.000053 NAMI  "/dev/full"
 72051 oracle   0.000075 RET   linux_open JUSTRETURN
 72051 oracle   0.000028 PSIG  SIGSEGV SIG_DFL

 After it, I installs Oracle 9.2.0.4 on the same system, all was
 exactly like with 10g, but error was:
 ORA-00445: background process "PMON" did not start after 120 seconds

 ktrace and linux_kdump shows exactly the same.

 I heard what some people already installs Oracle 9i and even 10g on
 FreeBSD, but versions earlier than FreeBSD 6.
 Also I see exactly same problem here:
 http://www.webservertalk.com/archive148-2004-4-198432.html
 
 In this link described same problem, but author uses kdump instead on
 linux_kdump. I contact author, he fix this, run Oracle, and use it
 more than 2 years after it. But he forgot what he do to fix :(.

 I explain all process of installation in detail here (all on Russian):
 http://www.sql.ru/forum/actualthread.aspx?bid=3&tid=467004

-- 
Best regards,
 Dimych                          mailto:dima@kod.ua




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1861713279.20070901002630>