Find OPP Log File Using Concurrent Request ID

Select logfile_name from fnd_concurrent_requests where request_id = 11111111;


Select 
fcpp.concurrent_request_id req_id, 
fcp.node_name, 
fcp.logfile_name 
FROM 
fnd_conc_pp_actions fcpp, 
fnd_concurrent_processes fcp 
where 
fcpp.processor_id = fcp.concurrent_process_id 
AND 
fcpp.action_type = 6 
AND 
fcpp.concurrent_request_id = 1111111;

How to Create a External Table in Oracle

CREATE TABLE "APPS"."TEST_FILESYSTEM"
   ( "FILESYSTEM" VARCHAR2(40 BYTE),
"TOTAL_GB" VARCHAR2(10 BYTE),
"USED_GB" VARCHAR2(10 BYTE),
"AVAILABLE_GB" VARCHAR2(10 BYTE),
"USED_PERCENTAGE" VARCHAR2(10 BYTE),
"MOUNTED_ON" VARCHAR2(25 BYTE)
   )
   ORGANIZATION EXTERNAL
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "DUMP"
      ACCESS PARAMETERS
      ( records delimited by newline
fields terminated by ' '
    )
      LOCATION
       ( 'Test_filesystem.txt'
       )
    )
   REJECT LIMIT UNLIMITED ;

Note:

* Dump - Directory should be available in dba_directory table.
* Location - txt file should be available in specific location or Path
* use All_external_tables view to check the external table information.

Gather Statistics on Oracle 11g

Schema Statistics:

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('USERNAME',DBMS_STATS.AUTO_SAMPLE_SIZE);

Table Statistics:

EXEC DBMS_STATS.gather_table_stats('SCOTT', 'EMP'); 

Index Statistics:


EXEC DBMS_STATS.gather_index_stats('SCOTT', 'EMPLOYEES_PK');

Prepare Phase Failed due to Free Space

Error:

$NE_BASE/log/adop/17/prepare_timestamp/TEST_hostname/TXK_SANITY_filesystemcheck/df.out
Execute SYSTEM command : df /ebs1/app/oracle/TEST/fs2
"df" command output:                      ******** *********** ******** 97% /ebs1


MINIMIUM SPACE REQUIRED (in GB): 25
FREE SPACE AVAILABLE    (in GB): 15.1493682861328
Space check FAILED.

[ERROR] Minimum file system space required 25 GB while you have 15.1493682861328 GB

Solution:

Remove old files in filesystem. Minimum 25GB should be available in server for running prepare phase

Prepare Phase Failed ERROR - CLONE-20368 Domain pack failed

Error:

SEVERE : May 15, 2016 12:07:48 - ERROR - CLONE-20368  Domain pack failed.
SEVERE : May 15, 2016 12:07:48 - CAUSE - CLONE-20368  Make sure that values specified are correct.
SEVERE : May 15, 2016 12:07:48 - ACTION - CLONE-20368  Check the T2P logs for more details.
java.lang.Exception: Domain pack failed.

CLONE2016*****.log

<< read domain from "$FMW_Home/user_projects/domains/$DOMAIN_NAME"
>>  succeed: read domain from "$FMW_Home/user_projects/domains//$DOMAIN_NAME"
<< write template to "$INST_TOP/logs/appl/rgf/TXK/CLONINGCLIENT*********************/packed_domain.jar"
CFGFWK-60550:  Script execution aborted. The script may contain an error.
Java heap space
FINE : May 15, 2016 12:07:48 - [CloneLogger:unSetSystemOutErrToCloneLogger] Invoking unsetSystemOutErrToCloneLogger 1
FINE : May 15, 2016 12:07:48 - [CloneLogger:unSetSystemOutErrToCloneLogger] Invoking unsetSystemOutErrToCloneLogger 2
INFO : May 15, 2016 12:07:48 - CLONE-21096   Process complete in 3275466 milli sec.
INFO : May 15, 2016 12:07:48 - CLONE-21031   Time taken to add all the cloners to archive was "3,275" seconds.
INFO : May 15, 2016 12:07:48 - CLONE-21006   Total time taken by T2P process was 3,275 seconds.


Solution:

Let's make a small change in your WLS_HOME/common/bin/pack.sh to raise the used heap to 1Gb.

1) Copy WLS_HOME/common/bin/pack.sh to WLS_HOME/common/bin/packBACKUP.sh

2) Edit WLS_HOME/common/bin/pack.sh

Go to the empty line 95 and insert MEM_ARGS="-Xms1024m -Xmx1024m"

Change this section from:  

cd "${WL_HOME}/common/lib"
JVM_ARGS="-Dprod.props.file='${WL_HOME}/.product.properties' ${MEM_ARGS} ${CONFIG_JVM_ARGS}"

To this:

cd "${WL_HOME}/common/lib"
MEM_ARGS="-Xms1024m -Xmx1024m"
JVM_ARGS="-Dprod.props.file='${WL_HOME}/.product.properties' ${MEM_ARGS} ${CONFIG_JVM_ARGS}"

3) Save WLS_HOME/common/bin/pack.sh and exit

4) Retry the prepare phase

R12.2 Post Clone Issue No space left on device

Error: writeTemplate() failed. Do dumpStack() to see details.
Problem invoking WLST - Traceback (innermost last):
  File "/tmp/CLONINGCLIENT************/tmp**********.py", line 239, in ?
  File "/tmp/WLSTOfflineIni************.py", line 74, in writeTemplate
        at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:51)
        at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:1538)
        at com.oracle.cie.domain.script.jython.WLScriptContext.writeTemplate(WLScriptContext.java:831)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)

com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: java.io.IOException: No space left on device

Solution:
Delete old files and create a free space in filesystem

Apachectl startssl: execing httpd Syntax error

$INST_TOP/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 17 of $INST_TOP/ora/10.1.3/Apache/Apache/conf/mod_osso.conf:
Unable to open $INST_TOP/ora/10.1.3/Apache/Apache/conf/osso/TEST_hostname_osso.conf.

Solution:

1. Backup the $CONTEXT_FILE
2. Edit the parameter  "s_mod_osso_conf_comment" in the $CONTEXT_FILE using editContext utility,  or manually using a text editor
3. Set the value for the above parameter to "#"
4. Save the changes and run Autoconfig
5. Start the Apache service to re-test the issue

i.e.
<mod_osso_conf_comment oa_var="s_mod_osso_conf_comment">#</mod_osso_conf_comment>