R12.2 Apps DBA. Powered by Blogger.

R12.2 fs_clone fails with ERROR: Number of servers are not in sync between Run and Patch Context

No comments :
Run the following script to determine if all context files have been registered in the database.
The script should return a run and patch context file for each application server and one for the database server.
select path,status,serial_number,version from fnd_oam_context_files where name not in ('TEMPLATE','METADATA') and (status is null or status !='VALID');
Run the following script to determine the number/types of managed servers registered in the run and patch file systems.
The script should return an equal number of managed servers between the run and patch file systems

SELECT  extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='run'
and CTX_TYPE = 'A';

SELECT  extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='patch'
and CTX_TYPE = 'A';
Also Compare the run context file and patch context files on the file system to ensure the
following variables contain the same number of managed server entries:
s_adminservername
s_oacore_server_ports
s_forms_server_ports
s_oafm_server_ports
s_forms-c4ws_server_ports
s_oaea_server_ports

If the run file system data is missing from the database simply source the run file system environment and run autoconfig.
If the patch file system data (managed servers or context file) is missing from the database then run the following after sourcing the run file system environment.
This command is executed on the RUN file system to upload the PATCH context file:
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=<full path to patch context file> \
logfile=/tmp/patchctxupload.log
Review the log file to confirm the process ran without error.
Confirm that the fnd_oam_context_files table now holds the correct data.
You may experience this issue if you have added/removed managed servers and have only performed the steps on one file system, as opposed to both.
In this case please see Page 3-40  of the Oracle E-Business Suite Setup Guide for the correct procedure.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.