Re: Can't find spfile

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 02 Jun 2006 01:01:02 GMT
Message-Id: <pan.2006.06.02.01.01.02.575899@sbcglobal.net>

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

Received on Thu Jun 01 2006 - 20:01:02 CDT