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

When you say "oracle directory", do you mean the Oracle software or a database?

The following may be overly cautious and paranoid... BUT, before removing or re-installing anything, I'd like to know exactly what is there. The presence of $ORACLE_HOME/dbs/sga*.dbf is a strong indication that a database does (or did) exist.

Check for any running database instances:

$ ps -fu oracle

Check $HOME/.profile, what environment variables are defined? This will give you clues where to look for Oracle software-related files.

If the Oracle software had been removed, then $ORACLE_HOME/dbs/sga*.dbf wouldn't be found. Check what versions are installed, look for init.ora, config.ora, listener.ora, tnsnames.ora files:

$ echo $ORACLE_HOME ; ls -l $ORACLE_HOME
$ ls -l $ORACLE_HOME/../
$ echo $ORACLE_ADMIN ; ls -lR $ORACLE_ADMIN
$ echo $TNS_ADMIN ; ls -l $TNS_ADMIN

Look for all the sgadef<sid>.dbf files, this will tell you what databases are (or were) there:

$ ls $ORACLE_HOME/../*/dbs/sgadef*.dbf

Search the system for all files owned by the oracle user, then closely review the output in $HOME/outfile.txt. Anything look like a database file? Locate and review the oratab file, it will tell you what databases are/were there.

$ find / -user oracle -local -print > $HOME/outfile.txt

Hope this helps,
Suzy

vipul desai wrote:
>
> 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
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --
> 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-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 10 2000 - 00:42:05 CDT