From owner-freebsd-database@FreeBSD.ORG Fri Aug 31 21:39:58 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D4D8D16A417 for ; Fri, 31 Aug 2007 21:39:58 +0000 (UTC) (envelope-from dima@kod.ua) Received: from ns.dimych.sumy.ua (ns.fse.sumy.ua [82.207.112.230]) by mx1.freebsd.org (Postfix) with ESMTP id DD2D213C45D for ; Fri, 31 Aug 2007 21:39:57 +0000 (UTC) (envelope-from dima@kod.ua) Received: from DIMA-HOME ([10.119.3.36]) by ns.dimych.sumy.ua (8.12.10/8.12.10) with ESMTP id l7VLQYbB049460 for ; Sat, 1 Sep 2007 00:26:35 +0300 (EEST) (envelope-from dima@kod.ua) Date: Sat, 1 Sep 2007 00:26:30 +0300 From: Dimych X-Mailer: The Bat! (v3.99.3) Professional X-Priority: 3 (Normal) Message-ID: <1861713279.20070901002630@dimych.sumy.ua> To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-4.9 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.0.2 X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on ns.dimych.sumy.ua Subject: Oracle 10g/9i on FreeBSD 6.2 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 31 Aug 2007 21:39:58 -0000 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