Women in Technology

Article:		Installing Oracle 9i on Mac OS X, Part 3
Subject:		Problem starting instance, ORA-27103
Date:		2004-03-15 20:29:45
From:		gautamarora
Hi, I could not start instance on my powermac G4. Env settings are correct, also the ulimit settings. SQL>startup nomount pfile='initdb1.ora' ORA-27103: internal error Mac OS X Error: 19: Operation not supported by device Additional information: 103 Additional information: 33554432 Additional information: 32096832 I would appreciate your suggestions. Thanks, Gautam

Showing messages 1 through 2 of 2.

• Problem starting instance, ORA-27103
  2004-03-17 11:18:25  gautamarora [View]
  
  
  Removed pga_aggregate_target from init.ora file
  and I was able to start the instance. Has anyone got it to work with above parameter ?.
  
  Please anyone advice. Can I put the oracle env varibles from /etc/profile to /users/oracle/.bash_profile
  and remove it from /etc/profile ?.
  
  Thanks,
  
  Gautam
  
  
  
• Problem starting instance, ORA-27103
  2004-04-02 09:00:23  murphyatgenome [View]
  
  
  I got rid of it also. My memory is fuzzy, but I seem to remember discovering that the automatic PGA feature isn't implemented yet on OS X, meaning you have to manually size the various buffers.
  
  You probably already discovered that you can put the environment variable definitions wherever you want. /etc/profile makes the settings conveniently available to all sh/bash users on a box.
  
  This article was a bit sloppy on various counts, as other comments indicate, and I'm surprised it hasn't been perfected over time. I guess the author is hoping you will buy his product or services ;-)