管理器、并发-EBS 生产环境并发管理器重启步骤详解--经验啊-by小雨

首先声明，我是一个菜鸟。一下文章中出现技术误导情况盖不负责

    重启并发管理器

    上面都是应用用户

 

    一、止停并发管理器
 
 cd $ADMIN_SCRIPTS_HOME
 adcmctl.sh stop apps/apps

    
二、 录登应用用户
 ps -fu appprod,找FNDLIBR程进 返回PID

 kill  -9 -PID
 
三、
    FNDSM会主动失消

 

    四、 PLSQL录登后，Tools >> Sessions >>

     按照Program 列找FNDSM的Session，kill掉。

    五、清算并发管理器底层表

 

 $ id
 uid=233(appl02) gid=502(dba)
 $ pwd
 /u05/CCTEST02/inst/apps/CCTEST02_test01/admin/scripts
 $ cd
 $ ls
 HRMS121.sql                           elshu                                 p9323105_R12.BOM.C_R12_AIX64-5L.zip
 HRMS121_CCTEST02_29-May-2012.txt      linka                                 poapprv_final.wft
 HR_UPGRADE                            p12964564_R12.FND.B_R12_AIX64-5L.zip  prefs.ora
 Mail                                  p13692065_R12.PER.B_R12_GENERIC.zip   roren
 aegean                                p13692065_R12.PER.B_R12_zhs.zip       scaler
 cmclean.sql                           p13715802_R12.PER.B_R12_AIX64-5L.zip  sqlnet.log
 download_tool_n.sh                    p8743459_R12.FND.B_R12_GENERIC.zip
 $ sqlplus apps/apps

 SQL*Plus: Release 10.1.0.5.0 - Production on Thu Oct 18 17:29:22 2012

 Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    
 Connected to:
 Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
 With the Partitioning, OLAP, Data Mining and Real Application Testing options

 SQL> @cmclean.sql
 DOC>
 DOC>   WARNING : Do not run this script without explicit instructions
 DOC>             from Oracle Support
 DOC>
 DOC>
 DOC>   *** Make sure that the managers are shut down     ***
 DOC>   *** before running this script                    ***
 DOC>
 DOC>   *** If the concurrent managers are NOT shut down, ***
 DOC>   *** exit this script now !!                       ***
 DOC>
 DOC>#
 If you wish to continue type the word 'dual': dual

 

 -----------------------------------------------------------------------
 -- Updating invalid process status codes in FND_CONCURRENT_PROCESSES

 Manager short name   Process id Status code
 -------------------- ---------- ------------
 RCVOLTM                  663235 Z
     663236 Z
     663237 Z
     663240 Z
     663245 Z
  ................................................................
     663464 Z
     663465 Z
     663466 Z
 CRPINQMGR                663467 Z
     663468 Z
     663469 Z
 STANDARD                 663470 Z
     663471 Z
     663472 Z
     663473 Z
     663474 Z
     663476 Z
 FNDICM                   663482 A
 FNDSM_TEST01             663483 A
 FNDCPOPP                 663484 A
 STANDARD                 663544 A

 236 rows updated.

    
 -----------------------------------------------------------------------
 -- Updating running processes in FND_CONCURRENT_QUEUES
 -- Setting running_processes = 0 and max_processes = 0 for all managers

 52 rows updated.

    
 -----------------------------------------------------------------------
 -- Updating invalid control_codes in FND_CONCURRENT_QUEUES

 0 rows updated.

    
 52 rows updated.

    
 -----------------------------------------------------------------------
 -- Updating any Running or Terminating requests to Completed/Error

 Request ID Phase  Status
 ---------- ------ ------
   15395890 R      W

 1 row updated.

    
 -----------------------------------------------------------------------
 -- Updating any Runalone flags to 'N'

 Updated 0 rows of runalone_flag in fnd_conflicts_domain to 'N'

 -----------------------------------------------------------------------
 Updates complete.
 Type commit now to commit these updates, or rollback to cancel.
 -----------------------------------------------------------------------

 SQL> commit;

 Commit complete.

 SQL> !
 $ ID
 /usr/bin/ksh: ID:  not found.
 $ id
 uid=233(appl02) gid=502(dba)
 $ owd
 /usr/bin/ksh: owd:  not found.
 $ pwd
 /home/appl02
 $ ls

    解压压缩包

    
 $ cd HR_UPGRADE/
 $ ls
 10252312                                9239089                                 p13102462_R12.PAY.B_R12_GENERIC.zip
 10281212_ZHS                            9817770                                 p13692065_R12.PER.B_R12_GENERIC.zip
 12679370                                9966055                                 p13692065_R12.PER.B_R12_zhs.zip
 12964564                                L5382089.log                            p13715802_R12.PER.B_R12_AIX64-5L.zip
 12964564_ZHS                            L5382092.log                            p13715802_R12.PER.B_R12_zhs.zip
 13102462                                p10252312_R12.FND.B_R12_GENERIC.zip     p8919491_R12.ATG_PF.B_R12_AIX64-5L.zip
 13692065                                p10281212_R12.HR_PF.B_R12_AIX64-5L.zip  p8919491_R12.ATG_PF.B_R12_zhs.zip
 13692065_ZHS                            p10281212_R12.HR_PF.B_R12_zhs.zip       p9239089_R12.AD.B_R12_AIX64-5L.zip
 13715802                                p12679370_R12.PAY.B_R12_GENERIC.zip     p9817770_R12.ATG_PF.B_R12_AIX64-5L.zip
 13715802_ZHS                            p12923944_R12.FND.B_R12_AIX64-5L.zip    p9966055_R12.FND.B_R12_GENERIC.zip
 8919491                                 p12964564_R12.FND.B_R12_AIX64-5L.zip
 8919491_ZHS                             p12964564_R12.FND.B_R12_zhs.zip
 $ unzip p12923944_R12.FND.B_R12_AIX64-5L.zip

 $ cd 12923944    --------进解压后的目录
 $ ls             --------表列目录内文件     
 README.html         ad                  f12923944.ldt       marker1.txt         u12923944.drv
 README.txt          b12923944.ldt       fnd                 patch_metadata.xml
 $ ll
 total 136
 drwxr-xr-x    4 appl02   dba            4096 Oct 18 17:58 ./
 drwxr-xr-x   18 appl02   dba            4096 Oct 18 17:58 ../
 -rw-rw-r--    1 appl02   dba            5971 Aug 30 2011  README.html
 -rw-rw-r--    1 appl02   dba            3168 Aug 30 2011  README.txt
 drwxr-xr-x    3 appl02   dba             256 Oct 18 17:58 ad/
 -rw-rw-r--    1 appl02   dba            3061 Aug 29 2011  b12923944.ldt
 -rw-rw-r--    1 appl02   dba           18017 Aug 30 2011  f12923944.ldt
 drwxr-xr-x    4 appl02   dba             256 Oct 18 17:58 fnd/
 -rw-rw-r--    1 appl02   dba              49 Aug 29 2011  marker1.txt
 -rw-rw-r--    1 appl02   dba            1616 Aug 30 2011  patch_metadata.xml
 -rw-rw-r--    1 appl02   dba           15510 Aug 29 2011  u12923944.drv

    打开运维模式

 $ id
 uid=233(appl02) gid=502(dba)
 $ adadmin

        Copyright (c) 2002 Oracle Corporation
    Redwood Shores, California, USA

        Oracle Applications AD Administration

      Version 12.0.0

 NOTE: You may not use this utility for custom development
       unless you have written permission from Oracle Corporation.

 Your default directory is '/u05/CCTEST02/apps/apps_st/appl'.
 Is this the correct APPL_TOP [Yes] ? YES

 AD Administration records your AD Administration session in a text file
 you specify.  Enter your AD Administration log file name or press [Return]
 to accept the default file name shown in brackets.

 Filename [adadmin.log] :

 ************* Start of AD Administration session *************
 AD Administration version: 12.0.0
 AD Administration started at: Thu Oct 18 2012 18:11:11

 APPL_TOP is set to /u05/CCTEST02/apps/apps_st/appl

 You can be notified by email if a failure occurs.
 Do you wish to activate this feature [No] ?

 Please enter the batchsize [1000] :

    
 Please enter the name of the Oracle Applications System that this
 APPL_TOP belongs to.

 The Applications System name must be unique across all Oracle
 Applications Systems at your site, must be from 1 to 30 characters
 long, may only contain alphanumeric and underscore characters,
 and must start with a letter.

 Sample Applications System names are: "prod", "test", "demo" and
 "Development_2".

 Applications System Name [CCTEST02] : CCTEST02 *

    
 NOTE: If you do not currently have certain types of files installed
 in this APPL_TOP, you may not be able to perform certain tasks.

 Example 1: If you don't have files used for installing or upgrading
 the database installed in this area, you cannot install or upgrade
 the database from this APPL_TOP.

 Example 2: If you don't have forms files installed in this area, you cannot
 generate them or run them from this APPL_TOP.

 Example 3: If you don't have concurrent program files installed in this area,
 you cannot relink concurrent programs or generate reports from this APPL_TOP.

    
 Do you currently have files used for installing or upgrading the database
 installed in this APPL_TOP [YES] ? YES *

    
 Do you currently have Java and HTML files for HTML-based functionality
 installed in this APPL_TOP [YES] ? YES *

    
 Do you currently have Oracle Applications forms files installed
 in this APPL_TOP [YES] ? YES *

    
 Do you currently have concurrent program files installed
 in this APPL_TOP [YES] ? YES *

    
 Please enter the name Oracle Applications will use to identify this APPL_TOP.

 The APPL_TOP name you select must be unique within an Oracle Applications
 System, must be from 1 to 30 characters long, may only contain
 alphanumeric and underscore characters, and must start with a letter.

 Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

 APPL_TOP Name [test01] : test01 *

 

 You are about to use or modify Oracle Applications product tables
 in your ORACLE database 'CCTEST02'
 using ORACLE executables in '/u05/CCTEST02/apps/tech_st/10.1.2'.

 Is this the correct database [Yes] ? yes

 AD Administration needs the password for your 'SYSTEM' ORACLE schema
 in order to determine your installation configuration.

 Enter the password for your 'SYSTEM' ORACLE schema: 

 ...Unable to connect.

 AD Administration error:
 The following ORACLE error:

 ORA-01017: invalid username/password; logon denied

    
 occurred while executing the SQL statement:

 CONNECT SYSTEM/*****

 AD Administration error:
 Unable to connect to 'SYSTEM'; password may be invalid.

 AD Administration needs the password for your 'SYSTEM' ORACLE schema
 in order to determine your installation configuration.

 Enter the password for your 'SYSTEM' ORACLE schema: 

    
 The ORACLE username specified below for Application Object Library
 uniquely identifies your existing product group: APPLSYS

 Enter the ORACLE password of Application Object Library [APPS] : 

 AD Administration is verifying your username/password.
 The status of various features in this run of AD Administration is:

         <-Feature version in->
 Feature                          Active?   APPLTOP    Data model    Flags
 ------------------------------   -------   --------   -----------   -----------
 CHECKFILE                        Yes       1          1             Y N N Y N Y
 PREREQ                           Yes       6          6             Y N N Y N Y
 CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
 PATCH_TIMING                     Yes       2          2             Y N N Y N Y
 PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
 SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
 JAVA_WORKER                      Yes       1          1             Y N N Y N Y
 CODELEVEL                        Yes       1          1             Y N N Y N Y

 

 Identifier for the current session is 83929

 Reading product information from file...

 Reading language and territory information from file...

 Reading language information from applUS.txt ...

 AD Administration warning:
  Product Data File
  /u05/CCTEST02/apps/apps_st/appl/admin/zfaprod.txt
  does not exist for product "zfa".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.

    
 AD Administration warning:
  Product Data File
  /u05/CCTEST02/apps/apps_st/appl/admin/zsaprod.txt
  does not exist for product "zsa".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.

    
 AD Administration warning:
  Product Data File
  /u05/CCTEST02/apps/apps_st/appl/admin/jtsprod.txt
  does not exist for product "jts".
 This product is registered in the database but the
 above file does not exist in APPL_TOP.  The product
 will be ignored without error.

    
 Reading database to see what industry is currently installed.

 Reading FND_LANGUAGES to see what is currently installed.
 Currently, the following languages are installed:

 Code   Language                                Status
 ----   --------------------------------------- ---------
 US     American English                        Base        
 ZHS    Simplified Chinese                      Install     

 Reading language information from applZHS.txt ...

 Your base language will be AMERICAN.

 Your other languages to install are: SIMPLIFIED CHINESE

 Setting up module information.
 Reading database for information about the modules.
 Saving module information.
 Reading database for information about the products.
 Reading database for information about how products depend on each other.
 Reading topfile.txt ...

 Saving product information.

 AD code level : [B.3]

      AD Administration Main Menu
    --------------------------------------------------

    1.    Generate Applications Files menu

    2.    Maintain Applications Files menu

    3.    Compile/Reload Applications Database Entities menu

    4.    Maintain Applications Database Entities menu

    5.    Change Maintenance Mode

    6.    Exit AD Administration

 

 

 

 

 Enter your choice [6] : 5

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Disabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] : 1

 sqlplus -s &un_apps/***** @/u05/CCTEST02/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

 Successfully enabled Maintenance Mode.

 Review the messages above, then press [Return] to continue.

    
 Backing up restart files, if any......Done.

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Enabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] : 1

 sqlplus -s &un_apps/***** @/u05/CCTEST02/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

 Successfully enabled Maintenance Mode.

 Review the messages above, then press [Return] to continue.

    
 Backing up restart files, if any......Done.

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Enabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] :

      AD Administration Main Menu
    --------------------------------------------------

    1.    Generate Applications Files menu

    2.    Maintain Applications Files menu

    3.    Compile/Reload Applications Database Entities menu

    4.    Maintain Applications Database Entities menu

    5.    Change Maintenance Mode

    6.    Exit AD Administration

 

 

 

 

 Enter your choice [6] : 4

   Maintain Applications Database Entities
    ---------------------------------------------------

    1.    Validate APPS schema

    2.    Re-create grants and synonyms for APPS schema

    3.    Maintain multi-lingual tables

    4.    Check DUAL table

    5.    Return to Main Menu

 

 

 

 

 

 Enter your choice [5] :

      AD Administration Main Menu
    --------------------------------------------------

    1.    Generate Applications Files menu

    2.    Maintain Applications Files menu

    3.    Compile/Reload Applications Database Entities menu

    4.    Maintain Applications Database Entities menu

    5.    Change Maintenance Mode

    6.    Exit AD Administration

 

    打开运维模式，后新开窗口级升程序，级升完成后，关闭运维模式。 在有driver的目录下，行运

    adpatch 命令

 

 

 Enter your choice [6] : 5

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Enabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] : 1

 sqlplus -s &un_apps/***** @/u05/CCTEST02/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE

 Successfully enabled Maintenance Mode.

 Review the messages above, then press [Return] to continue.

    
 Backing up restart files, if any......Done.

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Enabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] : 2

 sqlplus -s &un_apps/***** @/u05/CCTEST02/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

 Successfully disabled Maintenance Mode.

 Review the messages above, then press [Return] to continue.

    
 Backing up restart files, if any......Done.

       Change Maintenance Mode
    ----------------------------------------

 Maintenance Mode is currently: [Disabled].

    
 Maintenance mode should normally be enabled when patching
 Oracle Applications and disabled when users are logged on
 to the system.  See the Oracle Applications Maintenance
 Utilities manual for more information about maintenance mode.

    
 Please select an option:

    1.    Enable Maintenance Mode

    2.    Disable Maintenance Mode

    3.    Return to Main Menu

 

 Enter your choice [3] : 3

      AD Administration Main Menu
    --------------------------------------------------

    1.    Generate Applications Files menu

    2.    Maintain Applications Files menu

    3.    Compile/Reload Applications Database Entities menu

    4.    Maintain Applications Database Entities menu

    5.    Change Maintenance Mode

    6.    Exit AD Administration

 

 

 

 

 Enter your choice [6] :

 

 Backing up restart files, if any......Done.

    
 There is no timing information available for the current session.

    
 AD Administration is complete.

 Errors and warnings are listed in the log file
 /u05/CCTEST02/apps/apps_st/appl/admin/CCTEST02/log/adadmin.log

 and in other log files in the same directory.

 $ cd $ADMIN_SCRIPTS_HOME
 $ ls
 adalnctl.sh         adexecsql.pl        adoacorectl.sh      adstpall.sh         java.sh             mwactlwrpr.sh
 adapcctl.sh         adforms-c4wsctl.sh  adoafmctl.sh        adstrtal.sh         jtffmctl.sh         sqlnet.log
 adautocfg.sh        adformsctl.sh       adopmnctl.sh        gsmstart.sh         msc
 adcmctl.sh          adformsrvctl.sh     adpreclone.pl       ieo                 mwactl.sh
 $ adcmctl.sh start

 You are running adcmctl.sh version 120.17.12010000.5

    
 Enter the APPS username : apps

 Enter the APPS password :
 Starting concurrent manager for CCTEST02 ...
 Starting CCTEST02_1018@CCTEST02 Internal Concurrent Manager
 Default printer is noprint

 adcmctl.sh: exiting with status 0

    
 adcmctl.sh: check the logfile /u05/CCTEST02/inst/apps/CCTEST02_test01/logs/appl/admin/log/adcmctl.txt for more information ... 

    
重启并发管理器。

 

 

 

文章结束给大家分享下程序员的一些笑话语录： 面试官：熟悉哪种语言
应聘者：JAVA
面试官：知道什么叫类么
应聘者：我这人实在，工作努力，不知道什么叫累
面试官：知道什么是包?
应聘者：我这人实在 平常不带包 也不用公司准备了
面试官：知道什么是接口吗?
应聘者：我这个人工作认真。从来不找借口偷懒
面试官：知道什么是继承么
应聘者：我是孤儿没什么可以继承的
面试官:知道什么叫对象么？
应聘者:知道，不过我工作努力，上进心强，暂时还没有打算找对象。
面试官：知道多态么？
应聘者：知道，我很保守的。我认为让心爱的女人为了自已一时的快乐去堕胎是不道德的行为！请问这和C#有什么关系？？