Re: Upgrade from 8.1.6 to 8.1.7
Hi Hamid, We upgraded our peoplesoft db from 8.1.6 to 8.1.7 last year. This is just give you a reference check. You HAVE TO read the upgrade note do exactly what the notes said. Since all the platform is different, it might change the procedures according to your platforms. Joan Oracle 8.1.7 Database Upgrade 1) Backup db 2) . oraenv SID 3) run /oracle> . . profile817 => Set new oracle home,path..etc 4) from $OH/dbs, create soft link to parm file: ln -s /oracle/admin//pfile/init.ora init.ora ADD _system_trip_enabled=false to init.ora (after rollback_segments) 5) cd $OH/rdbms/admin 6) run another UNIX session and shutdown db under 8.1.6 7) go back to 8.1.7 session 8) svrmgrl 9) connect internal 10) startup restrict 11) ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; 12) spool _upgrade817.log 13) run conversion script (@u0801060.sql 14) ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF' 15) Change init.ora: _system_trig_enabled=true 16) Bounce db (shutdown, startup) 17) update /etc/oratab with new ORACLE_HOME for database Hamid Alavi wrote: > > Hi List, > I have asked this question twice but no answer at all, I don't know may be > is too easy or not related at all, I just want to know what I have to do for > upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have > any URL or link or any sort or documentation let me know. > Thanks & hope this time I get an answer. > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Joan Hsieh 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: Upgrade from 8.1.6 to 8.1.7
You should upgrde to 8.1.7.2 if not 8.1.7.3 and recompile all client programs. Don't stop at 8.1.7.1. -Original Message- Sent: Monday, January 28, 2002 8:50 AM To: Multiple recipients of list ORACLE-L technet.oracle.com go look for the documentation and read --- Hamid Alavi <[EMAIL PROTECTED]> wrote: > Hi List, > I have asked this question twice but no answer at all, I don't know > may be > is too easy or not related at all, I just want to know what I have to > do for > upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if > anybody have > any URL or link or any sort or documentation let me know. > Thanks & hope this time I get an answer. > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is > intended > only for the use of the individual or entity to which it is > addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt > from > disclosure under applicable law. If you have received this message in > error, > you are prohibited from copying, distributing, or using the > information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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: Wong, Bing 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: Upgrade from 8.1.6 to 8.1.7
Okay.. Click here : http://tahiti.oracle.com/pls/tahiti/tahiti.homepage Then Click on 'books' and then on 'mig' (for Migration Guide) then read Chapter 7, at least.. Bookmark this link for future reference... - Kirti -Original Message- Sent: Monday, January 28, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi List, I have asked this question twice but no answer at all, I don't know may be is too easy or not related at all, I just want to know what I have to do for upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have any URL or link or any sort or documentation let me know. Thanks & hope this time I get an answer. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Deshpande, Kirti 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: Upgrade from 8.1.6 to 8.1.7
Hello, I suggest that you go to 8.1.7.2.1, which we just did, from 8.1.6.3.0, and we used the any/all documents that we found on Meta-link. We upgraded on a test server first. Paul -Original Message- Sent: Monday, January 28, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hi List, I have asked this question twice but no answer at all, I don't know may be is too easy or not related at all, I just want to know what I have to do for upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have any URL or link or any sort or documentation let me know. Thanks & hope this time I get an answer. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Sherman, Paul R. 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: Upgrade from 8.1.6 to 8.1.7
technet.oracle.com go look for the documentation and read --- Hamid Alavi <[EMAIL PROTECTED]> wrote: > Hi List, > I have asked this question twice but no answer at all, I don't know > may be > is too easy or not related at all, I just want to know what I have to > do for > upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if > anybody have > any URL or link or any sort or documentation let me know. > Thanks & hope this time I get an answer. > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is > intended > only for the use of the individual or entity to which it is > addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt > from > disclosure under applicable law. If you have received this message in > error, > you are prohibited from copying, distributing, or using the > information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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).
