On Thu, 01 Jun 2006 14:49:43 -0700, pfa wrote:

> I'm trying to investigate problems on an oracle 9i server however I
> cannot find an init.ora, pfile or spfile. What's strange is that show
> parameter spfile says ?/dbs/spfile@.ora and yet there is no directory
> dbs in $ORACLE_HOME (linux btw).

You've got a problem. There should be $ORACLE_HOME/dbs. If you don't have
it, you can always create it. If $ORACLE_HOME/dbs is missing, God knows
what else might be missing as well.

--
http://www.mgogala.com