Message-Id: <10586.114340@fatcity.com> From: "Kamalakannan, D (CAP, GCF)" Date: Fri, 11 Aug 2000 12:47:14 +0200 Subject: RE: urgent or oracle installation do a search with repect to user - find / -user oracle Might be this solves your problem, Regards, Kamal -----Original Message----- From: vipul desai [mailto:desaivipul@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.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" 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 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.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 > sgadefdbf 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 > > ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Author: vipul desai INET: desaivipul@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@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L