Sunday, 19 July 2020

[UNEXPECTED]Data dictionary corruption - timestamp mismatch

Issue: 


Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/adop.log
===========================================================================

Validating configuration on node: [appsserver1].
    Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/prepare/validate/appsserver
        [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.

Verifying data dictionary.
    [UNEXPECTED]Data dictionary corrupted:
    [UNEXPECTED]Data dictionary corruption - timestamp mismatch
    APPS            RCV_LCM_WEB_SERVICE            V_20190112_0223 APPS            INL_INTEGRATION_GRP            V_20190112_0223 TS mismatch: 18-MAR-19 03:10:47 07-JUL-20 23:09:30
    APPS            INV_RULE_GEN_PVT               V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            GMI_MO_PURGE                   V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            GMI_PICK_RELEASE_PUB           V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            PA_PURGE_COSTING               V_20190112_0223 APPS            PAAPIMP_PKG                    V_201


SOLUTION:

SQL> !vi $AD_TOP/patch/115/sql/adzddtsfix.sql

SQL> @$AD_TOP/patch/115/sql/adzddtsfix.sql
exec dbms_utility.invalidate(5666082,NULL,0);
exec dbms_utility.invalidate(6541212,NULL,0);


SQL> !vi adzddtsfixout.sql

SQL> @adzddtsfixout.sql
PL/SQL procedure successfully completed.


SQL> @$ORACLE_HOME/rdbms/admin/utlrp

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2020-07-19 04:43:19


and Re-check  the issue, it will be done :)  Enjoy

Posted by at 1 comment:

Sunday, 23 February 2020



R12.2 Upgrade: Rapidwiz Prerequisite Check Fails With Message: DB Version Check Has Failed. Not able to check the Database version. Please make sure the Database is at 11.2.0.3 or higher





Solution:

To resolve the database connectivity issue, perform the following steps :

1. Review the sqlnet_ifile.ora or sqlnet.ora file and confirm the following entries are present:
  SQLNET.ALLOWED_LOGON_VERSION_SERVER

2. Update the sqlnet_ifile.ora or sqlnet.ora settings for the above parameters to the lowest version level 
that is required in your environment. 

For example:

a) If the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE:

  SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

b) If SEC_CASE_SENSITIVE_LOGON is set to TRUE

  SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10

After this Database connectivity issue should be resolved.

Modify the service_names parameter to include ebs_patch as shown below and retry.

SQL> sho parameter service
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ORCL

SQL> alter system set service_names='ORCL','ebs_patch' scope=both ;
System altered.
SQL> sho parameter service
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ORCL, ebs_patch



Posted by at No comments:

Sunday, 16 February 2020

SP2-0734: unknown command beginning when recreate controlfile


Create backup for controlfile
SQL> alter database backup controlfile to trace as ‘d:\control\test.trc’;
Database altered.
Recreate Controlfile, Edit the test.trc file and when i try to recreate the control file , it showing SP-0734
SQL> SHUTDOWN ABORTORACLE instance shut down.
SQL> @D:\control\CONTROL.TRC;ORACLE instance started.
Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             331350480 bytes
Database Buffers          197132288 bytes
Redo Buffers                5804032 bytes
SP2-0042: unknown command “DATAFILE” – rest of line ignored.
SP2-0734: unknown command beginning “‘D:\CONTRO…” – rest of line ignored.SP2-0734: unknown command beginning “‘D:\CONTRO…” – rest of line ignored.
SP2-0734: unknown command beginning “‘D:\CONTRO…” – rest of line ignored
This happened due to blank line before the DATAFILE clause and after — STANDBY LOGFILE and  remove that space line as well as remove line — STANDBY LOGFILE and re run the script,
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “AZAR” NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 8
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 ‘C:\DATAFILES\AZAR\REDO01.LOG’  SIZE 50M BLOCKSIZE 512,
  GROUP 2 ‘C:\DATAFILES\AZAR\REDO02.LOG’  SIZE 50M BLOCKSIZE 512,
  GROUP 3 ‘C:\DATAFILES\AZAR\REDO03.LOG’  SIZE 50M BLOCKSIZE 512
— STANDBY LOGFILE                                                             [ REMOVE THIS SPACE LINE ]
DATAFILE  ‘C:\DATAFILES\AZAR\SYSTEM01.DBF’,
  ‘C:\DATAFILES\AZAR\SYSAUX01.DBF’,
  ‘C:\DATAFILES\AZAR\UNDOTBS01.DBF’,
  ‘C:\DATAFILES\AZAR\USERS01.DBF’,
  ‘C:\TEST01.DBF’
