Article:  |
Installing Oracle 9i on Mac OS X, Part 3 | |
| Subject: | Problems installing Oracle on a Dual Proc G5 | |
| Date: | 2003-11-14 16:58:36 | |
| From: | anonymous2 | |
|
I tried installing Oracle on my new G5 running OS X 10.2 but encountered errors. Basically it looks like the database was unable to be created. I checked the logs and found that there were many errors talking about not connected to oracle. On checking the alert logs i found the following errors
|
||
Showing messages 1 through 7 of 7.
-
Problems installing Oracle on a Dual Proc G5
2004-04-09 19:36:53 marlonkh [View]
-
Problems installing Oracle on a Dual Proc G5
2004-02-10 00:02:37 nettdata [View]
I had the exact same problem, and found that it was caused by the kernel setting the maximum processes per user limit at 100.
You could run the "ulimit -u 500" command and it would seem to work, but the value wouldn't change. If you ran the command again, it would spit back an error that said "operation not allowed".
The trick is to be able to set the max proc allowed limit to something higher than the default 100.
10.3 allows the use of the /etc/sysctl.conf file to set the initial kernel parameters at boot time.
It didn't exist on my system, so (as root) I created it with the following 2 lines:
kern.maxprocperuid=512
kern.maxproc=2048
After a reboot, I can then launch a bash shell and the user can increase their max allowed processes to 512 or less.
I set this up automatically in the .bashrc script for the user, so that whenever the bash script was launced it ran the following command:
ulimit -u 500
This solved all my problems, and hopefully it'll help others that may run into the same issue.
-
Problems installing Oracle on a Dual Proc G5
2004-02-14 13:55:48 boomkap [View]
On the OS 10.2 jaguar it looks like the /etc/sysctl.conf file gets ignored. Looks like there is hardlimit set in 10.2. I could not set the number via the sysctl -w command.
When the Oracle instance is started there should be only 5 processes. I am surprised how by changing the number of user processes fixed that as the default is 100 and only 5 are required to get the instance up. -
Problems installing Oracle on a Dual Proc G5
2004-02-16 15:35:46 boomkap [View]
I upgraded to Panther and was still not able to get an Oracle instance up successfully. I changed the ulimit to set to 500 successfully. I still get a floating point exception. Any ideas on what else i should try
-
Problems installing Oracle on a Dual Proc G5
2004-01-17 13:49:15 anonymous2 [View]
Maybe the answer is that at the end of the day, just like always, Oracle will not run on a Mac.
mgm@nmsu.edu
-
Problems installing Oracle on a Dual Proc G5
2003-11-26 13:32:00 anonymous2 [View]
Unfortunately I don't have a G5 for testing or I might be able to find out more about this issue. Howerver I can suggest checking the trace file which was written during the crash: /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc
There may be helpful info in this file. Normally, for a released product you would be able to send the file to Oracle for analysis. But since this is a developer release you won't be able to do this.
David Simpson
-
Problems installing Oracle on a Dual Proc G5
2003-11-26 12:56:36 anonymous2 [View]
when i try the following command
startup force nomount pfile=/Users/oracle/9iR2/orahome/dbs/initab.ora
I am able to get the instance started for a few moments. This is what i see
ORACLE instance started.
Total System Global Area 113873180 bytes
Fixed Size 450844 bytes
Variable Size 92274688 bytes
Database Buffers 20480000 bytes
Redo Buffers 667648 bytes
After a few seconds, the instance crashes and this is what i see in the alert logs.
Wed Nov 26 14:45:48 2003
Starting ORACLE instance (force)
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 = 150
timed_statistics = TRUE
shared_pool_size = 50331648
shared_pool_reserved_size= 4500000
control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
db_block_buffers = 10000
rollback_segments = system, rback1
db_domain = US.ORACLE.COM
global_names = FALSE
instance_name = ab
service_names = ab.US.ORACLE.COM
db_name = ab
open_cursors = 2000
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 26 14:45:54 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
Wed Nov 26 14:46:04 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
ORA-00470: LGWR process terminated with error
Wed Nov 26 14:46:04 2003
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 1834
[kapil-khannas-Computer:orahome/rdbms/log] oracle% tail -10000 alert_ab.log
Wed Nov 26 14:45:48 2003
Starting ORACLE instance (force)
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 = 150
timed_statistics = TRUE
shared_pool_size = 50331648
shared_pool_reserved_size= 4500000
control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
db_block_buffers = 10000
rollback_segments = system, rback1
db_domain = US.ORACLE.COM
global_names = FALSE
instance_name = ab
service_names = ab.US.ORACLE.COM
db_name = ab
open_cursors = 2000
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 26 14:45:54 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
Wed Nov 26 14:46:04 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
ORA-00470: LGWR process terminated with error
Wed Nov 26 14:46:04 2003
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 1834
Thanks,
Marlon