Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.cwix.com!skynet.be!skynet.be!newsfeeder.edisontel.com!nntp.infostrada.it!newsfeed.mclink.it!not-for-mail From: -={Giorgio}=- Newsgroups: comp.databases.oracle.server Subject: Re: 8i and 9i on same box Date: Fri, 10 Oct 2003 23:36:19 +0200 Organization: MC-link S.p.A. Lines: 25 Message-ID: References: <1065781597.80573.0@demeter.uk.clara.net> <1065801120.673351@yasure> <1065804728.95427.0@demeter.uk.clara.net> NNTP-Posting-Host: net203-173-222.mclink.it Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: newsreader1.mclink.it 1065821412 90060 213.203.173.222 (10 Oct 2003 21:30:12 GMT) X-Complaints-To: usenet@newsreader1.mclink.it NNTP-Posting-Date: Fri, 10 Oct 2003 21:30:12 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en, it In-Reply-To: <1065804728.95427.0@demeter.uk.clara.net> Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245083 Tom wrote: >>Just keep in mind the environment variables set in the various .profiles >>can only point to a single location. >>Take care to keep them straight. > > > thanks for the input all - I have installed both and they run fine - I have managed to create instances on both versions. > > My only query revolves around my profiles as Daniel points out. > > At the moment i have 2 seperate .profiles and actually just symlink between the two so i can decide which one to use when i log in. > Is there a better way to do it than this? Seems a bit messy to me but so far the only way i can get it to work correctly. I am quite positive you should be able to work it out with the oraenv script. Just launch int automatically from .profile and it should prompt you for the instance you want to connect to... moreover it should automatically set the environment by reading the oracle_home from the oratab file (provided you keep it updated) HTH /G