Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: urgent or oracle installation
Hi,
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.
Regards,
Kamal
-----Original Message-----
From: vipul desai [mailto:desaivipul_at_usa.net]
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.
-Vipul
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...
-Vipul
"Suzy Vordos" <lvordos_at_uswest.com> 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
/home/oracle
$ echo $ORACLE_ADMIN
/dbms/app/oracle/admin
$ echo $ORACLE_HOME
/dbms/app/oracle/product/8.1.6
If you get any errors, include them in your reply
Suzy
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
and
ps
> -fu | grep ora gives me no processes running again ipcs -ms also gives me
no
> shared memory or semaphors for oracle and under that case i don't know
what
> 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
group
> 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 <lvordos_at_uswest.com> 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
also
> > 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
installation
> > again.
> >
> > But unfortunately i was not successful in the same and the same error
got
> > repeated... I doubt that unix stores some of the file paths at some
other
> > 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
there
> i
> > am sure that there is no file with oracle owner now and i am trying
fresh
> > installation.
> >
> > could u guide me more on the same.
> >
> > thanks in advance..
> >
> > -Vipul
> >
-- Author: vipul desai INET: desaivipul_at_usa.net 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Aug 11 2000 - 05:45:33 CDT