Women in Technology

Article:		Installing Oracle 9i on Mac OS X, Part 3
Subject:		Problem starting instance, ORA-27103
Date:		2004-03-17 11:18:25
From:		gautamarora
Response to: Problem starting instance, ORA-27103
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

Showing messages 1 through 1 of 1.

• 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 ;-)