最近在做一个ERP项目

Author: Andy Rivenes ()
Copyright AppsDBA Consulting, all rights reserved
Last Updated: September 1, 1999

This is a checklist that can be used as a guideline for installing an Oracle Applications Release 10.7 system. The proper installation manuals, and especially supplemental release notes, must be used. This checklist details a "database tier" installation (e.g. the database and concurrent manager/character mode components). SmartClient and NCA installations have additional installation, patching and client setup requirements.

1. Follow the guidelines set forth in the AppsDBA Consulting document "Oracle Database and Oracle Applications Server Setup Guidelines".
   Note: This document is not currently available for distribution. However, the Oracle Applications Installation Manual and the platform and version specific Oracle Server Installation manual should be used as a guideline in setting up server hardware.
2. Call Oracle World Wide Support for any new patches or installation guidelines.
3. Configure the database server machine and create the oracle account.
4. Install Oracle Server software. See the AppsDBA Consulting document "Oracle Database Installation Guidelines" for details.
   Note: This document is not currently available for distribution. However, it is strongly recommended that an OFA installation be performed and that the platform and version specific Oracle Server Installation Guide be consulted.
5. Install Oracle Server patch sets and other patches if required.
6. Install the Developer/2000 software (specifically Oracle Reports with Motif support).   Note: Version 1.6.1 is now supported on some ports for the database tier, and if running the application tier on the same node a single ORACLE_HOME can be used.
7. Install Developer/2000 patches if required.
8. Database installation
9. Create the new database:
   • Verify that the Oracle Server software is configured (e.g. db_block_size and max_data_files)
   • Modify the sql.bsq file if necessary
   • Create the database
   • Configure the init.ora
   • Configure the rollback segments
   • Configure the redo logs

   For database upgrades:

   • Verify the init.ora
   • Configure the rollback segments
   • Configure the redo logs
   • Verify that archivelog mode is off
10. Install Oracle Applications required server patches if required (e.g. SQL*Report into ORACLE_HOME - rptpatch).
11. Create the appropriate SQL*Net files (e.g. listener.ora, sqlnet.ora, and tnsnames.ora entries) and test SQL*Net connectivity.
12. Create and setup the applmgr account.
13. Unload the Oracle Applications installation directory.
14. Install CRT and SQL*Forms 2.4 and run their installation scripts.
15. Apply any required interoperability patches (e.g. 7.3.4/8.0.x Interoperability patch).
16. Size and create the Oracle Applications tablespaces.
17. Run the initial Oracle Applications install utilities (e.g. adsetenv and adsetup).
18. Run the adprepdb.sql script.
19. Run the autoinstall process (e.g. adaimgr).
20. Install the multi-org patch, recommend installing regardless of actual multi-org usage.
21. Install any other required patches as detailed by the Oracle Applications installation manual or release notes.
22. Install the GUI generic server patches (see the SmartClient or NCA installation manual for specifics).
23. Install the SmartClient/NCA platform specific interoperability patches.
24. Perform SmartClient/NCA post-installation tasks.
25. Apply product level patch sets and Y2K bug fixes for products that will be used.
26. Configure the Report Review Agent and the Order Entry RPC as required. Strongly recommend using the Oracle Network Manager product supplied on the SmartClient 16.1 product CD.
27. Perform post-installation system administration tasks:
    • Setup and verify concurrent managers and queues
    • Setup and verify system profile options
    • Setup and verify printers
28. Perform post-installation database tasks:
    • Re-configure rollback segments
    • Re-configure sort parameters and possibly TEMP tablespace
    • Enable archivelog mode
29. Setup custom environment if required.
30. Run full backups of the database and all Oracle Server files (e.g. ORACLE_HOME) and Oracle Applications product files (e.g. APPL_TOP).
31. Setup UNIX scripts for environment management. See for more details.