Trace expdp/impdp backups(Datapump jobs)

Use TRACE=1FF0300 to trace the expdp/impdp backup

expdp system/manager DIRECTORY=new_dir DUMPFILE=expdp_parallel_%U.dmp LOGFILE=expdp_full.log FULL=y PARALLEL=15 TRACE=1FF0300

Dump would be like :
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00210: expected '<' instead of 'ÿ'
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8936
----- PL/SQL Call Stack -----
object line object
handle number name
0xfb472c90 20462 package body SYS.KUPW$WORKER
0xfb472c90 9028 package body SYS.KUPW$WORKER
0xfb472c90 4519 package body SYS.KUPW$WORKER
0xfb472c90 9739 package body SYS.KUPW$WORKER
0xfb472c90 1775 package body SYS.KUPW$WORKER
0xfa49efb8 2 anonymous block


1FF0300 is used for full trace(worker processes & master control processes).
400300 is to trace Worker process(es) and trace 80300 is to trace Master Control Process (MCP).


If it is Master Process trace file then generated file name is,
SID_dmNUMBER_process_id.trc

- If it is Worker Process trace file then generated file name is,
SID_dwNUMBER_process_id.trc

Workflow mailer is not getting up (Oracle R12)

Issue:
Workflow mailer got down.Tried to start it but not getting Up


Error:
at oracle.apps.fnd.wf.mailer.MailerUtils.isSocketConnectableNew(MailerUtils.java:300)
at oracle.apps.fnd.wf.mailer.SMTPUtils.isValidOutbound(SMTPUtils.java:522)
at oracle.apps.fnd.wf.mailer.Mailer.validateParameterValues(Mailer.java:1238)
at oracle.apps.fnd.cp.gsc.SvcComponent.performValidateParameterValues(SvcComponent.java:233)
at oracle.apps.fnd.cp.gsc.SvcComponent.start(SvcComponent.java:314)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2212)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:301)
at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57)


Finding:
Autoconfig has changed the Outbound Server Name


Solution:
Set Outbound Server name to test-mac.ABC.com

Note:Inbound Server name is same as Outbound Server Name in our case.

Startup Shutdown Scripts in Oracle R12

Description of EBS Application services start stop scripts

a) adstrtall.sh
This script actually is a master script to start all components/services of middle tier or application tier. This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml / CONTEXT_NAME.xml).

b)adstrtal.sh
This script is a master script to start all application tier services adstpal.sh is the master script to stop all the services at the application

c) adalnctl.sh
Script to start / stop apps listener (FNDFS and FNDFS). This listener file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home) listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory

d) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server)

e) adcmctl.sh
Script to start / stop concurrent manager. (This script in turn calls startmgr.sh )

f) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also useopmnctl to start/stop Forms

g) adformsrvctl.sh
This script is used to start forms in socket mode. Default forms connect method in R12 is servlet.

h) adoacorectl.sh
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl)

i) adoafmctl.sh
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl to start oacore instance of OC4J

h) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.

k) mwactl.sh
To start / stop mwa telnet server where mwa is mobile application.

Starting up AS10g services in an EBusiness Suite Release 12 environment(Doc ID 743518.1)