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 :-(