Here you go

Thursday, November 24, 2016

[ERROR] etcc not run in database


prepare phase failed [ERROR] etcc not run in database




While applying patch using adop receiving error :


[ERROR] etcc not run in database


Solution:

1 - Run etcc if not already run (for Linux: checkDBpatch.sh  or for windows: checkDBpatch.cmd). 
     ( You can download patch : 17537119 for the EBS Technology Codelevel Checker (ETCC) )


2 -  If you have already ran checkDBpatch.sh or checkDBpatch.cmd and receiving error:
      [ERROR] etcc not run in database
    
      Then
      Validate the correct entry in following table : applsys.txk_tcc_results:

   
      set node_name   = server_name       ( server_name.domain.com )

      For example : 
            1 - If your node_name does not exists. Then run auto-config.
OR
            2 -  If node_name has wrong entry like : server_name.domain.com
                  Then update it like >   update applsys.txk_tcc_results set node_name = 'server_name'    
                   


Tuesday, November 8, 2016

E-Business Suite R12.2.5 Cloning / E-Business Suite R12.2.6 Cloning



Detailed Cloning Steps for EBS 12.2.5


Note: Assumption fs1 is run file system:

On Source System


Run Auto-Config Steps:


APPS:
. /d01/oracle/UAT/EBSapps.env RUN

scp /d01/oracle/UAT/fs1/inst/apps/UAT_server/admin/out/appsutil.zip oracle@192.168.200.102:/d01/oracle/UAT/db/tech_st/12.1.0

DB:
. /u01/oracle/UAT/db/tech_st/12.1.0/UAT_server.env
cd $ORACLE_HOME
unzip -o appsutil.zip
cd $ORACLE_HOME/appsutil/scripts/UAT_server/


Run Pre-Cloning Steps:


DB:
. /d01/oracle/UAT/db/tech_st/12.1.0/UAT_server.env
cd $ORACLE_HOME/appsutil/scripts/UAT_server/
perl adpreclone.pl dbTier

APPS:
. /d01/oracle/UAT/EBSapps.env Run
cd $ADMIN_SCRIPTS_HOME
perl adpreclone.pl appsTier

Take Backup:

Down services (application and database) and take backup(s).
Move backup(s) on target system.

On Target System


Run Cloning Steps:


DB:

export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1:$ORACLE_HOME/appsutil/perl

export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH





Questions:
1- Target System Hostname (virtual or normal) [server]:
2- Target Instance is RAC (y/n) [n]:
3- Target System Database SID: UAT
4- Target System Base Directory: /u01/oracle/UAT/
5- Target System utl_file_dir Directory List: /usr/tmp
6- Number of DATA_TOP's on the Target System [1]:
7- Target System DATA_TOP Directory 1 [/d01/oracle/UAT/db/apps_st/data]:
8- Target System RDBMS ORACLE_HOME Directory [/d01/oracle/UAT/11.2.0]: /d01/oracle/UAT/db/tech_st/12.1.0
9- Do you want to preserve the Display [null] (y/n) : n
10-Target System Display [vision:0.0] :
11-Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
12-Specify port: 0



APPS:

Make following directories for apps cloning on Target System:
               For Example:
                               mkdir -p /d01/oracle/UAT/fs1/
                               mkdir -p /d01/oracle/UAT/fs2/
                               mkdir -p /d01/oracle/UAT/fs_ne/

Now copy EBSapps from source run file system (in my case fs1) to target run file system:
Make sure fs_ne and patch file system (in my case fs2) should be empty before starting the cloning.

Open new terminal session.

Then perform following steps: (Note: fs1 is run file system in my case)

On EBS 12.2.5 + you can run cloning using DUALFS option.
 
cd /d01/oracle/UAT/fs1/EBSapps/comn/clone/bin/
perl adcfgclone.pl appsTier dualfs

Provide apps password:
Provide weblogic password:

Questions:
Do you want to add a node (yes/no) [no] :
Target System Hostname (virtual or normal) [upgrade2] :
Target System Database SID : UAT
Target System Database Server Node [upgrade2] :
Target System Database Domain Name [geo.corp.int] :
Target System Base Directory : /d01/oracle/UAT
Target System Instance Home Directory [/d01/oracle/UAT] :
Do you want to preserve the Display [upgrade1:0.0] (y/n)  : n
Target System Display [upgrade2: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] : enabled
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                 [Hint: Provide Port for Run FS]
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /d01/oracle/UAT/db/tech_st/12.1.0/appsutil/outbound/UAT_upgrade2
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]: 1
Patch file system details.....
Target System Port Pool [0-99]: 1                  [Hint: Provide Port for Patch FS (i.e. Run FS Port + 1)]