RE: Oracle Applications Development Database Refresh
You will want to open a TAR on this. There is a lengthly procedure document that Oracle will provide for doing an Apps Clone on 11i. There are issues with just duplicating the executables and database. I got out of Apps on 10.7, but remember that a doc was being written by Oracle as of the 2001 Open World for 11i. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 08, 2002 11:43 PM To: Multiple recipients of list ORACLE-L If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: Oracle Applications Development Database Refresh
Be careful who you get when you open the tar... there is one chick in Denver who INSISTS on repeatedly reading you the whitepaper over the phone, and INSISTS that bad things CAN'T happen in a clone (they can... I have had two failed clones... one I believed them and manually fixed every file and it took a month to get it repaired... the other I did not believe them, restored and fixed it in two days). There is a white paper on Metalink that will walk you through it.. but make sure you have a good backup before you start. It is very straight forward and very step by step, but it can still fail. You do not have to do a fresh install before each clone, don't let anyone tell you different. You have to do ONE install on the target system. The procedure for 11i is (from what I understand) much easier than for 10.7. April Wells Oracle DBA (Oracle OCP 8, 8i) Corporate Systems Amarillo Texas -Original Message- Sent: Tuesday, July 09, 2002 7:43 AM To: Multiple recipients of list ORACLE-L You will want to open a TAR on this. There is a lengthly procedure document that Oracle will provide for doing an Apps Clone on 11i. There are issues with just duplicating the executables and database. I got out of Apps on 10.7, but remember that a doc was being written by Oracle as of the 2001 Open World for 11i. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 08, 2002 11:43 PM To: Multiple recipients of list ORACLE-L If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read
RE: Oracle Applications Development Database Refresh
Hi all, Looks like we have a fair bunch of Oracle Apps DBAs on this list! The issues of cloning for 10.7 (various flavors), 11 and 11i are quiet different from each other. This is mostly because the underlying technical architecture has changed between each of these versions. Have a look at the following link for a collection of the most comprehensive papers on this subject. http://www.dbatoolbox.com/Content/cloning_wp.htm 11i cloning can be done 'officially' using the adclone utility, but this is cumbersome. Unofficially, there are a variety of methods that are addressed in these links. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Be careful who you get when you open the tar... there is one chick in Denver who INSISTS on repeatedly reading you the whitepaper over the phone, and INSISTS that bad things CAN'T happen in a clone (they can... I have had two failed clones... one I believed them and manually fixed every file and it took a month to get it repaired... the other I did not believe them, restored and fixed it in two days). There is a white paper on Metalink that will walk you through it.. but make sure you have a good backup before you start. It is very straight forward and very step by step, but it can still fail. You do not have to do a fresh install before each clone, don't let anyone tell you different. You have to do ONE install on the target system. The procedure for 11i is (from what I understand) much easier than for 10.7. April Wells Oracle DBA (Oracle OCP 8, 8i) Corporate Systems Amarillo Texas -Original Message- Sent: Tuesday, July 09, 2002 7:43 AM To: Multiple recipients of list ORACLE-L You will want to open a TAR on this. There is a lengthly procedure document that Oracle will provide for doing an Apps Clone on 11i. There are issues with just duplicating the executables and database. I got out of Apps on 10.7, but remember that a doc was being written by Oracle as of the 2001 Open World for 11i. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 08, 2002 11:43 PM To: Multiple recipients of list ORACLE-L If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217
RE: Oracle Applications Development Database Refresh
Thanks, April, John Kanagaraj John Weatherman, I will look thru' all the papers before I migrate my Oracle Apps 11I from E450 to Sun Fire 6800. Thanks so much for your help. Regds, Catherine -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 1:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Development Database Refresh Hi all, Looks like we have a fair bunch of Oracle Apps DBAs on this list! The issues of cloning for 10.7 (various flavors), 11 and 11i are quiet different from each other. This is mostly because the underlying technical architecture has changed between each of these versions. Have a look at the following link for a collection of the most comprehensive papers on this subject. http://www.dbatoolbox.com/Content/cloning_wp.htm 11i cloning can be done 'officially' using the adclone utility, but this is cumbersome. Unofficially, there are a variety of methods that are addressed in these links. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Be careful who you get when you open the tar... there is one chick in Denver who INSISTS on repeatedly reading you the whitepaper over the phone, and INSISTS that bad things CAN'T happen in a clone (they can... I have had two failed clones... one I believed them and manually fixed every file and it took a month to get it repaired... the other I did not believe them, restored and fixed it in two days). There is a white paper on Metalink that will walk you through it.. but make sure you have a good backup before you start. It is very straight forward and very step by step, but it can still fail. You do not have to do a fresh install before each clone, don't let anyone tell you different. You have to do ONE install on the target system. The procedure for 11i is (from what I understand) much easier than for 10.7. April Wells Oracle DBA (Oracle OCP 8, 8i) Corporate Systems Amarillo Texas -Original Message- Sent: Tuesday, July 09, 2002 7:43 AM To: Multiple recipients of list ORACLE-L You will want to open a TAR on this. There is a lengthly procedure document that Oracle will provide for doing an Apps Clone on 11i. There are issues with just duplicating the executables and database. I got out of Apps on 10.7, but remember that a doc was being written by Oracle as of the 2001 Open World for 11i. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Monday, July 08, 2002 11:43 PM To: Multiple recipients of list ORACLE-L If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:25 AM
RE: Oracle Applications Development Database Refresh
Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Oracle Applications Development Database Refresh
Jared, I *think* this is 10.7 character. It would be if your users use a VT terminal emulator to access the application. Be aware though that a combination of Character/Smart client could exist... In this case, it does not matter though as the work that you would do will be the same. I don't believe it is NCA ( isn't that the Java Workstation version? You know, the one at Open World that never worked? ;) If you used any form-type interface within a Browser, then it would be NCA. There are some web based elements though, such as Self Server Web Apps. The difference is that NCA works like a form (Enter/Execute Query for e.g.) while the SSWA is a pure Web-type interface. How would I identify Smart Client? The Smart Client set consists of the Application (Forms) working off either a 'Client' PC. In most cases, this is via a shared service such as Citrix - on a Windows box in any case. In other words a very thick (smart!?!?!) client. Scott S - In many cases, the Apps SysAdmin performs the work on the 'applmgr' and related APPS/APPLSYS accounts after the Db/Appltop copy and the DBA is not involved. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Oracle Applications Development Database Refresh
Gotchya. Thanks, that's why I wasn't sure what had to be done there. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Scott S - In many cases, the Apps SysAdmin performs the work on the 'applmgr' and related APPS/APPLSYS accounts after the Db/Appltop copy and the DBA is not involved. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Oracle Applications Development Database Refresh
Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: 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: Oracle Applications Development Database Refresh
Thanks John. Definitely not NCA. Definitely not using terminal emulation, so it must be the smart client. I'll take a whack at it using your instructions as soon as I can get to it. The dev instance is on the same (underpowered) box as production server. I don't yet know if this simplifies things, or complicates them. Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 12:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, I *think* this is 10.7 character. It would be if your users use a VT terminal emulator to access the application. Be aware though that a combination of Character/Smart client could exist... In this case, it does not matter though as the work that you would do will be the same. I don't believe it is NCA ( isn't that the Java Workstation version? You know, the one at Open World that never worked? ;) If you used any form-type interface within a Browser, then it would be NCA. There are some web based elements though, such as Self Server Web Apps. The difference is that NCA works like a form (Enter/Execute Query for e.g.) while the SSWA is a pure Web-type interface. How would I identify Smart Client? The Smart Client set consists of the Application (Forms) working off either a 'Client' PC. In most cases, this is via a shared service such as Citrix - on a Windows box in any case. In other words a very thick (smart!?!?!) client. Scott S - In many cases, the Apps SysAdmin performs the work on the 'applmgr' and related APPS/APPLSYS accounts after the Db/Appltop copy and the DBA is not involved. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: 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: Oracle Applications Development Database Refresh
My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: 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: 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: Oracle Applications Development Database Refresh
Thanks Scott, I'll give that a try first. Jared [EMAIL PROTECTED] 07/08/2002 02:21 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To:Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: 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: 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: Oracle Applications Development Database Refresh
If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db and the applmgr stuff works fine with 10.7. Its sloppier than restoring the appl_top as well, but works. 11/11i being an entirely different animal. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Applications Development Database Refresh Thanks Scott, but the applmgr stuff is where the details are. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Applications Development Database Refresh Jared, we do that here, but just: take a cold backup of the production db, lay it down over the old dev db (via scp or tape), and open it renaming with a backup cpontrolfile script. Works like a charm, though I'm not sure what applmgr steps are required. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 5:43 PM To:Multiple recipients of list ORACLE-L Subject: Oracle Applications Development Database Refresh Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. If you can point me to the correct documentation for this, I'll take a look at it. There's a lot of stuff to wade through in the docs and MetaLink, and I'd rather just read documentation that's actually relevant. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Oracle Applications Development Database Refresh
Jared, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. I haven't read any official documentation for 10.7 'cloning' (as the Apps-aware call it). However, it is pretty simple compared to 11.0 and 11i if this is NOT 10.7 NCA. In addition, this also changes if you are using 10.7 Character, 10.7 SC (Smart Client) or 10.7 NCA, so do let us know. In simple terms, you will have to do the following (assuming you have a copy - hot or cold - of the DB): On the Application/Database server side: 1. Copy over the APPL_TOP/Custom top (basically all owned by 'applmgr') and Database files to the respective locations. Adjust the environment variables for log/TOP locations including APPLCSF (conc. program output logs) and any Custom tops. I assume you already have ORACLE_HOME copied over and setup (with envs, etc.) - this does not change frequently. 2. Change the listener ports for the database, FNDFS listener and OEORPC listener if required. 3. Startup the Database and listeners - recover to a point in time if from a hot backup. Do NOT startup the Concurrent Managers yet. Delete _ANY_ DBlinks that point to other production systems - this may cause some Invalid objects, and you may have to ignore/fix them as the case may be. 4. Change the global name (alter database rename global_name ..) 5. Reset all Alerts from 'Enabled' to 'Disabled'. This can be achieved either from the Alerts form or using the following SQL (unless you want to do this off the Alerts screen!): update applsys. alr_alerts set enabled_flag = 'N' where enabled_flag = 'Y'; This will disable all alerts and avoid erroneous messages to Users/Functional folks. 6. Update all pending jobs to reset copies to print. This is to avoid double-printing when you (or someone else) turn on some of the Concurrent jobs back on - at least you can avoid confusion from double-printing of reports. This can be done using the following SQL: UPDATE APPS.FND_CONCURRENT_REQUESTS SET NUMBER_OF_COPIES = 0; 7. Startup your forms interface (not the Concurrent Manager) and go to the Profiles screen (or the Profile-System form). Modify profile options: Query OE: Transaction Manager - change to the OEORPC listener name Query Site Name - change to the right name (this changes the Help-About information in forms) 8. Change the APPS/APPLSYS and other schema passwords. Open a SQL*Plus using 'SYSTEM' or a DBA account in a separate window. Open the 'Security-ORACLE-Register' (Oracle Users) screen. Enter the Password twice for each of APPLSYS, APPS and schemas and Commit, making sure that you change the corresponding Oracle user (APPLSYS/APPS/Schema) as you change them. It is critical to commit this, and make sure that this does not break inbetween - as the APPLSYS/APPS password combination needs to be correct and match in both the internal FND tables as well as the SYS.USER$ tables... You may also have to reset the SYSADMIN passwords. 9. I would also cancel all pending concurrent jobs before starting up the Concurrent Manager, but that is something that you will need to agree with the functional folks. If this is Ok, you can use the following SQL: update apps.fnd_concurrent_requests set phase_code = 'C', status_code = 'D' where phase_code = 'P'; 10. Startup the Concurrent Managers (using 'applmgr' account!) and watch the logs in $APPLCSF/logDB/*.mgr for any problems/issues. 11. You may also choose to resize the Queue sizes on the Dev instance. This reduces the number of processes that start up from the CM. This can be done from the 'Concurrent Managers' screen (Concurrent-Manager-Define) - click on the 'Work Shifts' button and change the value in 'Processes'. The Internal Manager will reduce this number at the next cycle. Depending on your customizations and environment, you may have to perform some additional steps. I have not included the steps for the Client side : I will have to know what you use and can suggest what needs to be done. This is off some of our internal documentation - I have given you the essentials that should make sense in a general Apps installation. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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:
Re: Oracle Applications Development Database Refresh
Thanks John! I *think* this is 10.7 character. I don't believe it is NCA ( isn't that the Java Workstation version? You know, the one at Open World that never worked? ;) How would I identify Smart Client? Thanks, Jared On Friday 05 July 2002 17:03, John Kanagaraj wrote: Jared, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle Apps. The problem is a request I have to refresh the Dev database from the Production database. I haven't read any official documentation for 10.7 'cloning' (as the Apps-aware call it). However, it is pretty simple compared to 11.0 and 11i if this is NOT 10.7 NCA. In addition, this also changes if you are using 10.7 Character, 10.7 SC (Smart Client) or 10.7 NCA, so do let us know. In simple terms, you will have to do the following (assuming you have a copy - hot or cold - of the DB): On the Application/Database server side: 1. Copy over the APPL_TOP/Custom top (basically all owned by 'applmgr') and Database files to the respective locations. Adjust the environment variables for log/TOP locations including APPLCSF (conc. program output logs) and any Custom tops. I assume you already have ORACLE_HOME copied over and setup (with envs, etc.) - this does not change frequently. 2. Change the listener ports for the database, FNDFS listener and OEORPC listener if required. 3. Startup the Database and listeners - recover to a point in time if from a hot backup. Do NOT startup the Concurrent Managers yet. Delete _ANY_ DBlinks that point to other production systems - this may cause some Invalid objects, and you may have to ignore/fix them as the case may be. 4. Change the global name (alter database rename global_name ..) 5. Reset all Alerts from 'Enabled' to 'Disabled'. This can be achieved either from the Alerts form or using the following SQL (unless you want to do this off the Alerts screen!): update applsys. alr_alerts set enabled_flag = 'N' where enabled_flag = 'Y'; This will disable all alerts and avoid erroneous messages to Users/Functional folks. 6. Update all pending jobs to reset copies to print. This is to avoid double-printing when you (or someone else) turn on some of the Concurrent jobs back on - at least you can avoid confusion from double-printing of reports. This can be done using the following SQL: UPDATE APPS.FND_CONCURRENT_REQUESTS SET NUMBER_OF_COPIES = 0; 7. Startup your forms interface (not the Concurrent Manager) and go to the Profiles screen (or the Profile-System form). Modify profile options: Query OE: Transaction Manager - change to the OEORPC listener name Query Site Name - change to the right name (this changes the Help-About information in forms) 8. Change the APPS/APPLSYS and other schema passwords. Open a SQL*Plus using 'SYSTEM' or a DBA account in a separate window. Open the 'Security-ORACLE-Register' (Oracle Users) screen. Enter the Password twice for each of APPLSYS, APPS and schemas and Commit, making sure that you change the corresponding Oracle user (APPLSYS/APPS/Schema) as you change them. It is critical to commit this, and make sure that this does not break inbetween - as the APPLSYS/APPS password combination needs to be correct and match in both the internal FND tables as well as the SYS.USER$ tables... You may also have to reset the SYSADMIN passwords. 9. I would also cancel all pending concurrent jobs before starting up the Concurrent Manager, but that is something that you will need to agree with the functional folks. If this is Ok, you can use the following SQL: update apps.fnd_concurrent_requests set phase_code = 'C', status_code = 'D' where phase_code = 'P'; 10. Startup the Concurrent Managers (using 'applmgr' account!) and watch the logs in $APPLCSF/logDB/*.mgr for any problems/issues. 11. You may also choose to resize the Queue sizes on the Dev instance. This reduces the number of processes that start up from the CM. This can be done from the 'Concurrent Managers' screen (Concurrent-Manager-Define) - click on the 'Work Shifts' button and change the value in 'Processes'. The Internal Manager will reduce this number at the next cycle. Depending on your customizations and environment, you may have to perform some additional steps. I have not included the steps for the Client side : I will have to know what you use and can suggest what needs to be done. This is off some of our internal documentation - I have given you the essentials that should make sense in a general Apps installation. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L
