重启并发管理器
下面都是应用用户
一、停止并发管理器
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 ...
重启并发管理器。