Re: Can't find spfile

joel garry wrote:
> 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

Don't believe so...sqlplus is working and which sqlplus shows it under the bin under $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)

Ok, could be, it's not my machine

> find / -name "*ora"

Yeah, did that, only found network/admin files

> started with a pfile that didn't end in ora
> broken link to dbs or nfs issue or cluster issue
ok, maybe...I'll have to investigate that.

> create pfile from spfile

Is that a suggestion or that I should be looking for a pfile? show parameter pfile results in the same spfile display. Couldn't find any file containing *pfile*.

>
> What are the problems?

All I wanted to do was modify the init.ora/spfile to set a trace file (for ORACLE_TRACE_ENABLE) to track down a ORA-03113 error in an OCI app. However, I've just realised unless I can guess the oracle password I'm screwed :-( Received on Thu Jun 01 2006 - 18:01:23 CDT