473,390 Members | 1,132 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

Please point us on installing Oracle 9.2 on FreeBSD

Hello !

I'm about to install O9i on FreeBSD box.
uname -a:
FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2:
Fri Apr 23 19:19:43 KRAST 2004
rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386
uname -a under oracle user [linux shell]:
Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23
19:19:43 KRAST 2004 i686 unknown

My problem is when I run "startup nomount" command, I get
$ sqlplus "sys/admin as sysdba"
Connected to an idle instance.
SQLstartup nomount
ORA-00445: background process "PMON" did not start after 120 seconds

and I found out that 'oracle' process dies every time I enter "startup
nomount":
bash-2.05b# tail -1 /var/log/messages
Apr 23 21:09:18 stat2 kernel: pid 824 (oracle), uid 71: exited on
signal 11
I spend many days to make it work without results.
I found post at http://www.shadowcom.net/freebsd-oracle9i/
and make sure that I did all step-by-step:
1. kernel options applied
2. Installed all required ports, pkg_info |grep linux
linux-sun-jdk-1.3.1.10
linux_base-7.1_7
linux_devtools-7.1_3
3. created mtab
4. created oracle account, groups also was created
etc..

Also I view http://tomclegg.net/oracle9i-bsd5 ,
http://www.bsdforums.org/forums/show...?threadid=7441
recomendations, but this contain nothing about this problem.

This result I get on Oracle 9.2.0.1.0 and 9.2.0.4.0 (last patchset
applied),
the result is the same, "background process "PMON" did not start after
120 seconds",
"(oracle), uid 71: exited on signal 11".

What I did make incorrect? I tried to play with init-parameters, but
this did not help - somewhere in forum ppls said this can occur when
SGA size exceed physical size (server have 512M of RAM),
but my SGA size small. Last my version of initCLDB.ora was:
db_name=CLDB
instance_name=CLDB
#db_files = 400
#db_block_buffers = 3200
#shared_pool_size = 9000000
#processes = 100
#log_buffer = 32768
db_file_multiblock_read_count = 16
log_checkpoint_interval = 10000
parallel_max_servers = 5
# audit_trail = true # if you want auditing
timed_statistics = true # if you want timed statistics
#max_dump_file_size = 10240 # limit trace file size to 5 Meg
each
# log_archive_dest = disk$rdbms:[oracle.archive]
# log_archive_format = "T%TS%S.ARC"
# transactions = 40
# transactions_per_rollback_segment = 5
# Global Naming -- enforce that a dblink has same name as the db it
connects to
#my## global_names = TRUE
# db_domain = us.acme.com # global database name is
db_name.db_domain
# define two control files by default
control_files = ('/opt/oracle/oradata/u01/ctrl01.ctl',
'/opt/oracle/oradata/u02/ctrl02.ctl')
compatible = 9.2.0.4.0
background_dump_dest = /usr/opt/oracle/admin/CLDB/bdump
user_dump_dest = /usr/opt/oracle/admin/CLDB/udump
core_dump_dest = /usr/opt/oracle/admin/CLDB/cdump
os_authent_prefix = ""
oracle_trace_enable=TRUE
many parameters have default values...

