Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: urgent or oracle installation

RE: urgent or oracle installation

From: Kamalakannan, D (CAP, GCF) <>
Date: Fri, 11 Aug 2000 12:45:33 +0200
Message-Id: <>


Sometimes ps-ef | grep ora doesnot show you the ooracle processes -thats a bug.
What you can do is use
/usr/proc/bin/ptree "user_name" or " process_id".

to find out whether there are any oracle process which are still running, Then Kill them and start installation.

-----Original Message-----
From: vipul desai [] Sent: Friday, August 11, 2000 6:14 AM
To: Multiple recipients of list ORACLE-L Subject: urgent or oracle installation

hi there,

  i am facing a problem in oracle installation on sun box and as mentioned bellow following steps i have taken to resolve the same error and two of the Sr. DBA are also helping me on the same and the correspondance is attached here with could any one help me on the same....

  thanks and regards.

sorry for not mentioning the version it is 8.0.5 and now i careated new user with oracle8 and dba account as same one and tried out the fresh installation but still it repeated the same error. yes the home directory is seprate from the s/w directory in which i am installing.

oracle_home is /ora/oracle
and home directory is /ora
oracle_admin is /ora/oracle/app/oracle/admin

the error is the same

"There are still sgadef<sid>.dbf file(s) in $oracle_home/dbs. this indicates. you must shutdown all databased instances associated with this oracle_home befor upgrading the server. select (yes) if u have shutdown the instance form antother terminal/windw. Select (no) to abort the installation"

this is the total message, selecting yes repeates the same screen and selecting no throws me out...

thanks and regards...


"Suzy Vordos" <> wrote:

Again, which version of Oracle? That is importation info to solving the problem. A few more things to verify. Make sure the unix user oracle has a home directory separate from the software directory. Does the directory you want to install to exist? Here is an example from my environment:

$ id
uid=112(oracle) gid=101(dba)
$ echo $HOME

If you get any errors, include them in your reply


vipul desai wrote:
> Yes, i am trying for fres installation, when i got the box the person has
> removed the oracle s/w directory and database directory with rm command
> -fu | grep ora gives me no processes running again ipcs -ms also gives me
> shared memory or semaphors for oracle and under that case i don't know
> other could be the place where it is checking for the same..
> today i am going to remove oracle user and dba group create user and
> and then try the same out let me see what happens next if u have any other
> suggessation then please let me know..
> thanks and regards,
> -Vipul
> Suzy Vordos <> wrote:
> When you get the error, are you trying to install Oracle software, or
> create a database? What version of Oracle? If the error is still
> complaining that the sgadef<sid>.dbf file exists, the only place that
> file is written is $ORACLE_HOME/dbs, and only for Oracle7 and Oracle8
> (it's obsolete in Oracle8i). Otherwise, $ORACLE_HOME is the software
> directory only, and no database files should be stored there.
> Another possibility is there is no longer a physical database or
> sgadef<sid>dbf file, but something is still in memory. If ps -fu oracle
> returns no processes, also run ipcs -ms and see if any segments or
> semaphores are owned by oracle.
> Suzy
> vipul desai wrote:
> >
> > Hi there,
> >
> > thanks for your pormpt reply.
> >
> > I tried each and every step as sugested by Anil Sikri and to ensure i
> > tried steps given by Suzy Vordos. after ensuring that there are no more
> > unknown files on my box with oracle as owner i tried the fresh
> > again.
> >
> > But unfortunately i was not successful in the same and the same error
> > repeated... I doubt that unix stores some of the file paths at some
> > location and from that location it is trying to find the same.
> >
> > i tried to remove each and every file returned by find / -name oracle
> > -local -print ... i searched root for dbf file existance but it is not
> i
> > am sure that there is no file with oracle owner now and i am trying
> > installation.
> >
> > could u guide me more on the same.
> >
> > thanks in advance..
> >
> > -Vipul
> >

Get free email and a permanent address at
Author: vipul desai

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Aug 11 2000 - 05:45:33 CDT

Original text of this message