Oracle 10g/9i on FreeBSD 6.2
Dimych
dima at kod.ua
Fri Aug 31 14:39:58 PDT 2007
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 at kod.ua
More information about the freebsd-database
mailing list