Re: urgent help on oracle installation.....

Original Message -----------------------------
>Hi there,>
I am installing oracle on sun box, but it is giving me problem...
"There are still sgadef<SID>.dbf file in $ORACLE_HOME. This
indicates tat there may still be running instance. you must shutdown
all database instances associated with this oracle_home before
updateing the server"
as per my knowledge oracle was installed on this box but someone
deleted oracle directory with rm command and now i am trying to
reinstall i am facing this porblem.
i am not sure on the other related files and related settings on the
unix could any one please show me the correct direction to remove
all other dependent files so that i can do fresh installation...

> thanks in advance...>> -Vipul

Hi Vipul,

Perform the following steps connected to the Sun box
as the oracle user :
1) Check for any of the Oracle background processes by
doing a ps -aef|grep ora_ at the shell prompt. If you see
any of these processes, kill them by doing a kill -9 <pid>
at the shell prompt. The <pid> is the process ID of eacho of
these processes which can be retrieved from the above 'ps'
command.
2) You might have to manually remove any shared memory
segments and semaphores still hanging out there.
To remove shared memory segments owned by oracle:
------------------------------------------------
Do an ipcs -m at the shell prompt to determine the IDs of
the shared memory segments owned by oracle.
Execute an ipcrm -m <ID> for each of the shared memory
segments owned by oracle where <ID> is retrieved as
described above using ipcs -m.
To remove semaphores owned by oracle:
------------------------------------
Do an ipcs -s at the shell prompt to determine the IDs of
the semaphores owned by oracle.
Execute an ipcrm -s <ID> for each of the semaphores
owned by oracle where <ID> is retrieved as described above
using ipcs -s .
3) Now remove any sgadef.dbf files in $ORACLE_HOME/dbs.
4) Also make sure that the listener is down by executing
$ORACLE_HOME/bin/lsnrctl stop at the shell prompt.
5) Remove all the oracle binaries.

You are all set to install the new oracle binaries.
Let me know if you have any problems.