Re: Can't find spfile

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).

Thoughts that come immediately to mind:

Wrong $ORACLE_HOME
dbs directory deleted (unix keeps deleted files open until they are closed, you just can't see their directory entries - renaming can be confusing, too)
find / -name "*ora"
started with a pfile that didn't end in ora broken link to dbs or nfs issue or cluster issue create pfile from spfile

What are the problems?

jg

-- 
@home.com is bogus.
http://www.salon.com/dec96/tomorrow961202.html