On Fri, 21 Jan 2000, ed bittel wrote:

> Is there a way to define the location of the parameter
> for a database so that I don't have to specify it's
> location when I issue the startup command?  
> 
> My other databases seem to find their parameter files
> on their own, but I have one that I have to use the
> "PFILE=" in the startup command.  
> 
> HPUX 11.0 ~ Oracle 8.0.5

In UNIX, the default location that Oracle looks is in $ORACLE_HOME/dbs.

If you wish for your init.ora to be elsewhere, you can make a symbolic
link pointing from $ORACLE_HOME/dbs to the true location:

ln -s $ORACLE_HOME/dbs/initSID.ora $NEW_DIRECTORY/initSID.ora

Best regards,

-Ari Kaplan
350 Oracle Tips: www.arikaplan.com



Back to Ari Kaplan's Home Page