adcfgclone.pl appsTier dualfs

DUALFS – new feature is introduced in the latest AD-TXK Delta 7. 

This feature will create both the filesystems fs1 and fs2 during the clonning process.

[appldev@ebbs-app01]$ perl adcfgclone.pl appsTier dualfs

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :
Running: Context clone…

Log file located at /EBS/oracle/fs1/EBSapps/comn/clone/bin/CloneContext_2123174759.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [ebs-app01] :

Target System Database SID : oracle

Target System Database Server Node [ebs-app01] : ebs-db01

Target System Database Domain Name [oracle.com] :

Target System Base Directory : /EBS/oracle

Target System Base Directory set to /EBS/oracle

Target System Current File System Base set to /EBS/oracle/fs1

Target System Other File System Base set to /EBS/oracle/fs2

Target System Fusion Middleware Home set to /EBS/oracle/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /EBS/oracle/fs2/FMW_Home

Target System Web Oracle Home set to /EBS/oracle/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /EBS/oracle/fs2/FMW_Home/webtier

Target System Appl TOP set to /EBS/oracle/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /EBS/oracle/fs2/EBSapps/appl

Target System COMMON TOP set to /EBS/oracle/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /EBS/oracle/fs2/EBSapps/comn

Target System Instance Home Directory [/EBS/oracle] : /EBS/oracle

Target System Current File System Instance Top set to /EBS/oracle/fs1/inst/apps/oracle_ebs-app01

Do you want to preserve the Display [ebs-papp01:0.0] (y/n) : n

Target System Display [ebs-app01:0.0] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 0

Checking the port pool 90
done: Port Pool 90 is free
Report file located at /EBS/oracle/fs1/inst/apps/oracle_ebs-app01/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /EBS/oracle/product/12.1.0/appsutil/outbound/oracle_ebs-app01
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 3
The new APPL_TOP context file has been created :
/EBS/oracle/fs1/inst/apps/oracle_ebs-app01/appl/admin/oracle_ebs-app01.xml
Check Clone Context logfile /EBS/oracle/fs1/EBSapps/comn/clone/bin/CloneContext_2123184759.log for details.

Creating Patch file system context file…..

Log file located at /EBS/oracle/fs1/EBSapps/comn/clone/bin/CloneContextPatch_2123184843.log

Target System Other File System Instance Top set to /EBS/oracle/fs2/inst/apps/oracle_ebs-app01

Target System Port Pool [0-99] : 2

Thank You !!

RC-50013 Fatal: Instantiate driver

Error:

Seen the issue during the execution of adcfgclone.

perl adcfgclone.pl dbTechStack

====================

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /EBS/oracle/product/12c/perl/bin/perl -I /EBS/oracle/product/12c/perl/lib/5.14.1 -I /EBS/oracle/product/12c/perl/lib/site_perl/5.14.1 -I /EBS/oracle/product/12c/appsutil/perl /EBS/oracle/product/12c/appsutil/clone
ouicli.pl INSTE8_APPLY 1

AutoConfig is exiting with status 1

WARNING: RC-50013: Fatal: Instantiate driver did not complete successfully.
/EBS/oracle/product/12c/appsutil/driver/regclone.drv

====================

CAUSE:

The script was trying to register the oracle home in inventory but its failing to update it.

SOLUTION:

Please delete existing files under oraInventory folder and retry the adcfgclone.

[oracle@ebsdb01 bin]$ cat /etc/oraInst.loc
inst_group=dba
inventory_loc=/EBS/oracle/product/oraInventory
cd /EBS/oracle/product
rm -rf oraInventory
mkdir oraInventory

Retry :   perl adcfgclone.pl dbTechStack

Thank you !!

 

SET PASSWORD LIFE TIME TO UNLIMITED

Set the password life time to unlimited for DEFAULT profile.
SQL> SELECT resource_name,limit FROM dba_profiles WHERE profile=’DEFAULT’;

RESOURCE_NAME LIMIT
——————————– —————————–
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180

RESOURCE_NAME LIMIT
——————————– —————————–
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Thank You !!

 

Find Plan Hash Values from SQLID

 

SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat q,
    (
    SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap
    FROM dba_hist_snapshot ss
    WHERE ss.begin_interval_time BETWEEN (SYSDATE - &No_Days) AND SYSDATE
    ) s
WHERE q.snap_id BETWEEN s.min_snap AND s.max_snap
  AND q.sql_id IN ( '&SQLID')
