Re: sanity check

Yes you can move or copy the init and config (if you have one) to the new version directory and start the db. Don't forget your environment variables. I would suggest changing your oratab file to point to the 817 directory. That way you can use oraenv, coraenv and dbhome to ensure your environment is set. Also if you have any home grown scripts which set environments, check them out.

Don't forget about sqlnet/net8. Check your listener.ora file, or if you run multiple listeners, check your tnsnames file for the correct port.

After it is up and running, don't forget to run any conversion scripts required to migrate from one version to the other.

Disclaimer: my advice is for Unix only, if you are on NT, I haven't a clue.

Good luck,
John

>>> ThaterW_at_telergy.net 11/16/01 10:00AM >>>
i have a development server with 815, 816, 817 installed [don't ask.].  we have suspended development at this point in time and shut down the server.

AFAIK, if i move the correct init<SID>.ora files into the dbs directory for 817, it should read the control files for the other versions and open the databases. am i missing anything here?

and yes i know i could just try it and i would if i was given the chance. [again don't ask.]

-- 
--
Bill "Shrek" Thater              ORACLE DBA
Telergy,Inc.                   thaterw_at_telergy.net 
------------------------------------------------------------------------
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
------------------------------------------------------------------------
This login session:  $13.76, but for you:  $11.88.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Thater, William
  INET: ThaterW_at_telergy.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
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Carlson
  INET: jcarlson_at_CJ.COM

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
also send the HELP command for other information (like subscribing).