CHARACTER SET AR8ISO8859P6
;
After removed space
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “AZAR” NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 8
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 ‘C:\DATAFILES\AZAR\REDO01.LOG’  SIZE 50M BLOCKSIZE 512,
  GROUP 2 ‘C:\DATAFILES\AZAR\REDO02.LOG’  SIZE 50M BLOCKSIZE 512,
  GROUP 3 ‘C:\DATAFILES\AZAR\REDO03.LOG’  SIZE 50M BLOCKSIZE 512
DATAFILE
  ‘C:\DATAFILES\AZAR\SYSTEM01.DBF’,
  ‘C:\DATAFILES\AZAR\SYSAUX01.DBF’,
  ‘C:\DATAFILES\AZAR\UNDOTBS01.DBF’,
  ‘C:\DATAFILES\AZAR\USERS01.DBF’,
  ‘C:\TEST01.DBF’
CHARACTER SET AR8ISO8859P6
;
SQL> shutdown abortORACLE instance shut down.
SQL> @D:\control\CONTROL.TRC;
ORACLE instance started.
Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             331350480 bytes
Database Buffers          197132288 bytes
Redo Buffers                5804032 bytes
Control file created.
SQL> select status from v$instance;
STATUS
————
MOUNTED
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
————
OPEN

Oracle RMAN – ORA-07446: sdnfy: bad value

Check your pfile/spfile for any misconfigured parameters.  Most of the time, it got to do with your bdump, udump or cdump.
Make sure the directory specified is valid
For me, after I created the bdump and cdump folder, it was okay.



Check your pfile/spfile for any misconfigured parameters.  Most of the time, it got to do with your bdump, udump or cdump.
Make sure the directory specified is valid
For me, after I created the bdump and cdump folder, it was okay.

  1. Check your pfile/spfile for any misconfigured parameters.  Most of the time, it got to do with your bdump, udump or cdump.
  2. Make sure the directory specified is valid
For me, after I created the bdump and cdump folder, it was okay.




Posted by at No comments:

Tuesday, 14 May 2019

How to trace a session when user is trying to run reports remotely or from any website for a slowness issue:


I recently faced this issue where our client is seeing some slowness issues while running reports via
from some portal kinda webiste. So, bascially we jus need to figure out the SQL_ID of the sql
queries they are running.
  • When the user runs the report, fetch the sid , spid from TOAD ( easy way )  or v$session
select sid,spid from v$session where status='ACTIVE' and type!='BACKGROUND'
 connect / as sysdba
 oradebug setospid 28611 – this is os pid you want to trace
 oradebug unlimit
 oradebug event 10046 trace name context forever,level 12;
 oradebug event 10053 trace name context forever,level 1;

  oradebug tracefile_name;  -- this will give you the trace file name.

  oradebug event 10046 trace name context off;
 oradebug event 10053 trace name context off;
    

Now check your trace file:

 /orahome/oracle/product/11.2.0.4/diag/rdbms/wmsprd/wmsprd/trace/wmsprd_ora_28611.trc
/orahome/oracle/product/11.2.0.4/diag/rdbms/wmsprd/wmsprd/trace/wmsprd_ora_29076.trc
Check the historical executions and PHV history for the SQL ID:

 select SQL_ID,SQL_PLAN_HASH_VALUE,to_char(SQL_EXEC_START,'DD-MON-RR HH24:MI')  from dba_hist_active_sess_history where SQL_ID='93zs4x57ktash'


Posted by at No comments:

Sunday, 17 February 2019

EXPDP/IMPDP WITHOUT TABLE DATA (META DATA ONLY)

Export Schema without data (META DATA ONLY)

expdp system/s 
directory=backup_dir 
CONTENT=METADATA_ONLY 
dumpfile=testmetaddl.dmp 
schemas=testmeta 
logfile=testmetalog.$Date.log
Import DMP File:
 
impdp system/s 
directory=backup_dir 
dumpfile=testmetaddl.dmp 
sqlfile=metaddl.sql 
logfile=imp_log_of_meta.log
Posted by at No comments:

EBS 12.2.3 Cloning Steps


EBS 12.2.3 Cloning Steps

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

