create oracle db before or after
List, server Alpha ES40 O.S. OpenVMS 7.2-1 Oracle 8.1.7 rel 3 We are starting to migrate our database from a Novell server with Oracle 7.3.4 to the OpenVMS platform and I have a question that needs answers or suggestions. The sysadmin has set up the required OS parameters that I could find listed in the notes and on Metalink. There are a lot of OS patches recommended by Oracle for this version of the OS and the sysadmin is looking into them. The sysadmin would like to upgrade the system to OS 7.3 in the near furure (09/02-03/02) rather than apply the patches and then upgrade the OS down the road. What would be the effect on the database if I created a database today and then the sysadmin upgraded the OS in 2 weeks? Would I have to do any major reconfiguring or rebuilding? Would it really matter to the operation of the database? What steps as far as Oracle is concerned should I pay attention to and perform? Would your recommend that I not create the database until after the OS is upgraded and stable? Thanks, Ron ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: create oracle db before or after
well, if you can hold off on creating the database until the OS changes are done, I would, if only to prevent extra work otherwise after I created the database and before the OS changes were done I would a) backup all Oracle executables b) backup the database c) export the database and backup the dump file then shutdown the database and let the SA do the upgrade. Relink the Oracle executables, checking for errors (missing library files, bad paths etc) Re-open the database... if the relink went well, you should be able to just open the database with no problems. If not, you have the backups to go back to --- Ron Rogers [EMAIL PROTECTED] wrote: List, server Alpha ES40 O.S. OpenVMS 7.2-1 Oracle 8.1.7 rel 3 We are starting to migrate our database from a Novell server with Oracle 7.3.4 to the OpenVMS platform and I have a question that needs answers or suggestions. The sysadmin has set up the required OS parameters that I could find listed in the notes and on Metalink. There are a lot of OS patches recommended by Oracle for this version of the OS and the sysadmin is looking into them. The sysadmin would like to upgrade the system to OS 7.3 in the near furure (09/02-03/02) rather than apply the patches and then upgrade the OS down the road. What would be the effect on the database if I created a database today and then the sysadmin upgraded the OS in 2 weeks? Would I have to do any major reconfiguring or rebuilding? Would it really matter to the operation of the database? What steps as far as Oracle is concerned should I pay attention to and perform? Would your recommend that I not create the database until after the OS is upgraded and stable? Thanks, Ron ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: create oracle db before or after
Rachel, Thanks for the feedback. I guess that the Oracle/OS upgrade issue and precautions are the same across all OS's. I am new to OpenVMS and wanted to make sure that there were not any hidden issues. Thanks again, Ron [EMAIL PROTECTED] 08/15/02 10:38AM well, if you can hold off on creating the database until the OS changes are done, I would, if only to prevent extra work otherwise after I created the database and before the OS changes were done I would a) backup all Oracle executables b) backup the database c) export the database and backup the dump file then shutdown the database and let the SA do the upgrade. Relink the Oracle executables, checking for errors (missing library files, bad paths etc) Re-open the database... if the relink went well, you should be able to just open the database with no problems. If not, you have the backups to go back to --- Ron Rogers [EMAIL PROTECTED] wrote: List, server Alpha ES40 O.S. OpenVMS 7.2-1 Oracle 8.1.7 rel 3 We are starting to migrate our database from a Novell server with Oracle 7.3.4 to the OpenVMS platform and I have a question that needs answers or suggestions. The sysadmin has set up the required OS parameters that I could find listed in the notes and on Metalink. There are a lot of OS patches recommended by Oracle for this version of the OS and the sysadmin is looking into them. The sysadmin would like to upgrade the system to OS 7.3 in the near furure (09/02-03/02) rather than apply the patches and then upgrade the OS down the road. What would be the effect on the database if I created a database today and then the sysadmin upgraded the OS in 2 weeks? Would I have to do any major reconfiguring or rebuilding? Would it really matter to the operation of the database? What steps as far as Oracle is concerned should I pay attention to and perform? Would your recommend that I not create the database until after the OS is upgraded and stable? Thanks, Ron ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
