hc1
spool /orahome/shell_scripts/shell/PROD/LOGS/runit8006.txt
set pages 1000
set linesize 135
col PROPERTY_NAME for a25
col PROPERTY_VALUE for a15
col DESCRIPTION for a35
col DIRECTORY_PATH for a70
col directory_name for a25
col OWNER for a10
col DB_LINK for a40
col HOST for a20
col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
col "Running_Processes" for 9999 heading 'Running'
set head off
set feedback off
set echo off
break on utl_file_dir
select '--------------------------------------------------------------------------------' from dual;
select '----------------------- Database Checks ---------------------------------' from dual;
select '--------------------------------------------------------------------------------' from dual;
Prompt
select '************************ Getting Database Information *************' from dual ;
select 'Database Name..................... : '||name from v$database;
select 'Database Status................... : '||open_mode from v$database;
select 'Archiving Status.................. : '||log_mode from v$database;
select 'Global Name....................... : '||global_name from global_name;
select 'Creation Date..................... : '||to_char(created,'DD-MON-YYYY HH24:MI:SS') from v$database;
select 'Checking For Missing File......... : '||count(*) from v$recover_file;
select 'Checking Missing File Name ....... : '||count(*) from v$datafile where name like '%MISS%';
select 'Total SGA ........................ : '||round(sum(value)/(1024*1024))||' MB' from v$sga ;
select 'Database Version.................. : '||version from v$instance;
select 'Temporary Tablespace.............. : '||property_value from database_properties
where property_name like 'default_temp_tablespace';
select 'Apps Temp Tablespace.............. : '||temporary_tablespace from dba_users where username like '%APPS%';
select 'Temp Tablespace size.............. : '||sum(maxbytes/1024/1024/1024)||' GB' from dba_temp_files group by tablespace_name;
select 'No of Invalid Object ............. : '||count(*) from dba_objects where status = 'INVALID' ;
select 'service Name...................... : '||value from v$parameter2 where name='service_names';
select 'plsql code type................... : '||value from v$parameter2 where name='plsql_code_type';
select 'plsql subdir count................ : '||value from v$parameter2 where name='plsql_native_library_subdir_count';
select 'plsql native library dir.......... : '||value from v$parameter2 where name='plsql_native_library_dir';
select 'Shared Pool Size.........,........ : '||(value/1024/1024) ||' MB' from v$parameter where name='shared_pool_size';
select 'Log Buffer........................ : '||(value/1024/1024) ||' MB' from v$parameter where name='log_buffer';
select 'Buffer Cache...................... : '||(value/1024/1024) ||' MB' from v$parameter where name='db_cache_size';
select 'Large Pool Size................... : '||(value/1024/1024) ||' MB' from v$parameter where name='large_pool_size';
select 'Java Pool Size.................... : '||(value/1024/1024) ||' MB' from v$parameter where name='java_pool_size';
select 'utl_file_dir...................... : '||value from v$parameter2 where name='utl_file_dir';
select directory_name||'.................... : '||directory_path from all_directories where rownum < 15 ;
select '************************ Getting Apps Information *****************' from dual ;
select 'Home URL.......................... : '||home_url from apps.icx_parameters ;
select 'Session Cookie.................... : '||session_cookie from apps.icx_parameters ;
select 'Applicaiton Database ID........... : '||fnd_profile.value('apps_database_id') from dual;
select 'GSM Enabled....................... : '||fnd_profile.value('conc_gsm_enabled') from dual;
select 'Maintainance Mode................. : '||fnd_profile.value('apps_maintenance_mode') from dual;
select 'Site Name......................... : '||fnd_profile.value('Sitename')from dual;
select 'Bug Number........................ : '||bug_number from ad_bugs where bug_number='2728236';
select '************************ Doing Workflow Checks ********************' from dual ;
select 'No Open Notifications............. : '||count(*) from wf_notifications where mail_status in('MAIL','INVALID','OPEN');
select 'Name(wf_systems).................. : '||name from wf_systems;
select 'Display Name(wf_systems).......... : '||display_name from wf_systems;
select 'Address........................... : '||address from wf_agents;
select 'Workflow Mailer Status............ : '||component_status from applsys.fnd_svc_components
where component_name like 'Workflow Notification Mailer';
select 'Test Address...................... : '||b.parameter_value
from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
where a.parameter_id=b.parameter_id
and a.parameter_name in ('TEST_ADDRESS');
select 'From Address...................... : '||b.parameter_value
from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
where a.parameter_id=b.parameter_id
and a.parameter_name in ('FROM');
select 'WF Admin Role..................... : '||text from wf_resources where name = 'WF_ADMIN_ROLE' and rownum =1;
Prompt
Prompt Getting Apps Node Info
Prompt ************************
select Node_Name,'........................ : '||server_id from fnd_nodes;
select server_type||'......................: '||name from fnd_app_servers, fnd_nodes
where fnd_app_servers.node_id =fnd_nodes.node_id;
select '************************ Doing Conc Mgr Checks ********************' from dual ;
Prompt Getting Con Mgr Status
Prompt ************************
Prompt
Prompt Manager Name Hostname No of Proc Running
Prompt ~~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~~~~~~~~~~~~
set lines 145
Column Target_Node Format A12
select User_Concurrent_Queue_Name,'....... : '||Target_Node||' ...... : '||Running_Processes
from fnd_concurrent_queues_vl
where Running_Processes = Max_Processes
and Running_Processes > 0;
Prompt
Prompt Getting Pending Request
Prompt ***********************
--select user_concurrent_program_name||'........ : '||request_id
-- from fnd_concurrent_requests r, fnd_concurrent_programs_vl p, fnd_lookups s, fnd_lookups ph
-- where r.concurrent_program_id = p.concurrent_program_id
-- and r.phase_code = ph.lookup_code
-- and ph.lookup_type = 'CP_PHASE_CODE'
-- and r.status_code = s.lookup_code
-- and s.lookup_type = 'CP_STATUS_CODE'
-- and ph.meaning ='Pending'
-- and rownum < 10
-- order by to_date(actual_start_date, 'dd-MON-yy hh24:mi');
--
Prompt
Prompt Getting Workflow Components Status
Prompt **********************************
set pagesize 1000
set linesize 125
col COMPONENT_STATUS for a20
col COMPONENT_NAME for a45
col STARTUP_MODE for a12
select fsc.COMPONENT_NAME,
fsc.STARTUP_MODE,
fsc.COMPONENT_STATUS,
fcq.MAX_PROCESSES TARGET,
fcq.RUNNING_PROCESSES ACTUAL
from APPS.FND_CONCURRENT_QUEUES_VL fcq, APPS.FND_CP_SERVICES fcs,
APPS.FND_CONCURRENT_PROCESSES fcp, fnd_svc_components fsc
where fcq.MANAGER_TYPE = fcs.SERVICE_ID
and fcs.SERVICE_HANDLE = 'FNDCPGSC'
and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
and fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
and fcq.application_id = fcp.queue_application_id(+)
and fcp.process_status_code(+) = 'A'
order by fcp.OS_PROCESS_ID, fsc.STARTUP_MODE;
select '--------------------------------------------------------------------------------' from dual;
select '----------------------- End Of Database Checks ----------------------------' from dual;
select '--------------------------------------------------------------------------------' from dual;
spool off;
runit.sh
#!/bin/ksh
set -x
#dba_list="a.gmail"
#dba_list="a.gmail.com"
. ~/.bash_profile
. /orahome/oracle/product/TJTG/db/tech_st/11.2.0/TJTG_tjpsb004.env
#MAIL_ID="a.gmail.in"
ORACLE_HOME=/orahome/oracle/product/TJTG/db/tech_st/11.2.0/;export ORACLE_HOME
PATH=$PATH:/usr/openwin/bin:/usr/local/bin:$ORACLE_HOME/bin:.;export PATH
ORACLE_SID=TJTG;export ORACLE_SID
ORAENV_ASK=NO; export ORAENV_ASK
#. oraenv
home_dir=`echo /orahome/shell_scripts/shell/PROD` ; export home_dir
#shell_dir=`echo $home_dir/shell/` ; export shell_dir
#sql_dir=`echo $home_dir/sql/` ; export sql_dir
out_dir=`echo $home_dir/LOGS/` ; export out_dir
v_date=`date +"%Y%m%d%H:%M"`
LOGFILE=/orahome/shell_scripts/shell/PROD/LOGS/runit8006.txt; export LOGFILE
. /orahome/oracle/product/TJTG/db/tech_st/11.2.0/TJTG_tjpsb004.env
apps_user=apps
apps_pwd=apps
db_connect="$apps_user/$apps_pwd@$1"
run_spr=`sqlplus -s apps/apps @/orahome/shell_scripts/shell/PROD/hc1.sql $1 << EOF
exit
EOF`
CAP=`echo $ORACLE_SID|tr '[a-z]' '[A-Z]'`
MAIL_ID="am@gmail.in"
if [ $? -ne 0 ]
then
echo "problems with sqlplus"
else
echo ' '
echo $out_dir
# if [ -s $out_dir\Daily_run_$1.txt ]
if [ -s $LOGFILE ]
then
echo "Sending E-mail for $CAP on `date` Production report ...."
mail -s " Production Status Report of $CAP on `date` " $MAIL_ID -- -f amina@ <$LOGFILE
else
mail -s " Production Status Report Not Generated $CAP on `date` " $MAIL_ID -- -f am@gmail.in <$LOGFILE
echo "no report exists"
fi
fi
LOG
====================================
--------------------------------------------------------------------------------
----------------------- Database Checks ---------------------------------
--------------------------------------------------------------------------------
************************ Getting Database Information *************
Database Name..................... : ASR
Database Status................... : READ WRITE
Archiving Status.................. : ARCHIVELOG
Global Name....................... : ASR.JSW.IN
Creation Date..................... : 14-OCT-2010 11:28:05
Checking For Missing File......... : 0
Checking Missing File Name ....... : 0
Total SGA ........................ : 20389 MB
Database Version.................. : 11.2.0.4.0
Apps Temp Tablespace.............. : TEMP1
Apps Temp Tablespace.............. : TEMP1
Temp Tablespace size.............. : 0 GB
No of Invalid Object ............. : 150
service Name...................... : ASR
service Name...................... : EBS_CHENNAI
plsql code type................... : INTERPRETED
Shared Pool Size.........,........ : 5120 MB
Log Buffer........................ : 50 MB
Buffer Cache...................... : 0 MB
Large Pool Size................... : 0 MB
Java Pool Size.................... : 0 MB
utl_file_dir...................... : /usr/tmp
utl_file_dir...................... : /usr/bin
utl_file_dir...................... : /tmp/OUTBOUND
utl_file_dir...................... : /orahome/oracle/product/ASR/db/tech_st/11.2.0/appsutil/outbound/ASR_ASRb004
utl_file_dir...................... : /usr/tmp
APLIST.................... : /usr/tmp
AFCHRCHK_LOG_DBOBJECT.................... : /usr/tmp
EXPDP_DIR1.................... : /home/oraprod/expdata
ORACLE_OCM_CONFIG_DIR2.................... : /orahome/oracle/product/ASR/db/tech_st/11.2.0/ccr/state
DATA_PUMP_DIR.................... : /home/oraprod/dbscript/datapump/
DUMPTEST.................... : /software/dumptest
DUMP.................... : /home/ostigp/dump
TRCA$INPUT2.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/bdump
TRCA$INPUT1.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
SQLT$BDUMP.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/bdump
SQLT$UDUMP.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
TRCA$STAGE.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
SQLT$STAGE.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
ODPDIR.................... : /usr/tmp
************************ Getting Apps Information *****************
Home URL.......................... : http://ASRb005.ebs.in:8000/OA_HTML/AppsLogin
Session Cookie.................... :
Applicaiton Database ID........... : ASR
GSM Enabled....................... : Y
Maintainance Mode................. : NORMAL
Site Name......................... : Toshiba-JSW Production
Bug Number........................ : 2728236
************************ Doing Workflow Checks ********************
No Open Notifications............. : 646
Name(wf_systems).................. : ASR.JSW.IN
Display Name(wf_systems).......... : PRD35.US.ORACLE.COM
Address........................... : APPLSYS.WF_ERROR@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_DEFERRED@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_SMTP_O_1_QUEUE@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_REPLAY_IN@ASR.JSW.IN
Address........................... : APPLSYS.WF_REPLAY_OUT@ASR.JSW.IN
Address........................... : APPLSYS.ECX_INBOUND@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.ECX_IN_OAG_Q@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.ECX_OUTBOUND@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.WF_CONTROL@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_NOTIFICATION_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_NOTIFICATION_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_JMS_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_SAMPLE@PRD34.US.ORACLE.COM
Address........................... : APPS.WF_BPEL_QAGENT@ASR.JSW.IN
Address........................... : PO.PO_OTM_OUT@ASR.JSW.IN
Address........................... : APPLSYS.WF_JAVA_DEFERRED@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JAVA_ERROR@PRD34.US.ORACLE.COM
Workflow Mailer Status............ : RUNNING
Test Address...................... : NONE
From Address...................... : Workflow Mailer - ASR Production
WF Admin Role..................... : *
Getting Apps Node Info
************************
AUTHENTICATION ........................ : OFF
ASRB004 ........................ :
ASRB005 ........................ : 710D7237757870FEE053200210AC452621343312172679521860129264838427
DB......................: ASRb004_ASR_DB
APPS......................: ASRb005_ASR_APPS
************************ Doing Conc Mgr Checks ********************
Getting Con Mgr Status
************************
Manager Name Hostname No of Proc Running
~~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~~~~~~~~~~~~
Conflict Resolution Manager ....... : ASRB005 ...... : 1
Internal Manager ....... : ASRB005 ...... : 1
Scheduler/Prereleaser Manager ....... : ASRB005 ...... : 1
Standard Manager ....... : ASRB005 ...... : 35
PO Document Approval Manager ....... : ASRB005 ...... : 1
Receiving Transaction Manager ....... : ASRB005 ...... : 1
PA Streamline Manager ....... : ASRB005 ...... : 1
Inventory Manager ....... : ASRB005 ...... : 1
INV Remote Procedure Manager ....... : ASRB005 ...... : 1
MRP Manager ....... : ASRB005 ...... : 1
Workflow Agent Listener Service ....... : ASRB005 ...... : 1
Workflow Mailer Service ....... : ASRB005 ...... : 1
Debug Service ....... : ASRB005 ...... : 1
Session History Cleanup ....... : ASRB005 ...... : 1
UWQ Worklist Items Release for Crashed session ....... : ASRB005 ...... : 1
OAM Metrics Collection Manager ....... : ASRB005 ...... : 1
Workflow Document Web Services Service ....... : ASRB005 ...... : 1
Output Post Processor ....... : ASRB005 ...... : 4
Service Manager: ASRB005 ....... : ASRB005 ...... : 1
Internal Monitor: ASRB005 ....... : ASRB005 ...... : 1
Getting Pending Request
***********************
Getting Workflow Components Status
**********************************
Workflow Notification Mailer AUTOMATIC RUNNING 1 1
Web Services OUT Agent MANUAL RUNNING 1 1
Workflow Java Error Agent Listener AUTOMATIC RUNNING 1 1
Workflow Java Deferred Agent Listener AUTOMATIC RUNNING 1 1
Workflow Deferred Notification Agent Listener AUTOMATIC RUNNING 1 1
Workflow Error Agent Listener AUTOMATIC RUNNING 1 1
Workflow Inbound Notifications Agent Listener AUTOMATIC RUNNING 1 1
Workflow Deferred Agent Listener AUTOMATIC RUNNING 1 1
WF_JMS_IN Listener(M4U) AUTOMATIC RUNNING 1 1
Web Services IN Agent MANUAL RUNNING 1 1
ECX Inbound Agent Listener MANUAL RUNNING 1 1
ECX Transaction Agent Listener MANUAL RUNNING 1 1
Workflow Inbound JMS Agent Listener MANUAL RUNNING 1 1
--------------------------------------------------------------------------------
----------------------- End Of Database Checks ----------------------------
--------------------------------------------------------------------------------
spool /orahome/shell_scripts/shell/PROD/LOGS/runit8006.txt
set pages 1000
set linesize 135
col PROPERTY_NAME for a25
col PROPERTY_VALUE for a15
col DESCRIPTION for a35
col DIRECTORY_PATH for a70
col directory_name for a25
col OWNER for a10
col DB_LINK for a40
col HOST for a20
col "User_Concurrent_Queue_Name" format a50 heading 'Manager'
col "Running_Processes" for 9999 heading 'Running'
set head off
set feedback off
set echo off
break on utl_file_dir
select '--------------------------------------------------------------------------------' from dual;
select '----------------------- Database Checks ---------------------------------' from dual;
select '--------------------------------------------------------------------------------' from dual;
Prompt
select '************************ Getting Database Information *************' from dual ;
select 'Database Name..................... : '||name from v$database;
select 'Database Status................... : '||open_mode from v$database;
select 'Archiving Status.................. : '||log_mode from v$database;
select 'Global Name....................... : '||global_name from global_name;
select 'Creation Date..................... : '||to_char(created,'DD-MON-YYYY HH24:MI:SS') from v$database;
select 'Checking For Missing File......... : '||count(*) from v$recover_file;
select 'Checking Missing File Name ....... : '||count(*) from v$datafile where name like '%MISS%';
select 'Total SGA ........................ : '||round(sum(value)/(1024*1024))||' MB' from v$sga ;
select 'Database Version.................. : '||version from v$instance;
select 'Temporary Tablespace.............. : '||property_value from database_properties
where property_name like 'default_temp_tablespace';
select 'Apps Temp Tablespace.............. : '||temporary_tablespace from dba_users where username like '%APPS%';
select 'Temp Tablespace size.............. : '||sum(maxbytes/1024/1024/1024)||' GB' from dba_temp_files group by tablespace_name;
select 'No of Invalid Object ............. : '||count(*) from dba_objects where status = 'INVALID' ;
select 'service Name...................... : '||value from v$parameter2 where name='service_names';
select 'plsql code type................... : '||value from v$parameter2 where name='plsql_code_type';
select 'plsql subdir count................ : '||value from v$parameter2 where name='plsql_native_library_subdir_count';
select 'plsql native library dir.......... : '||value from v$parameter2 where name='plsql_native_library_dir';
select 'Shared Pool Size.........,........ : '||(value/1024/1024) ||' MB' from v$parameter where name='shared_pool_size';
select 'Log Buffer........................ : '||(value/1024/1024) ||' MB' from v$parameter where name='log_buffer';
select 'Buffer Cache...................... : '||(value/1024/1024) ||' MB' from v$parameter where name='db_cache_size';
select 'Large Pool Size................... : '||(value/1024/1024) ||' MB' from v$parameter where name='large_pool_size';
select 'Java Pool Size.................... : '||(value/1024/1024) ||' MB' from v$parameter where name='java_pool_size';
select 'utl_file_dir...................... : '||value from v$parameter2 where name='utl_file_dir';
select directory_name||'.................... : '||directory_path from all_directories where rownum < 15 ;
select '************************ Getting Apps Information *****************' from dual ;
select 'Home URL.......................... : '||home_url from apps.icx_parameters ;
select 'Session Cookie.................... : '||session_cookie from apps.icx_parameters ;
select 'Applicaiton Database ID........... : '||fnd_profile.value('apps_database_id') from dual;
select 'GSM Enabled....................... : '||fnd_profile.value('conc_gsm_enabled') from dual;
select 'Maintainance Mode................. : '||fnd_profile.value('apps_maintenance_mode') from dual;
select 'Site Name......................... : '||fnd_profile.value('Sitename')from dual;
select 'Bug Number........................ : '||bug_number from ad_bugs where bug_number='2728236';
select '************************ Doing Workflow Checks ********************' from dual ;
select 'No Open Notifications............. : '||count(*) from wf_notifications where mail_status in('MAIL','INVALID','OPEN');
select 'Name(wf_systems).................. : '||name from wf_systems;
select 'Display Name(wf_systems).......... : '||display_name from wf_systems;
select 'Address........................... : '||address from wf_agents;
select 'Workflow Mailer Status............ : '||component_status from applsys.fnd_svc_components
where component_name like 'Workflow Notification Mailer';
select 'Test Address...................... : '||b.parameter_value
from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
where a.parameter_id=b.parameter_id
and a.parameter_name in ('TEST_ADDRESS');
select 'From Address...................... : '||b.parameter_value
from fnd_svc_comp_param_vals_v a, fnd_svc_comp_param_vals b
where a.parameter_id=b.parameter_id
and a.parameter_name in ('FROM');
select 'WF Admin Role..................... : '||text from wf_resources where name = 'WF_ADMIN_ROLE' and rownum =1;
Prompt
Prompt Getting Apps Node Info
Prompt ************************
select Node_Name,'........................ : '||server_id from fnd_nodes;
select server_type||'......................: '||name from fnd_app_servers, fnd_nodes
where fnd_app_servers.node_id =fnd_nodes.node_id;
select '************************ Doing Conc Mgr Checks ********************' from dual ;
Prompt Getting Con Mgr Status
Prompt ************************
Prompt
Prompt Manager Name Hostname No of Proc Running
Prompt ~~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~~~~~~~~~~~~
set lines 145
Column Target_Node Format A12
select User_Concurrent_Queue_Name,'....... : '||Target_Node||' ...... : '||Running_Processes
from fnd_concurrent_queues_vl
where Running_Processes = Max_Processes
and Running_Processes > 0;
Prompt
Prompt Getting Pending Request
Prompt ***********************
--select user_concurrent_program_name||'........ : '||request_id
-- from fnd_concurrent_requests r, fnd_concurrent_programs_vl p, fnd_lookups s, fnd_lookups ph
-- where r.concurrent_program_id = p.concurrent_program_id
-- and r.phase_code = ph.lookup_code
-- and ph.lookup_type = 'CP_PHASE_CODE'
-- and r.status_code = s.lookup_code
-- and s.lookup_type = 'CP_STATUS_CODE'
-- and ph.meaning ='Pending'
-- and rownum < 10
-- order by to_date(actual_start_date, 'dd-MON-yy hh24:mi');
--
Prompt
Prompt Getting Workflow Components Status
Prompt **********************************
set pagesize 1000
set linesize 125
col COMPONENT_STATUS for a20
col COMPONENT_NAME for a45
col STARTUP_MODE for a12
select fsc.COMPONENT_NAME,
fsc.STARTUP_MODE,
fsc.COMPONENT_STATUS,
fcq.MAX_PROCESSES TARGET,
fcq.RUNNING_PROCESSES ACTUAL
from APPS.FND_CONCURRENT_QUEUES_VL fcq, APPS.FND_CP_SERVICES fcs,
APPS.FND_CONCURRENT_PROCESSES fcp, fnd_svc_components fsc
where fcq.MANAGER_TYPE = fcs.SERVICE_ID
and fcs.SERVICE_HANDLE = 'FNDCPGSC'
and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
and fcq.concurrent_queue_id = fcp.concurrent_queue_id(+)
and fcq.application_id = fcp.queue_application_id(+)
and fcp.process_status_code(+) = 'A'
order by fcp.OS_PROCESS_ID, fsc.STARTUP_MODE;
select '--------------------------------------------------------------------------------' from dual;
select '----------------------- End Of Database Checks ----------------------------' from dual;
select '--------------------------------------------------------------------------------' from dual;
spool off;
runit.sh
#!/bin/ksh
set -x
#dba_list="a.gmail"
#dba_list="a.gmail.com"
. ~/.bash_profile
. /orahome/oracle/product/TJTG/db/tech_st/11.2.0/TJTG_tjpsb004.env
#MAIL_ID="a.gmail.in"
ORACLE_HOME=/orahome/oracle/product/TJTG/db/tech_st/11.2.0/;export ORACLE_HOME
PATH=$PATH:/usr/openwin/bin:/usr/local/bin:$ORACLE_HOME/bin:.;export PATH
ORACLE_SID=TJTG;export ORACLE_SID
ORAENV_ASK=NO; export ORAENV_ASK
#. oraenv
home_dir=`echo /orahome/shell_scripts/shell/PROD` ; export home_dir
#shell_dir=`echo $home_dir/shell/` ; export shell_dir
#sql_dir=`echo $home_dir/sql/` ; export sql_dir
out_dir=`echo $home_dir/LOGS/` ; export out_dir
v_date=`date +"%Y%m%d%H:%M"`
LOGFILE=/orahome/shell_scripts/shell/PROD/LOGS/runit8006.txt; export LOGFILE
. /orahome/oracle/product/TJTG/db/tech_st/11.2.0/TJTG_tjpsb004.env
apps_user=apps
apps_pwd=apps
db_connect="$apps_user/$apps_pwd@$1"
run_spr=`sqlplus -s apps/apps @/orahome/shell_scripts/shell/PROD/hc1.sql $1 << EOF
exit
EOF`
CAP=`echo $ORACLE_SID|tr '[a-z]' '[A-Z]'`
MAIL_ID="am@gmail.in"
if [ $? -ne 0 ]
then
echo "problems with sqlplus"
else
echo ' '
echo $out_dir
# if [ -s $out_dir\Daily_run_$1.txt ]
if [ -s $LOGFILE ]
then
echo "Sending E-mail for $CAP on `date` Production report ...."
mail -s " Production Status Report of $CAP on `date` " $MAIL_ID -- -f amina@ <$LOGFILE
else
mail -s " Production Status Report Not Generated $CAP on `date` " $MAIL_ID -- -f am@gmail.in <$LOGFILE
echo "no report exists"
fi
fi
LOG
====================================
--------------------------------------------------------------------------------
----------------------- Database Checks ---------------------------------
--------------------------------------------------------------------------------
************************ Getting Database Information *************
Database Name..................... : ASR
Database Status................... : READ WRITE
Archiving Status.................. : ARCHIVELOG
Global Name....................... : ASR.JSW.IN
Creation Date..................... : 14-OCT-2010 11:28:05
Checking For Missing File......... : 0
Checking Missing File Name ....... : 0
Total SGA ........................ : 20389 MB
Database Version.................. : 11.2.0.4.0
Apps Temp Tablespace.............. : TEMP1
Apps Temp Tablespace.............. : TEMP1
Temp Tablespace size.............. : 0 GB
No of Invalid Object ............. : 150
service Name...................... : ASR
service Name...................... : EBS_CHENNAI
plsql code type................... : INTERPRETED
Shared Pool Size.........,........ : 5120 MB
Log Buffer........................ : 50 MB
Buffer Cache...................... : 0 MB
Large Pool Size................... : 0 MB
Java Pool Size.................... : 0 MB
utl_file_dir...................... : /usr/tmp
utl_file_dir...................... : /usr/bin
utl_file_dir...................... : /tmp/OUTBOUND
utl_file_dir...................... : /orahome/oracle/product/ASR/db/tech_st/11.2.0/appsutil/outbound/ASR_ASRb004
utl_file_dir...................... : /usr/tmp
APLIST.................... : /usr/tmp
AFCHRCHK_LOG_DBOBJECT.................... : /usr/tmp
EXPDP_DIR1.................... : /home/oraprod/expdata
ORACLE_OCM_CONFIG_DIR2.................... : /orahome/oracle/product/ASR/db/tech_st/11.2.0/ccr/state
DATA_PUMP_DIR.................... : /home/oraprod/dbscript/datapump/
DUMPTEST.................... : /software/dumptest
DUMP.................... : /home/ostigp/dump
TRCA$INPUT2.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/bdump
TRCA$INPUT1.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
SQLT$BDUMP.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/bdump
SQLT$UDUMP.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
TRCA$STAGE.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
SQLT$STAGE.................... : /orahome/oracle/product/ASR/db/tech_st/10.2.0/admin/ASR_ASRb001/udump
ODPDIR.................... : /usr/tmp
************************ Getting Apps Information *****************
Home URL.......................... : http://ASRb005.ebs.in:8000/OA_HTML/AppsLogin
Session Cookie.................... :
Applicaiton Database ID........... : ASR
GSM Enabled....................... : Y
Maintainance Mode................. : NORMAL
Site Name......................... : Toshiba-JSW Production
Bug Number........................ : 2728236
************************ Doing Workflow Checks ********************
No Open Notifications............. : 646
Name(wf_systems).................. : ASR.JSW.IN
Display Name(wf_systems).......... : PRD35.US.ORACLE.COM
Address........................... : APPLSYS.WF_ERROR@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_DEFERRED@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_SMTP_O_1_QUEUE@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_REPLAY_IN@ASR.JSW.IN
Address........................... : APPLSYS.WF_REPLAY_OUT@ASR.JSW.IN
Address........................... : APPLSYS.ECX_INBOUND@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.ECX_IN_OAG_Q@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.ECX_OUTBOUND@PRB19.US.ORACLE.COM
Address........................... : APPLSYS.WF_CONTROL@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_NOTIFICATION_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_NOTIFICATION_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_JMS_IN@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JMS_JMS_OUT@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_WS_SAMPLE@PRD34.US.ORACLE.COM
Address........................... : APPS.WF_BPEL_QAGENT@ASR.JSW.IN
Address........................... : PO.PO_OTM_OUT@ASR.JSW.IN
Address........................... : APPLSYS.WF_JAVA_DEFERRED@PRD34.US.ORACLE.COM
Address........................... : APPLSYS.WF_JAVA_ERROR@PRD34.US.ORACLE.COM
Workflow Mailer Status............ : RUNNING
Test Address...................... : NONE
From Address...................... : Workflow Mailer - ASR Production
WF Admin Role..................... : *
Getting Apps Node Info
************************
AUTHENTICATION ........................ : OFF
ASRB004 ........................ :
ASRB005 ........................ : 710D7237757870FEE053200210AC452621343312172679521860129264838427
DB......................: ASRb004_ASR_DB
APPS......................: ASRb005_ASR_APPS
************************ Doing Conc Mgr Checks ********************
Getting Con Mgr Status
************************
Manager Name Hostname No of Proc Running
~~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~~~~~~~~~~~~
Conflict Resolution Manager ....... : ASRB005 ...... : 1
Internal Manager ....... : ASRB005 ...... : 1
Scheduler/Prereleaser Manager ....... : ASRB005 ...... : 1
Standard Manager ....... : ASRB005 ...... : 35
PO Document Approval Manager ....... : ASRB005 ...... : 1
Receiving Transaction Manager ....... : ASRB005 ...... : 1
PA Streamline Manager ....... : ASRB005 ...... : 1
Inventory Manager ....... : ASRB005 ...... : 1
INV Remote Procedure Manager ....... : ASRB005 ...... : 1
MRP Manager ....... : ASRB005 ...... : 1
Workflow Agent Listener Service ....... : ASRB005 ...... : 1
Workflow Mailer Service ....... : ASRB005 ...... : 1
Debug Service ....... : ASRB005 ...... : 1
Session History Cleanup ....... : ASRB005 ...... : 1
UWQ Worklist Items Release for Crashed session ....... : ASRB005 ...... : 1
OAM Metrics Collection Manager ....... : ASRB005 ...... : 1
Workflow Document Web Services Service ....... : ASRB005 ...... : 1
Output Post Processor ....... : ASRB005 ...... : 4
Service Manager: ASRB005 ....... : ASRB005 ...... : 1
Internal Monitor: ASRB005 ....... : ASRB005 ...... : 1
Getting Pending Request
***********************
Getting Workflow Components Status
**********************************
Workflow Notification Mailer AUTOMATIC RUNNING 1 1
Web Services OUT Agent MANUAL RUNNING 1 1
Workflow Java Error Agent Listener AUTOMATIC RUNNING 1 1
Workflow Java Deferred Agent Listener AUTOMATIC RUNNING 1 1
Workflow Deferred Notification Agent Listener AUTOMATIC RUNNING 1 1
Workflow Error Agent Listener AUTOMATIC RUNNING 1 1
Workflow Inbound Notifications Agent Listener AUTOMATIC RUNNING 1 1
Workflow Deferred Agent Listener AUTOMATIC RUNNING 1 1
WF_JMS_IN Listener(M4U) AUTOMATIC RUNNING 1 1
Web Services IN Agent MANUAL RUNNING 1 1
ECX Inbound Agent Listener MANUAL RUNNING 1 1
ECX Transaction Agent Listener MANUAL RUNNING 1 1
Workflow Inbound JMS Agent Listener MANUAL RUNNING 1 1
--------------------------------------------------------------------------------
----------------------- End Of Database Checks ----------------------------
--------------------------------------------------------------------------------
No comments:
Post a Comment