I have properly configured listener, tnsping works. After connecting
to
an idle instance (before enter 'startup nomount') I have some
oracle process:
$ ps ax | grep ora
895 ?? Ss 0:00,03 oracleCLDB
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) (oracl
884 p1 I 0:00,05 /usr/opt/oracle/product/9.2.0/bin/tnslsnr
LISTENER -inherit

I even tries to make ktrace of oracle, here is last lines of this dump
(forked process, I think it is PMON):
6877 oracle RET getpid 6877/0x1add
6877 oracle CALL pathconf(0x3,0xbfbfb81c)
6877 oracle RET pathconf 0
6877 oracle CALL pwrite(0x20,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x21,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x22,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL obs_execv(0xbfbfba84,0xbfbfbca8,0xbfbfe7a4)
6877 oracle NAMI
"/compat/linux/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/compat/linux/lib/ld-linux.so.2"
6877 oracle RET obs_execv 0
6877 oracle CALL settimeofday(0xbfbfe2a4)
6877 oracle RET settimeofday 0
6877 oracle CALL ktrace(0)
6877 oracle RET ktrace 181866496/0xad71000
6877 oracle CALL semget(0,0x1,0)
6877 oracle RET semget -1 errno -9 Unknown error: -9
6877 oracle CALL open(0x4a4cd30c,0x20000,0xbfbfe26c)
6877 oracle NAMI "/compat/linux/dev/null"
6877 oracle NAMI "/dev/null"
6877 oracle RET open 0
6877 oracle CALL mmap(0,0xbfbfe204,0)
6877 oracle RET mmap 0
6877 oracle PSIG SIGSEGV SIG_DFL
Is it since semget-around problem? Or what is obs_execv?

Please help to point me to where my mistake is?

Thanks a lot.

--
best regards,
Ruslan A Dautkhanov ru*****@scn.ru
Jun 27 '08 #1
2 3535
"Ruslan A Dautkhanov" <ru*****@scn.ruwrote in message
news:b8**************************@posting.google.c om...
Hello !

I'm about to install O9i on FreeBSD box.
uname -a:
FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2:
Fri Apr 23 19:19:43 KRAST 2004
rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386
uname -a under oracle user [linux shell]:
Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23
19:19:43 KRAST 2004 i686 unknown

My problem is when I run "startup nomount" command, I get
$ sqlplus "sys/admin as sysdba"
Connected to an idle instance.
SQLstartup nomount
ORA-00445: background process "PMON" did not start after 120 seconds

and I found out that 'oracle' process dies every time I enter "startup
nomount":
bash-2.05b# tail -1 /var/log/messages
Apr 23 21:09:18 stat2 kernel: pid 824 (oracle), uid 71: exited on
signal 11
I spend many days to make it work without results.
I found post at http://www.shadowcom.net/freebsd-oracle9i/
and make sure that I did all step-by-step:
1. kernel options applied
2. Installed all required ports, pkg_info |grep linux
linux-sun-jdk-1.3.1.10
linux_base-7.1_7
linux_devtools-7.1_3
3. created mtab
4. created oracle account, groups also was created
etc..

Also I view http://tomclegg.net/oracle9i-bsd5 ,
http://www.bsdforums.org/forums/show...?threadid=7441
recomendations, but this contain nothing about this problem.

This result I get on Oracle 9.2.0.1.0 and 9.2.0.4.0 (last patchset
applied),
the result is the same, "background process "PMON" did not start after
120 seconds",
"(oracle), uid 71: exited on signal 11".

What I did make incorrect? I tried to play with init-parameters, but
this did not help - somewhere in forum ppls said this can occur when
SGA size exceed physical size (server have 512M of RAM),
but my SGA size small. Last my version of initCLDB.ora was:
db_name=CLDB
instance_name=CLDB
#db_files = 400
#db_block_buffers = 3200
#shared_pool_size = 9000000
#processes = 100
#log_buffer = 32768
db_file_multiblock_read_count = 16
log_checkpoint_interval = 10000
parallel_max_servers = 5
# audit_trail = true # if you want auditing
timed_statistics = true # if you want timed statistics
#max_dump_file_size = 10240 # limit trace file size to 5 Meg
each
# log_archive_dest = disk$rdbms:[oracle.archive]
# log_archive_format = "T%TS%S.ARC"
# transactions = 40
# transactions_per_rollback_segment = 5
# Global Naming -- enforce that a dblink has same name as the db it
connects to
#my## global_names = TRUE
# db_domain = us.acme.com # global database name is
db_name.db_domain
# define two control files by default
control_files = ('/opt/oracle/oradata/u01/ctrl01.ctl',
'/opt/oracle/oradata/u02/ctrl02.ctl')
compatible = 9.2.0.4.0
background_dump_dest = /usr/opt/oracle/admin/CLDB/bdump
user_dump_dest = /usr/opt/oracle/admin/CLDB/udump
core_dump_dest = /usr/opt/oracle/admin/CLDB/cdump
os_authent_prefix = ""
oracle_trace_enable=TRUE
many parameters have default values...

I have properly configured listener, tnsping works. After connecting
to
an idle instance (before enter 'startup nomount') I have some
oracle process:
$ ps ax | grep ora
895 ?? Ss 0:00,03 oracleCLDB
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) (oracl
884 p1 I 0:00,05 /usr/opt/oracle/product/9.2.0/bin/tnslsnr
LISTENER -inherit

I even tries to make ktrace of oracle, here is last lines of this dump
(forked process, I think it is PMON):
6877 oracle RET getpid 6877/0x1add
6877 oracle CALL pathconf(0x3,0xbfbfb81c)
6877 oracle RET pathconf 0
6877 oracle CALL pwrite(0x20,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x21,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x22,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL obs_execv(0xbfbfba84,0xbfbfbca8,0xbfbfe7a4)
6877 oracle NAMI
"/compat/linux/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/compat/linux/lib/ld-linux.so.2"
6877 oracle RET obs_execv 0
6877 oracle CALL settimeofday(0xbfbfe2a4)
6877 oracle RET settimeofday 0
6877 oracle CALL ktrace(0)
6877 oracle RET ktrace 181866496/0xad71000
6877 oracle CALL semget(0,0x1,0)
6877 oracle RET semget -1 errno -9 Unknown error: -9
6877 oracle CALL open(0x4a4cd30c,0x20000,0xbfbfe26c)
6877 oracle NAMI "/compat/linux/dev/null"
6877 oracle NAMI "/dev/null"
6877 oracle RET open 0
6877 oracle CALL mmap(0,0xbfbfe204,0)
6877 oracle RET mmap 0
6877 oracle PSIG SIGSEGV SIG_DFL
Is it since semget-around problem? Or what is obs_execv?

Please help to point me to where my mistake is?

Thanks a lot.

--
best regards,
Ruslan A Dautkhanov ru*****@scn.ru
Ruslan,

Your mistake would appear to be installing Oracle 9i on unsupported
platform. Please see http://otn.oracle.com/support/metalink/header.htm for
supported combinations of operating system and versions of Oracle.

For unsupported combinations, one would consult Howard Rogers' site at
http://www.dizwell.com/html/oracle_on_linux.html , but there is no entry for
FreeBSD there.

Douglas Hawthorne
Jun 27 '08 #2
"Douglas Hawthorne" <do**************@yahoo.com.auwrote in message news:<3f*****************@news-server.bigpond.net.au>...
"Ruslan A Dautkhanov" <ru*****@scn.ruwrote in message
news:b8**************************@posting.google.c om...
Hello !

I'm about to install O9i on FreeBSD box.
uname -a:
FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2:
Fri Apr 23 19:19:43 KRAST 2004
rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386
uname -a under oracle user [linux shell]:
Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23
19:19:43 KRAST 2004 i686 unknown

My problem is when I run "startup nomount" command, I get
$ sqlplus "sys/admin as sysdba"
Connected to an idle instance.
SQLstartup nomount
ORA-00445: background process "PMON" did not start after 120 seconds

and I found out that 'oracle' process dies every time I enter "startup
nomount":
bash-2.05b# tail -1 /var/log/messages
Apr 23 21:09:18 stat2 kernel: pid 824 (oracle), uid 71: exited on
signal 11
I spend many days to make it work without results.
I found post at http://www.shadowcom.net/freebsd-oracle9i/
and make sure that I did all step-by-step:
1. kernel options applied
2. Installed all required ports, pkg_info |grep linux
linux-sun-jdk-1.3.1.10
linux_base-7.1_7
linux_devtools-7.1_3
3. created mtab
4. created oracle account, groups also was created
etc..

Also I view http://tomclegg.net/oracle9i-bsd5 ,
http://www.bsdforums.org/forums/show...?threadid=7441
recomendations, but this contain nothing about this problem.

This result I get on Oracle 9.2.0.1.0 and 9.2.0.4.0 (last patchset
applied),
the result is the same, "background process "PMON" did not start after
120 seconds",
"(oracle), uid 71: exited on signal 11".

What I did make incorrect? I tried to play with init-parameters, but
this did not help - somewhere in forum ppls said this can occur when
SGA size exceed physical size (server have 512M of RAM),
but my SGA size small. Last my version of initCLDB.ora was:
db_name=CLDB
instance_name=CLDB
#db_files = 400
#db_block_buffers = 3200
#shared_pool_size = 9000000
#processes = 100
#log_buffer = 32768
db_file_multiblock_read_count = 16
log_checkpoint_interval = 10000
parallel_max_servers = 5
# audit_trail = true # if you want auditing
timed_statistics = true # if you want timed statistics
#max_dump_file_size = 10240 # limit trace file size to 5 Meg
each
# log_archive_dest = disk$rdbms:[oracle.archive]
# log_archive_format = "T%TS%S.ARC"
# transactions = 40
# transactions_per_rollback_segment = 5
# Global Naming -- enforce that a dblink has same name as the db it
connects to
#my## global_names = TRUE
# db_domain = us.acme.com # global database name is
db_name.db_domain
# define two control files by default
control_files = ('/opt/oracle/oradata/u01/ctrl01.ctl',
'/opt/oracle/oradata/u02/ctrl02.ctl')
compatible = 9.2.0.4.0
background_dump_dest = /usr/opt/oracle/admin/CLDB/bdump
user_dump_dest = /usr/opt/oracle/admin/CLDB/udump
core_dump_dest = /usr/opt/oracle/admin/CLDB/cdump
os_authent_prefix = ""
oracle_trace_enable=TRUE
many parameters have default values...

I have properly configured listener, tnsping works. After connecting
to
an idle instance (before enter 'startup nomount') I have some
oracle process:
$ ps ax | grep ora
895 ?? Ss 0:00,03 oracleCLDB
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) (oracl
884 p1 I 0:00,05 /usr/opt/oracle/product/9.2.0/bin/tnslsnr
LISTENER -inherit

I even tries to make ktrace of oracle, here is last lines of this dump
(forked process, I think it is PMON):
6877 oracle RET getpid 6877/0x1add
6877 oracle CALL pathconf(0x3,0xbfbfb81c)
6877 oracle RET pathconf 0
6877 oracle CALL pwrite(0x20,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x21,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL pwrite(0x22,0xbfbfb77c,0,0x8)
6877 oracle RET pwrite 0
6877 oracle CALL obs_execv(0xbfbfba84,0xbfbfbca8,0xbfbfe7a4)
6877 oracle NAMI
"/compat/linux/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/usr/opt/oracle/product/9.2.0/bin/oracle"
6877 oracle NAMI "/compat/linux/lib/ld-linux.so.2"
6877 oracle RET obs_execv 0
6877 oracle CALL settimeofday(0xbfbfe2a4)
6877 oracle RET settimeofday 0
6877 oracle CALL ktrace(0)
6877 oracle RET ktrace 181866496/0xad71000
6877 oracle CALL semget(0,0x1,0)
6877 oracle RET semget -1 errno -9 Unknown error: -9
6877 oracle CALL open(0x4a4cd30c,0x20000,0xbfbfe26c)
6877 oracle NAMI "/compat/linux/dev/null"
6877 oracle NAMI "/dev/null"
6877 oracle RET open 0
6877 oracle CALL mmap(0,0xbfbfe204,0)
6877 oracle RET mmap 0
6877 oracle PSIG SIGSEGV SIG_DFL
Is it since semget-around problem? Or what is obs_execv?

Please help to point me to where my mistake is?

Thanks a lot.

--
best regards,
Ruslan A Dautkhanov ru*****@scn.ru

Ruslan,

Your mistake would appear to be installing Oracle 9i on unsupported
platform. Please see http://otn.oracle.com/support/metalink/header.htm for
supported combinations of operating system and versions of Oracle.

For unsupported combinations, one would consult Howard Rogers' site at
http://www.dizwell.com/html/oracle_on_linux.html , but there is no entry for
FreeBSD there.

Douglas Hawthorne
Yes, I know that Oracle officially don't support FreeBSD.
We use Oracle 8.1.7 under FreeBSD. And we have to upgrade to 9.2,
many ppls have worked configurations:
http://tomclegg.net/oracle9i-bsd5
http://www.bsdforums.org/forums/show...?threadid=7441
http://ezine.daemonnews.org/200402/oracle.html

Douglas, thanks for your reply, but anybody can really help us to
solve this problem?

Thanks a lot for any information.
Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ollivier Robert | last post by:
Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get a SEGV from inside the libcnltsh.so library. ...
1
by: Gustavo Oliveira | last post by:
Hi, I'm desperate... I've been installed Oracle Client. 9.1i in some computers and 9.2i in others. The installation was sucefull, because, I can use SQL Plus, without problems... Now...
0
by: Alex Lapp | last post by:
Hi ng, i have a problem installing cvs module from: http://www.object-craft.com.au/projects/csv/ My Python version is: Python 2.1.3 (Not the latest, but i need this version for running Zope...
1
by: J Goldman | last post by:
I am trying to install Oracle 9i (9.2.0.1, 32 bit) on Windows XP Pro (version 2002, SP 1, Intel P3), but I get an error claiming that Oracle requires Service Pack 1 or greater, which it thinks my...
1
by: Monica Roman | last post by:
Hello, Disclaimer: I'm a TOTAL rookie. I just went through unistalling Oracle to be able to install Discoverer, which was succesful. (Our in-house Oracle support person said that if I did the...
9
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work....
4
by: james | last post by:
I have a problem installing Pyhton 2.4.3, running "./configure --with-threads=no" completes, but gives the warning: configure: WARNING: curses.h: present but cannot be compiled configure:...
1
by: Vyacheslav Sotnikov | last post by:
Hello python-list, is anybody has any success in taking this components live together? I need to access remote Oracle 9i from freebsd 6.2 machine using python 2.4.4. Thanks in advance for answer.
0
by: Chris Leonard | last post by:
James - you could be running into a known issue with installing Oracle8i software on a P4. Here is a plain-text section of our internal documentation of the issue: Subject/Title: Installing...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.