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

From: Anil Sikri <anil_sikri_at_hotmail.com>
Date: Wed, 09 Aug 2000 23:49:09 CDT
Message-Id: <10584.114240@fatcity.com>

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.

Anil Sikri
Sr. Oracle DBA

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Wed Aug 09 2000 - 23:49:09 CDT