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 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_905.trc: PMON: terminating instance due to error 470 Instance terminated by PMON, pid = 905 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_945.trc: ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xE0AEA000] [] [] Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_943.trc: ORA-00471: DBWR process terminated with error PMON: terminating instance due to error 471 Instance terminated by PMON, pid = 943 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_982.trc: ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xA000522C] [] [] Fri Nov 14 18:10:51 2003 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_980.trc: ORA-00471: DBWR process terminated with error Fri Nov 14 18:10:51 2003 PMON: terminating instance due to error 471 Instance terminated by PMON, pid = 980 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_dbw0_1004.trc: ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0xA000522C] [] [] Fri Nov 14 18:11:20 2003 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_lgwr_1006.trc: ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x201000] [] [] Fri Nov 14 18:11:29 2003 Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1002.trc: ORA-00471: DBWR process terminated with error Fri Nov 14 18:11:29 2003 PMON: terminating instance due to error 471 Instance terminated by PMON, pid = 1002 I have seen on some of the posts in this group complain about the same issue. What do you think is happening here. Is it some kind of incompatibility with the G5 and dual proc 64 bit processors? Is the only solution moving forward is to wait for Oracle to provide a patch? Thanks a lot!

Showing messages 1 through 7 of 7.

• Problems installing Oracle on a Dual Proc G5
  2004-04-09 19:36:53  marlonkh [View]
  
  
  Did anyone ever get this to work successfully on a dual g5? I get errors pertaining to the floating point processor thta results in a core dump...
  
  Thanks,
  
  Marlon

• 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