Adcgfclone path:- [appltest@crp bin]$ pwd
/application/appltest/systest/fs1/EBSapps/comn/clone/bin
Copy database backup from source to target node on db and apps.
1. first shutdown the application, database, listener  on target node.
2. then remove the all the directory of fs1,fs2,fs_ne and in database also.
For apps:- /application/appltest/systest/  remove all the directory
fordb:- /oracle/oratest         remove all the directory
    3.       then unzip the  backup directory.
    4.    then remove the the fs2 files full,  and also remove files from fs_ne ,and remove inst,fmw from fs1 of backup unzipped backup directory.
    5.    then move backup directory to database and application to application
        For db:-
      Database  [oratest@crporatest]$ mv db /oracle/oratest/
      Application [appltest@crp appltest]$ mv * /application/appltest/systest/

   6.    and then run adfgclone command.


Perl adcfgclone command on 12.2.3 on Database Tier

Dbtieradcfgclone command
[oratest@crp bin]$ ls -ltr
total 172
-rwxr-xr-x 1 oratestdba 76411 Mar  5 12:59 adclone.pl
-rwxr-xr-x 1 oratestdba  5101 Mar  5 12:59 adchkutl.sh
-rwxr-xr-x 1 oratestdba 37265 Mar  5 12:59 adclonectx.pl
-rwx--x--x 1 oratestdba 48371 Mar  5 12:59 adcfgclone.pl
/dbt1/oracle/11.2.0/appsutil/clone/bin
[oratest@crp bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

adcfgclone Version 120.63.12020000.7.1202010.2

Enter the APPS password :

Running:
/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /oracle/or                     atest/db/systest/11.2.0/appsutil/clone/jlib/java:/oracle/oratest/db/systest/11.2.0/appsutil/                     clone/jlib/xmlparserv2.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/ojdbc5.ja  oracle.apps.ad.context.CloneContext -e /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/                     ../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_43952.lst -stage /oracle/ora                     test/db/systest/11.2.0/appsutil/clone  2> /tmp/adcfgclone_43952.err; echo $? > /tmp/adcfgclo                     ne_43952.res

Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContext_062000                     3742.log

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

Target System Hostname (virtual or normal) [crp] :

Target Instance is RAC (y/n) [n] : n

Target System Database SID : GORAK

Target System Base Directory : /oracle/oratest/db/systest

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/u01/oratest/db/systest/data] :
RC-00002: Warning: Directory /u01/oratest/db/systest/data not found.

Target System DATA_TOP Directory 1 [/u01/oratest/db/systest/data] : /oracle/oratest/db/systest/data

Target System RDBMS ORACLE_HOME Directory [/oracle/oratest/db/systest/11.2.0] :

Do you want to preserve the Display [null] (y/n)  : n

Target System Display [crp:0.0] :

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] : 8

Checking the port pool 8
done: Port Pool 8 is free
Report file located at /oracle/oratest/db/systest/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /oracle/oratest/db/systest/11.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /oracle/oratest/db/systest/11.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
 /oracle/oratest/db/systest/11.2.0/appsutil/GORAK_crp.xml

Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContext_062000                     3742.log
Check Clone Context logfile /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/CloneContex                     t_0620003742.log for details.

Running Rapid Clone with command:
Running:
perl /oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/adclone.pl java=/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/oracle/oratest/db/systest/11.2.0                     /appsutil/clone component=dbTier method=CUSTOM dbctxtg=/oracle/oratest/db/systest/11.2.0/app                     sutil/GORAK_crp.xml showProgresscontextValidated=true


Beginning database tier Apply - Fri Jun 20 00:40:24 2014

/oracle/oratest/db/systest/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALI                     DATED=true  -Doracle.installer.oui_loc=/oracle/oratest/db/systest/11.2.0/oui -classpath /ora                     cle/oratest/db/systest/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/oratest/db/systest                     /11.2.0/appsutil/clone/jlib/ojdbc6.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib                     /java:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/ora                     test/db/systest/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/oratest/db/systest/11.2.0/ap                     psutil/clone/jlib/oui/share.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/oui/sr                     vm.jar:/oracle/oratest/db/systest/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /oracle/oratest/db/systest/11.2.0/appsutil/GORAK_crp.xml -stage /oracle/o                     ratest/db/systest/11.2.0/appsutil/clone   -showProgress
APPS Password : Log file located at /oracle/oratest/db/systest/11.2.0/appsutil/log/GORAK_cr                     p/ApplyDBTier_06200040.log
  |     15% completed