/

 

Thank You !!

ADOP FS_CLONE Fails with OutOfMemoryError: Java Heap Space Error

ERROR:

Exception in thread “Thread-1” java.lang.OutOfMemoryError: GC overhead limit exceeded

SOLUTION:

[oratst@xxxxxx ]$ export CONFIG_JVM_ARGS=”-Xms1024m -Xmx2048m”

[oratst@xxxxxx ]$ echo $CONFIG_JVM_ARGS
-Xms1024m -Xmx2048m

re-executes  completed successfully

adop phase=fs_clone force=Yes

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress.

ERROR:

INST_TOP/admin/log/clone/run/ohsT2PApply/CLONE2016-02-02_13-10-02_599255196.error:
2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [] [internal]...
2015-12-02T13:10:04-06:00] [opmn] [ERROR:1] [] [internal] lxlinit - NLS boot file not found or invalid
opmnctl ping: error parsing /u01/tech_st/fs1/FMW_Home/webtier/instances/EBS_web_EBDEV_OHS1/config/OPMN/opmn/opmn.xml
[2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [105] [internal] XML parser init: character set initialization failed.
SEVERE : Dec 2, 2016 03:10:04 - ERROR - CLONE-20218   Cloning is not successful.
SEVERE : Dec 2, 2016 03:10:04 - CAUSE - CLONE-20218   An internal operation failed.
SEVERE : Dec 2, 2016 03:10:04 - ACTION - CLONE-20218   Provide the clone log and error file for investigation.

Solution:

Issue is because of existing environment variables. Before executing the adcfgclone verify any of the the environment is set. If already set please try to unset and run adcfgclone.

Else, Unset the following environment:
ORA_NLS10
TNS_ADMIN
ORACLE_HOME

 

Thank You !!

 

 

DATABASE SCHEMA SIZE from the database

set linesize 150
set pagesize 5000
col owner for a155

select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner;

Thank you !!

 

 

 

ORA-39181: Only partial table data may be exported due to fine grain access control

The below error appeared when trying to export the Schema:

ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKFLOW_ACTION_PARAM”
. . exported “GLOGOWNER”.”WORKFLOW_ACTION_PARAM” 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKING_LIST”
. . exported “GLOGOWNER”.”WORKING_LIST” 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKING_LIST_DETAIL”

SOLUTION:

Provide the below privilege to the schema which you are trying to export.

grant EXEMPT ACCESS POLICY to <SCHEMA NAME>;

 

Thank you !!

EBS 12.2 Upgrade and Installation Logs

Before the installation starts:

$TMP/<MMDDHHMM>/<MMDDHHMM>.log
$TMP/<MMDDHHMM>/<hostname>_<SID>.xml
$TMP/<MMDDHHMM>/<hostname>_<SID>_apps.xml

The Rapidwiz Configuration File is saved in 4 locations:

$TMP/<MMDDHHMM>/conf_<SID>.txt
Primary $INST_TOP/conf_<SID>.txt
Secondary $INST_TOP/conf_<SID>.txt
<RDBMS ORACLE_HOME>/appsutil/conf_<SID>.txt

Preinstall System Check logs:

$TMP/<MMDDHHMM>/<MMDDHHMM>.log
$TMP/dbPreInstCheck.xxxxx.log
$TMP/wtprechk.xxxx/wtprechk.xxxx.log

<Global Inventory>/logs/installActions<timestamp>.log

Database Tier:

Main installation log:

RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDHHMM>.log

Oracle Home installation logs:

RDBMS $ORACLE_HOME/temp/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.install0.log
RDBMS $ORACLE_HOME/temp/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.default0.log
<Global Inventory>/logs/<timestamp>.log
<Global Inventory>/logs/cloneActions<timestamp>.log
<Global Inventory>/logs/install<timestamp>.log
<Global Inventory>/logs/installActions<timestamp>.log
<Global Inventory>/logs/installProfile<timestamp>.log
<Global Inventory>/logs/installSummary<timestamp>.log
<Global Inventory>/logs/OPatch<timestamp>.log
<Global Inventory>/logs/oraInstall<timestamp>.log
<Global Inventory>/logs/silentInstall<timestamp>.log

RMAN restore scripts (Install mode only):

<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac1.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac2.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-rac3.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single1.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single2.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/restore-single3.log
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/LogOff.sql
<RDBMS Oracle Home>/appsutil/out/$CONTEXT_NAME/fndClean.sql

Database characterset conversion (Install mode only):

<ORACLE_HOME>/appsutil/log/<Context Name>/addbccnv.txt

AutoConfig context file:

<RDBMS ORACLE_HOME>/appsutil/<Context Name>.xml

AutoConfig logs:

<RDBMS ORACLE_HOME>/appsutil/log/<Context Name>/<MMDDHHMM>/adconfig.log
<RDBMS ORACLE_HOME>/appsutil/log/<Context Name>/<MMDDHHMM>/NetServiceHandler.log
<RDBMS ORACLE_HOME>/temp/$CONTEXT_NAME/RACAutoConfig_nnnnn.log

Listener log:

<RDBMS ORACLE_HOME>/appsutil/log/$CONTEXT_NAME/addlnctl.txt

Applications Tier(s):

Both Primary (Run) and Secondary Edition (Patch) file systems will each contain these logs:

Main installation log:

$INST_TOP/logs/<MMDDHHMM>.log
FMW and OHS TechStack Installation/Patching logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ebsfmwlayout.log
$APPL_TOP/admin/$CONTEXT_NAME/log/NetServiceHandler.log
$APPL_TOP/admin/$CONTEXT_NAME/log/adcvmlog.xml
$APPL_TOP/admin/$CONTEXT_NAME/log/executeac.log
$APPL_TOP/admin/$CONTEXT_NAME/log/deploytech.log

$APPL_TOP/admin/$CONTEXT_NAME/logs/wls1036.log
$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.default0.log
$APPL_TOP/admin/$CONTEXT_NAME/logs/oracle.apps.fnd.txk.install0.log

<Global Inventory>/logs/<timestamp>.log
<Global Inventory>/logs/cloneActions<timestamp>.log
<Global Inventory>/logs/install<timestamp>.log
<Global Inventory>/logs/installActions<timestamp>.log
<Global Inventory>/logs/installProfile<timestamp>.log
<Global Inventory>/logs/installSummary<timestamp>.log
<Global Inventory>/logs/OPatch<timestamp>.log
<Global Inventory>/logs/oraInstall<timestamp>.log
<Global Inventory>/logs/silentInstall<timestamp>.log

Forms Oracle Home installation logs:

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log

$INST_TOP/admin/log/ohclone.log
$INST_TOP/admin/log/ApplyAppsTechStack_<MMDDHHMM>.log

Service Control logs :

$INST_TOP/logs/appl/admin/log/adadminsrvctl.txt
$INST_TOP/logs/appl/admin/log/adalnctl.txt
$INST_TOP/logs/appl/admin/log/adapcctl.txt
$INST_TOP/logs/appl/admin/log/adcmctl.txt
$INST_TOP/logs/appl/admin/log/adforms-c4wsctl.txt
$INST_TOP/logs/appl/admin/log/adformsctl.txt
$INST_TOP/logs/appl/admin/log/adnodemgrctl.txt
$INST_TOP/logs/appl/admin/log/adoacorectl.txt
$INST_TOP/logs/appl/admin/log/adoafmctl.txt
$INST_TOP/logs/appl/admin/log/adopmnctl.txt
$INST_TOP/logs/appl/admin/log/adstpall.log
$INST_TOP/logs/appl/admin/log/adstrtal.log
$INST_TOP/logs/appl/admin/log/jtffmctl.txt

 

Thank You !!

ORA-39097 Data Pump job encountered unexpected error

ERROR:
Export: Release 10.2.0.3.0 – Production on Wednesday, 08 August, 2007 10:12:50
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found
ORA-39097: Data Pump job encountered unexpected error 100
Another possible error received after applying a PSU or CPU patch.
ORA-39006: internal error
ORA-39213: Metadata processing is not available

CAUSE/CHANGE:

Applied a CPU or PSU patch.

SOLUTION:

Some DataPump Metadata stored in the METANAMETRANS$ table was missing. You can verify this by selecting from the table which will likely return no rows.

SQL> connect / as sysdba
SQL> select count(*) from metanametrans$;

COUNT(*)
———-
0

While on a database where this table is correctly populated, should return many rows similar to the following run against a 10.2 database:

SQL> select count(*) from metanametrans$;

COUNT(*)
———-
2499
Run the following scripts connected as SYSDBA:
sqlplus / as sysdba
@$ORACLE_HOME/rdbms/admin/catmet2.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql

 

Thank You !!