1) Login to application server.
[oracle@Ranesh logs]$ grep -i "wls_admin" $CONTEXT_FILE
<s_wls_admin_console_access_nodes oa_var="s_wls_admin_console_access_nodes">0.0.0.0/0</s_wls_admin_console_access_nodes>
<wls_admin_host oa_var="s_wls_admin_host">Ranesh</wls_admin_host>
<wls_admin_sslEnabled oa_var="s_wls_admin_sslEnabled">false</wls_admin_sslEnabled>
<wls_admin_domain oa_var="s_wls_admin_domain">ranesh.oraclevcn.com</wls_admin_domain>
<wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>
<wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7001</wls_adminport>
<wls_admin_sslport oa_var="s_wls_admin_sslport" oa_type="PORT" base="17001" step="1" range="-1" label="WLS Admin Server SSL Port">17001</wls_admin_sslport>
We can also find out the url using command
[oracle@Ranesh logs]$ echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console"
http://Ranesh.ranesh.oraclevcn.com:7001/console
cURL is a command-line tool and application library used to transfer data to or from a server.
curl -T /u01/app/oracle/ranesh.zip -o output.log -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/SR NUMBER/"
curl -T AdminServer.log -o xplorer -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/3-26712853041/"
SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;
Steps to start/stop
Workflow Notification Mailer
·
Check workflow mailer service current status
SQL> select running_processes
from fnd_concurrent_queues
where concurrent_queue_name = 'WFMLRSVC';
RUNNING_PROCESSES
-----------------
1
Number of running processes should be
greater than 0
·
Find current mailer status
SQL> select component_status
from fnd_svc_components
where component_id =
(select component_id
from fnd_svc_components
where component_name = 'Workflow Notification
Mailer');
COMPONENT_STATUS
------------------------------
DEACTIVATED_USER
Possible values are :
RUNNING STARTING,
STOPPED_ERROR,
DEACTIVATED_USER
DEACTIVATED_SYSTEM.
·
Stop Workflow mailer
declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
select component_id
into m_mailerid
from fnd_svc_components
where component_name = 'Workflow Notification Mailer';
fnd_svc_component.stop_component(m_mailerid, p_retcode,
p_errbuf);
commit;
end;
/
·
Start the Notification Mailer
declarep_retcode number;p_errbuf varchar2(100);m_mailerid fnd_svc_components.component_id%TYPE;beginselect component_idinto m_maileridfrom fnd_svc_componentswhere component_name = 'Workflow Notification Mailer';fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);commit;end;/
TKPROF Overview.
TKPROF is used for diagnosing
performance issues. It formats a trace file into readable format for
performance analysis.
Syntax
tkprof tracefile_name.trc tracefileoutput.txt
sys=no sort='(prsela,exeela,fchela)' explain=apps/apps
passwd.
sys – Enables or disables the inclusion of SQL statements
executed by the SYS user, including recursive SQL statements.
Default=enable.
explain – Executes an Explain Plan for each statement in the trace
file and displays the output. Explain Plan provides the predicted optimizer
execution path without actually executing the statement. tkprof shows you
the actual execution path and statistics after the statement is executed.
sort – Sorts the SQL statements in the
trace file by the criteria required.It provides SQL statements that consume the
most resources at the top of the file, rather than searching the entire file
contents for the poor performers.
prsela – The elapsed time spent
parsing the SQL.
exeela – The elapsed time spent
executing the SQL.
fchela – The
elapsed time spent fetching rows.