Completed Apply...
Fri Jun 20 00:43:54 2014

Starting database listener for Karuna:
Running:
/oracle/oratest/db/systest/11.2.0/appsutil/scripts/GORAK_crp/addlnctl.sh start Karuna


(move EBSapps from fs1 to fs2) cp -pr EBSapps /appt1/applmgr/fs2
Perl adcfgprecloneappsTier on 12.2.3

/appt1/devapps/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/prereq/linux64


Run this scripts  /tmp/orainstRoot.sh
. ./orainstRoot.sh   (after execute this command bydefault jump to application

Run Time

[appltest@crp bin]$pwd
/application/appltest/systest/fs1/EBSapps/comn/clone/bin

[appltest@crp bin] perl adcfgclone.pl appsTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.26

Enter the APPS password :
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the WeblogicAdminServer password :
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource


Do you want to add a node (yes/no) [no] : no


Running:
/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /application/appltest/systest/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_18183.lst -stage /application/appltest/systest/fs1/EBSapps/comn/clone  2> /tmp/adcfgclone_18183.err; echo $? > /tmp/adcfgclone_18183.res

Log file located at /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log

Target System File Edition type [run] : run

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

Target System Hostname (virtual or normal) [crp] :

Target System Database SID : TEST

Target System Database Server Node [crp] :

Target System Database Domain Name [phfi.org] :

Target System Base Directory :  /application/appltest/systest

Target System Base Directory set to /application/appltest/systest

Target System Current File System Base set to /application/appltest/systest/fs1

Target System Other File System Base set to /application/appltest/systest/fs2

Target System Fusion Middleware Home set to /application/appltest/systest/fs1/FMW_Home

Target System Web Oracle Home set to /application/appltest/systest/fs1/FMW_Home/webtier

Target System Appl TOP set to /application/appltest/systest/fs1/EBSapps/appl

Target System COMMON TOP set to /application/appltest/systest/fs1/EBSapps/comn

Target System Instance Home Directory [/application/appltest/systest] :

Target System Instance Top set to /application/appltest/systest/fs1/inst/apps/TEST_crp

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

Target System Display [crp:0.0] :

Target System Root Service [enabled] :

Target System Web Administration [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] : 6

Checking the port pool 6
done: Port Pool 6 is free
Report file located at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/out/portpool.lst
Complete port information available at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2./usr/tmp
3./oracle/oratest/db/systest/11.2.0/appsutil/outbound/TEST_crp
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /application/appltest/systest/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml

Log file located at /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log
Check Clone Context logfile /application/appltest/systest/fs1/EBSapps/comn/clone/bin/CloneContext_0619130725.log for details.

Running Rapid Clone with command:
Running:
perl /application/appltest/systest/fs1/EBSapps/comn/clone/bin/adclone.pl java=/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/application/appltest/systest/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml showProgresscontextValidated=true



FMW Pre-requisite check log file location : /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs1/EBSapps/comn/clone -log /application/appltest/systest/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Thu Jun 19 13:08:20 2014

/application/appltest/systest/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /application/appltest/systest/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/application/appltest/systest/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/application/appltest/systest/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg
Log file located at /application/appltest/systest/fs1/inst/apps/TEST_crp/admin/log/clone/ApplyAppsTier_06191308.log
  /    100% completed

Completed Apply...
Thu Jun 19 13:25:55 2014


 Executing command: /application/appltest/systest/fs1/EBSapps/10.1.2/bin/sqlplus @/application/appltest/systest/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql


Do you want to startup the Application Services for TEST? (y/n) [n] : n

Services not started

[appltest@crp fs1]$
[appltest@crp fs1]$ pwd
/application/appltest/systest/fs1
[appltest@crp fs1]$
[appltest@crp fs1]$




Now copy the EBSapps from FS1 TO fs2 and give TOP Number 1 greater than top gave to DB and Fs1
[appltest@crp fs1]$ cp -pr  EBSapps/  /application/appltest/systest/fs2
[appltest@crp fs1]$
[appltest@crp fs1]$
[appltest@crp fs1]$
Patch Level Autoconfig


[appltest@crp bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.26

Enter the APPS password :
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the WeblogicAdminServer password :
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource


Do you want to add a node (yes/no) [no] : no


Running:
/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /application/appltest/systest/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_18972.lst -stage /application/appltest/systest/fs2/EBSapps/comn/clone  2> /tmp/adcfgclone_18972.err; echo $? > /tmp/adcfgclone_18972.res

Log file located at /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /application/appltest/systest/fs1/inst/apps/TEST_crp/appl/admin/TEST_crp.xml
or
/appt1/applmgr/fs1/inst/apps/DEVNEW_sristidev/appl/admin/DEVNEW_sristidev.xml
Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /application/appltest/systest/fs2/FMW_Home

Target System Web Oracle Home set to /application/appltest/systest/fs2/FMW_Home/webtier

Target System Appl TOP set to /application/appltest/systest/fs2/EBSapps/appl

Target System COMMON TOP set to /application/appltest/systest/fs2/EBSapps/comn

Target System Instance Top set to /application/appltest/systest/fs2/inst/apps/TEST_crp

Target System Port Pool [0-99] : 7

Checking the port pool 7
done: Port Pool 7 is free
Report file located at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/out/portpool.lst
Complete port information available at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2./usr/tmp
3./oracle/oratest/db/systest/11.2.0/appsutil/outbound/TEST_crp
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /application/appltest/systest/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml

Log file located at /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log
Check Clone Context logfile /application/appltest/systest/fs2/EBSapps/comn/clone/bin/CloneContext_0619141550.log for details.

Running Rapid Clone with command:
Running:
perl /application/appltest/systest/fs2/EBSapps/comn/clone/bin/adclone.pl java=/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/application/appltest/systest/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml showProgresscontextValidated=true



FMW Pre-requisite check log file location : /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs2/EBSapps/comn/clone -log /application/appltest/systest/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply - Thu Jun 19 14:16:36 2014

/application/appltest/systest/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /application/appltest/systest/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/java:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/application/appltest/systest/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/application/appltest/systest/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/application/appltest/systest/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /application/appltest/systest/fs2/inst/apps/TEST_crp/appl/admin/TEST_crp.xml -stage /application/appltest/systest/fs2/EBSapps/comn/clone    -showProgress -nopromptmsg
Log file located at /application/appltest/systest/fs2/inst/apps/TEST_crp/admin/log/clone/ApplyAppsTier_06191416.log
  -    100% completed

Completed Apply...
Thu Jun 19 14:34:22 2014

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

Updating incomplete CLONE record to COMPLETED
[appltest@crp bin]$
[appltest@crp bin]$
Posted by at No comments:

Tuesday, 9 October 2018


 DATA PUMP JOB ERROR :

 ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.EXPDPFULL"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-00955: name is already used by an existing object


/bin/grep: /datapump/full_backup/expdp_FULL.log: No such file or directory
/bin/grep: /datapump/full_backup/expdp_FULL.log: No such file or directory



Problem Symptoms:
The log shows:
create_customer_data.log:ORA-31626: job does not exist
create_customer_data.log:ORA-31633: unable to create master table "ALEPH_ADMIN.ABC01_JOB"
create_customer_data.log:ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
create_customer_data.log:ORA-06512: at "SYS.KUPV$FT", line 863
create_customer_data.log:ORA-00955: name is already used by an existing object

Cause:
The error is caused by a stopped job that remained in the dba_datapump_jobs. The new expdp job has the same name as the old expdp job.

Resolution:
Clear the old expdp job or specify a different jobname

1. Connect to SQL*Plus as ALEPH_ADMIN:
sqlplus $ALEPH_ADMIN

2. Determine in SQL*Plus which Data Pump jobs exist in the database:
-- locate Data Pump jobs:
SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;

3. Ensure that the listed jobs in dba_datapump_jobs are not export/import Data Pump jobs that are active: status should be 'NOT RUNNING'.

4. Check with the job owner that the job with status 'NOT RUNNING' in dba_datapump_jobs is not an export/import Data Pump job that has been temporary stopped, but is actually a job that failed.

5. Determine in SQL*Plus the related master tables:
SELECT o.status, o.object_id, o.object_type, o.owner||'.'||object_name "OWNER.OBJECT"
FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

6. For jobs that were stopped in the past and won't be restarted anymore, delete the master table. E.g.:
DROP TABLE scott.sys_export_table_02;

Note: In the case of an Upgrade Express export which was getting this error, the following worked:

drop table ALEPH_ADMIN.ABC50_JOB;
Posted by at No comments:
Subscribe to: Posts (Atom)