Wednesday 14 September 2022

EBS 12.2.10 WebLogic Console is not working

Weblogic Console is not working getting this error 

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

cd $FMW_HOME/user_projects/domains/EBS_domain/config
cp config.xml config.xml_org

erpr12.appsdba.info * * allow

# Update deny to allow in the file config.xml

old

0.0.0.0/0 * * deny

New
0.0.0.0/0 * * allow

Bounce the admin server

and retry the issue 

Tuesday 25 August 2020

 

DR Dril switchover and failover for EBS DB and apps

Switchover check

Verify that the target standby is ready for switchover.

Shut down EBS Application on Primary Side..

$ADMIN_SCRIPTS_HOME/

/ebsapps/finptch/inst/apps/FINPTCH_kelserpopapt06/admin/scripts

./adstpall.sh apps/ apps password

Preparing for switchover to standby server

1. Verify the primary database instance is open and standby database instance is mounted.

2. Verify there are no active users connected to the database. Shut down all the sessions in the primary database.

3. Ensure that the last redo data transmitted from the primary database was applied on the standby database. Issue the following SQL command on the primary and standby databases to find out. If necessary, perform a log file switch before the first command.

SQL>select sequence#,applied from v$archived_log;

4. Check whether the primary is ready for switch. Query the switchover_status column of the v$database fixed view to determine whether the database is ready to switch modes.

SQL>select switchover_status from v$database;

If this query returns "TO STANDBY", then the environment is ready to switch. If it returns "ACTIVE SESSIONS", then the switch command should be used with the 'session shutdown' option.

Initiate the switchover on the primary database

5. Switch over the current production database(172.23.*.*) to the standby database.

SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY WITH SESSION SHUTDOWN;

After complete this command DB is going to Down.

Need to start DB in mount Status..

SQL> startup mount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4.2950E+10 bytes

Fixed Size 4508576 bytes

Variable Size 6979322976 bytes

Database Buffers 3.5836E+10 bytes

Redo Buffers 129708032 bytes

Database mounted.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Database altered.

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

SQL>

Run On Primary DB ( 172.23.*.* )

alter system set log_archive_dest_state_3='defer' scope=both;

6. Convert the former Standby database(172.23.1*.*) to a Primary (Production) database.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

7.Now open New Primary (earlier it was standby) database(172.23.1*.*):

SQL> ALTER DATABASE OPEN;

ALTER SYSTEM SWITCH LOGFILE;

8. Check the DB sync is happening or not.

172.23.1*.*

==========

select thread#, max(sequence#) "Last Primary Seq Generated" from v$archived_log where first_time between (sysdate-7) and (sysdate+1) group by thread# order by 1;

select thread#, max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;

Complete the database configurations

1. Connect to the new primary database using SQL*Plus as user APPS, and execute the following commands:

SQL>exec fnd_net_services.remove_system('<SID>'); SQL>commit; SQL>exec fnd_conc_clone.setup_clean ;

2. As the oracle user on the new primary database server, use AutoConfig to complete configuration for primary operations, providing the APPS password when prompted:

$ cd <RDBMS_ORACLE_HOME>/appsutil/scripts/<context> $ ./adautocfg.sh

When run the adautocfg get the error.

Check in screen short.

Fix the error

Solution..

SQL> create temporary tablespace temp1 tempfile '+FINSIT/FINPTCH_DR/TEMPFILE/temp01.dbf' size 10G;

Tablespace created.

SQL> alter database default temporary tablespace temp1;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

SQL> select NAME,STATUS from v$tempfile;

Configuring Application Tiers After Role Transition (switchover, failover)

First Time Need to create context file..

perl adcfgclone.pl appsTier

[ NON-PROD applsit@apps node

 /ebsapps/finsit/finptch/apps/apps_st/comn/clone/bin]$ perl adcfgclone.pl appsTier

Copyright (c) 2002 Oracle Corporation

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.14

Enter the APPS password :

Running:

/ebsapps/finsit/finptch/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /ebsapps/finsit/finptch/apps/apps_st/comn/clone/jlib/java:/ebsapps/finsit/finptch/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/ebsapps/finsit/finptch/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /ebsapps/finsit/finptch/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_27070.lst -stage /ebsapps/finsit/finptch/apps/apps_st/comn/clone 2> /tmp/adcfgclone_27070.err; echo $? > /tmp/adcfgclone_27070.res

Log file located at /ebsapps/finsit/finptch/apps/apps_st/comn/clone/bin/CloneContext_0720134021.log

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

Target System Hostname (virtual or normal) [apps node] :

Target System Domain Name : airtel.africa

Target System Database SID : FINPTCH

Target System Database Server Node [apps node] : db hostname

Target System Database Domain Name [airtel.africa] :

Target System Base Directory : /ebsapps/finsit/finptch/

Target System Tools ORACLE_HOME Directory [/ebsapps/finsit/finptch/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/ebsapps/finsit/finptch/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/ebsapps/finsit/finptch/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/ebsapps/finsit/finptch/apps/apps_st/comn] :

Target System Instance Home Directory [/ebsapps/finsit/finptch/inst] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [disabled] : enabled

Target System Other Services [enabled] :

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

Target System Display [kelserpopapt07:0.0] : 0.0

RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /ebsapps/finsit/finptch/inst/apps/FINPTCH_apps_node. A directory with this name already exists and is not empty.

Do you want to continue (y/n) : y

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

Target System Port Pool [0-99] : 4

Checking the port pool 4

done: Port Pool 4 is free

Report file located at /ebsapps/finsit/finptch/inst/apps/FINPTCH_apps_node/temp/portpool.lst

Complete port information available at /ebsapps/finsit/finptch/inst/apps/FINPTCH_apps_node/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /oracle_home/app/12.1.0/orahome/appsutil/outbound/FINPTCH_db_node

2. /inst_top/asiprod/apps/FINPTCH_cpnqerpaapzp11/appltmp

3. /usr/tmp

4. /oracle/tmp/erp/p2ptat

Choose a value which will be set as APPLPTMP value on the target node [1] : 3

APPS Password : Log file located at /ebsapps/finsit/finptch/inst/apps/FINPTCH_apps_node/admin/log/ApplyAppsTier_07201344.log

| 73% completed

Completed Apply...

Mon Jul 20 13:50:11 2020

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

Starting application Services for FINPTCH:

Running:

After Start the application verify login page is coming our not.

Check Concurrent Status through

cmstatus.sql

SQL> select node_name,target_node,control_code from fnd_concurrent_queues;

SQL> update apps.fnd_concurrent_queues set node_name = 'New Node Name';

SQL> select NODE_NAME,NODE_MODE,STATUS from fnd_nodes;

SQL> update fnd_concurrent_queues set TARGET_NODE='New Node Name';

SQL> Commit;

Finish Oracle E-Business Suite configuration on application tiers

 

Friday 1 June 2018

Workflow SSL certificate installation Steps on 12.1.3

Steps:
In order to Configure Workflow Java Mailer with IMAP and SMTP email servers SSL enabled, need to perform the below steps

1. Export the Certificate from the Email server.
2. Create a keystore on the Concurrent Manager Tire. Import the certificate to keystore
3. Configure the Mailer to work with  IMAPSSL / SMTPSSL.
4. Steps for Debugging the Mailer.
5. R12.1.3 feature - Mailer Authentication

Protocol: SMTP/SSL Port : 465
Protocol: IMAP/SSL  Port : 993

1. Export the Certificate from the Email server.

In order to be able to establish a Secure communication channel, the certificate from the Email Server (issued by a Certification Authority) needs to be imported on the Concurrent Manager Tire.

The email server certificate issued by a trusted  Certification Authority (i.e. Verisign), can be obtain from the System Administrator or downloaded by following the below steps:


A. Access your main web page https://<host.domain:port>.      
B. Double-click on the padlock at the bottom of the page to view the Certificates.
If there is no padlock, then on the top toolbar:               
select File->Properties->Certificates       
C. Select the Certification Path tab and:       
a) click on the first line and then View Certificate.   - This will be the certificate for the root Certifying Authority (CA).         
b) On Details tab click Copy to File, this will start the export wizard.         
c) Click Next to continue.         
d) Select Base-64 encoded X.509 (.CER) and click next.         
e) Enter ca1 as the name and click ok to export the certificate.         
f) Repeat steps a thru e for each line on the Certification Path tab incrementing the file name each time by 1, i.e. ca2, ca3.


2. Create a keystore on the Concurrent Manager Tire. Import the certificate to keystore

a. Create a keystore that holds the certificate, use the default location (i.e. /home/applmgr)

keytool -genkey -alias -keystore -storetype JKS


 b. Upload the Certificate to the Concurrent Manager tire using a ftp tool then import the certificate into the created keystore:

keytool -import -alias my_cert -file server.cer -keystore .keystore -storepass workflow


c.Verify the cetificate

keytool -list -keystore .keystore



d. Set MAILER_SSL_TRUSTSTORE (i.e. /home/applmgr/.keystore )
    From sqlplus:

$FND_TOP/sql/afsvcpup.sql

3.  Configure the Mailer to work with IMAPSSL / SMTPSSL

   Navigation: Log on to OAM >System Administrator > Workflow Manager > Notification Mailer Link

   a.  Enter Outbound Server Name and validate check-box Outbound SSL Enable
   b. Enter  Inbound Server name , Username, Password, Reply-to Address and validate check-box Inbound SSL Enable.



After this process you are not able to stat the workflow service then you can use belwo commadn to debug.

4. Debugging Steps (i.e. for a R12 Instance)

a. SMTP

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp \
-Ddbcfile=$FND_SECURE/TEST.dbc \
-Dport=465 -Dssl=Y \
-Dtruststore=/home/applmgr/.keystore \
-Dserver=email.yourdomain.com \
-Daccount=youremail@yourdomain.com -Dpassword=xxxxx \
-Dconnect_timeout=120 -Ddebug=Y \
-DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer


b. IMAP

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \
-Ddbcfile=$FND_SECURE/TEST.dbc \
-Dport=993 -Dssl=Y \
-Dtruststore=/home/applmgr/.keystore \
-Dserver=email.yourdomain.com \
-Daccount=youremail@yourdomain.com -Dpassword=xxxxx\
-Dconnect_timeout=120 -Ddebug=Y \
-DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer


Monday 19 February 2018

How To Create Self Certificate In EBS R12 and Import Certificate in Wallet

How To Create Self Certificate In EBS R12 and Import Certificate in Wallet

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

First -

1. Creating a Wallet

    Verify the location of the Web SSL Directory:
        grep s_web_ssl_directory $CONTEXT_FILE
    Navigate to this directory which will have Apache and opmn sub-directories.
    Change to the Apache sub-directory.
    Backup any existing wallets (demo certificates are included in Release 12).
    Create your new wallet:
    orapki wallet create -wallet . -auto_login -pwd <password>

    "-wallet ." tells orapki that you want to create the wallet in the current directory.
                        You can also specify the full path to any directory where you wish to
                         create a wallet.
      " -auto_login" tells orapki that you want to create cwallet.sso which is an obfuscated copy
                             of ewallet.p12
                             With auto login enabled - processes submitted by the OS user who created
                             the wallet will not need to supply the password to access the wallet.

You should now see two wallet files in your directory:
     cwallet.sso
     ewallet.p12

This is for test server only. if you dont want to secure you link

Section 8: Self-Signed Testing Certificates

    SELF-SIGNED CERTIFICATES ARE NOT SECURE!!!
THEY SHOULD NOT BE USED IN A PRODUCTION ENVIRONMENT!!!

If you wish to self-sign your certificates for use in a TESTING Environment enter the following command all on 1 line substituting the appropriate parameters (in bold) for your instance:

orapki wallet add -wallet . -dn "CN=server.us.oracle.com,OU=Unit,O=Org,L=Orlando,ST=Florida,C=US" -keysize 2048 -self_signed -validity 3650 -pwd welcome1

Your wallet is now ready for use in your testing environment - do not use this wallet in a production environment.
Section 9: Converting Existing Certificates

If you have existing un-expired certificates from a previous implementation of SSL they can be converted and imported into a Release 12 wallet using the tools:
     SSL2OSSL (Unix)
     SSLCONVERT (Windows NT/2000)

Copy your server.key, server.crt, and ca.crt to the wallet directory and issue the command:

    $ORACLE_HOME/Apache/Apache/bin/ssl2ossl -cert ./server.crt -key ./server.key -cafile ./ca.crt -wallet . -ssowallet yes

Section 10: Adding and Removing the Auto_Login Feature

To enable auto_login:

    navigate to the wallet directory and use the same command used in Section 1 to create the wallet:
         orapki wallet create -wallet . -auto_login -pwd <password>

To disable auto_login you must use the Oracle Wallet Manger GUI interface:

    Navigate to the wallet directory.
    Start the Oracle Wallet Manager as a background process:
         owm &
    Open your existing wallet.
    Select Wallet from the menu bar.
    Deselect Auto Login.
      A message at the bottom of the window indicates that auto login is disabled.

Saturday 17 February 2018

DMZ setup on Oracle EBS R12



Creating an External Web Tier for E-Business Suite

Oracle E-Business Suite R12 Configuration in a DMZ (Doc ID 380490.1)
Clone the internal web tier to create a new external web tier
Pre-Clone Steps on Internal Server

- Run adpreclone.pl

As Database node :


cd $ORACLE_HOME/appsutil/scripts/DEV_Hostname

perl adpreclone.pl dbTier


As Application Node :


cd $ADMIN_SCRIPTS_HOME

perl adpreclone.pl appsTier


Take a backup of application mount point.

Restore the Backup into external server node.

Setup Host File:


Put the following entries in the Hosts File (/etc/hosts)

IP Addressh            yourhostname

IP Addressh           yourhostname


Change the owner Ship of /finerp/FINDEV folder and the file under it to apps


cd /dev


chown –R appdev:dba findev



Creating External Web Tier

Note:          Your steps should be more

Create XML file for External Server:

su – appdev

cd –--/apps/apps_st/comn/clone/bin

perl adclonectx.pl contextfile=---------------/inst/apps/dev_hostname/appl/admin/dev_hostname.xml


Enter the APPS password:

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

Do you want the inputs to be validated (y/n) [n]? :

Target System Database SID: dev

Target System Database Server Node [hostname]: extrenalhostname

Target System Base Directory: /dev/oradev/dev

Target System Forms ORACLE_HOME Directory [/dev/oradev/dev/apps/tech_st/10.1.2]:

Target System Web ORACLE_HOME Directory [/dev/oradev/dev/apps/tech_st/10.1.3]:

Target System APPL_TOP Mountpoint [/dev/oradev/dev/apps/apps_st/appl]:

Target System COMMON_TOP Directory [/dev/oradev/dev/apps/apps_st/comn]:

Target System Instance Home Directory [/dev/oradev/dev/inst]:

Username for the Applications File System Owner [appldev]:

Group for the Applications File System Owner [dba]:

Target System Root Service [enabled]:

Target System Web Entry Point Services [enabled]:

Target System Web Application Services [enabled]:

Target System Batch Processing Services [disabled]:

Target System Other Services [disabled]:

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

Target System Display [extrenalhostname:0.0]:

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

Target System Port Pool [0-99]: 1

Choose a value which will be set as APPLPTMP value on the target node [1]: 2

New context path and file name [/dev/oradev/dev/inst/apps/dev_extrnalhost/appl/admin/dev_extrnalhost.xml]:


Cross Check if the Context File generated is correct or not, check with following command if the respective components are enabled on extrenal hostname :


grep –i status $CONTEXT_FILE



Run adpreclone.pl to add the extrnal server as a node to dev:

su - appldev

cd /dev/appldev/dev/apps/apps_st/comn/clone/bin

perl adcfgclone.pl appsTier /dev/appldev/dev/inst/apps/dev_extrnalhost/appl/admin/dev_extrnalhost.xml

Enter the APPS password:

Check the logfile for any error.

CONTEXT_FILE configuration:


Modify the following CONTEXT_FILE parameters:


Context File Variable
   

Existing Value
   

New Value

s_applcsf
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/logs/appl/conc
   

/dev/appldev/dev/conc

s_appltmp
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/temp
   

/dev_appltmp

s_applptmp
   

/dev/appldev/dev/inst/apps/dev_extrnalhost/ptemp
   

/dev_applptmp

s_formshost
   

extrnalhost
   

dev

s_chronosURL
   

http://extrnalhost.externalhost.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
   

http://dev.externalhost.com:8001/oracle_smp_chronos/oracle_smp_chronos_sdk.gif

s_external_url
   

http://extrnalhost.externalhost.com:8001
   

http://dev.externalhost.com:8001

s_webentryhost
   

extrnalhost
   

dev

s_login_page
   

http://extrnalhost.externalhost.com:8001/OA_HTML/AppsLogin
   

http://dev.externalhost.com:8001/OA_HTML/AppsLogin


Run AutoConfig on all the Nodes.




Configuring extrnalhost for DMZ


Run the script txkChangeProfH.sql for the Profile option setup:


# Internal Node..

$ su – appldev


$ sqlplus apps/password


Update Hierarchy Type


@$FND_TOP/patch/115/sql/txkChangeProfH.sql SERVRESP


Run AutoConfig on all nodes.

Update Node Trust Level

To change the value of the Node Trust Level profile option value to External for a particular node, perform the following steps:

1. Login to Oracle E-Bsonapness Suite as sysadmin user sonapng the internal URL

2. Select the System Administrator Responsibility

3. Select Profile / System

4. From the 'Find system profile option Values' window, select the server and get the valie extrnalhost into it.

5. Query for %NODE%TRUST%. You will see a profile option named 'Node Trust Level'. The value for this profile option at the site level will be Normal. Leave this setting unchanged.

6. Set the value of this profile option to External at the server level. The site level value should remain set to Normal


Update List of Responsibility


To change the value of the Responsibility Trust Level profile option at the responsibility level for a particular responsibility, perform the following steps:

7. Login to Oracle E-Bsonapness Suite as sysadmin user sonapng the internal URL

8. Select System Administrator Responsibility

9. Select Profile / System

10. From the 'Find system profile option Values' window, select the responsibility that you want to make available to users logging in via the external web tier

11. Query for %RESP%TRUST%. You will see a profile option named 'Responsibility trust level'. The value for this profile option at site level will be Normal.  Leave this setting unchanged.

12. Set the value of this profile option for the chosen responsibility to External at the responsibility level. The site-level value should remain Normal.

13. Repeat for all responsibilities that you want to make available from the external web tier.


List of Responsibilities which can be enabled on External Server is as followed:


Product Name
   

Externally Accessible Responsibilites
   

Additional Profile Options

iSupplier
   


Do this as per your requirment
   

POS: External URL

POS: Internal URL

Oracle Sourcing
   

Sourcing Supplier
   

PON: External Applications Framework Agent

PON: External login URL

Oracle iProcurement
   

Self Registered Employee Default Responsibility

Self Registered New User Default Responsibility
   



q Enable Oracle E-Business Suite Application Server Security

1. Set the value of Application Server Security Authentication (s_appserverid_authentication) to SECURE, in the CONTEXT_FILE on all the nodes.

2. Run AutoConfig on each Applications middle tier to complete the configuration.

3. After AutoConfig completes successfully, restart Oracle HTTP Server and OC4J processe


Run Autoconfig

Run AutoConfig from ADMIN_SCRIPTS_HOME.


Internal Node and Extrenal node.


After start the service and check..





Saturday 10 February 2018

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

NOTE:- SAME PORT DENA HAI DATABASE AUR APPLICATION KO. Aur fs2 me adcfg

clone run karte samay port number 1 jyada dena hai

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 GORAK:
Running:
/oracle/oratest/db/systest/11.2.0/appsutil/scripts/GORAK_crp/addlnctl.sh start GORAK


(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]$


Upgrade EBS Database 11.2.0.2 to 12.1.0.2 Steps by Steps..

Install the Oracle 12c Software : -

Using Silent Mode -
======================

./runInstaller -ignoreSysPrereqs -ignorePrereq -force -showProgress -silent -responseFile /oracle_home/PATCH2015/ORACLE_12C/database/install.rsp

Responce file :-
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Hostname
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle_home/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle_home/app1/orahome
ORACLE_BASE=/oracle_home/app1
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=oinstall
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.BACKUPDBA_GROUP=oinstall
oracle.install.db.DGDBA_GROUP=oinstall
oracle.install.db.KMDBA_GROUP=oinstall
oracle.install.db.isRACOneInstall=false
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES


After Install Start CD  -  p21419221_121020_AIX64-5L_9of10.zip
============================

./runInstaller -ignoreSysPrereqs -ignorePrereq -force -showProgress -silent -responseFile Respons file location..

oracle.install.responseFileVersion=/oracle/install/rspfmt_demosinstall_response_schema_v12.1.0
ORACLE_HOSTNAME=youhostname
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/home/db/orahome12c
ORACLE_BASE=/oracle/database/base


***************** Do the prerequisits of OLD Database **********************

################################## Check The INVALID objects ##################################
########################################################################################################

SELECT DISTINCT object_name, object_type, owner  FROM dba_objects  WHERE  status='INVALID';

–If any invalid objects
@?/rdbms/admin/utlrp.sql

OR

select count(*) from dba_objects where status='INVALID';
exec utl_recomp.recomp_parallel('8');
select count(*) from dba_objects where status='INVALID';

################################## Staus of DB Components ################################################
########################################################################################################

select substr(COMP_ID, 1,10) compid,substr(COMP_NAME,1,24) compname, STATUS,VERSION from DBA_REGISTRY;

################################## DUPLICATE objects Detail ################################################
########################################################################################################

–Always check for DUPLICATE objects in SYS/SYSTEM

select OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from DBA_OBJECTS where OWNER='SYS') and
OWNER='SYSTEM' and OBJECT_NAME not in ('AQ$_SCHEDULES_PRIMARY','AQ$_SCHEDULES','DBMS_REPCAT_AUTH');

 or

column object_name format a30
select object_name, object_type
from dba_objects
where object_name||object_type in
   (select object_name||object_type 
    from dba_objects
    where owner = 'SYS')
and owner = 'SYSTEM';

–Fix DUPLICATE objects in SYS/SYSTEM BEFORE upgrade
–• Note:1030426.6 How to Clean Up Duplicate Objects Owned by SYS
How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema (Doc ID 1030426.6)
–and SYSTEM Schema


##################### VERY IMPORTANT TO RUN THIS SCRIPT!(preupgrd.sql) #################################
########################################################################################################

@$ORACLE_HOME/rdbms/admin/preupgrd.sql

   * Log into the system as the owner of the Oracle Database 12c Release 1 (12.1) Oracle Home directory.
    * Copy the Pre-Upgrade Information Tool script preupgrd.sql and utluppkg.sql from the Oracle Database 12c Release 1 (12.1) $ORACLE_HOME/rdbms/admin directory to  the $ORACLE_HOME/rdbms/admin directory of the source Oracle Home.

  Step 2:

     * Run the new Pre-Upgrade Information Tool. For example, if you copied preupgrd.sql to the /admin directory of the source Oracle Home:
SQL> @$ORACLE_HOME/rdbms/admin/preupgrd.sql

preupgrade.log, preupgrade_fixups.sql and postupgrade_fixups.sql files are created in $ORACLE_HOME/cfgtoollogs/$ORACLE_SID/preupgrade/, which is under the source database ORACLE_HOME to be upgraded.




Ensure that no files need media recovery and that no files are in backup mode.


SELECT * FROM v$recover_file;
SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';

########################################################################################################
################################## Distributed Transactions  Check ################################################
########################################################################################################

Resolve outstanding distributed transactions prior to the upgrade.
SQL> select * from dba_2pc_pending;


If this returns rows you should do the following:
SQL> SELECT local_tran_id
     FROM dba_2pc_pending;

If exist the disable

SQL> EXECUTE dbms_transaction.purge_lost_db_entry('');
SQL> COMMIT;

or

SQL >rollback force 'local_tran_id' ;
SQL> COMMIT;

########################################################################################################
################################## Standby Database  Check ################################################
########################################################################################################

To check if a standby database exists, issue the following query:

SELECT SUBSTR(value,INSTR(value,'=',INSTR(UPPER(value),'SERVICE'))+1)
FROM v$parameter
WHERE name LIKE 'log_archive_dest%' AND UPPER(value) LIKE 'SERVICE%';


If this query returns a row, then sync the standby database with the primary database.
1. Make sure all the logs are transported to the standby server after a final log switch
in the primary.
2. Start the recovery of the standby database with the NODELAY option.

######################################################################################    ##################
################################## Disbale All Jobs ################################################
########################################################################################################

Disable all batch and cron jobs.

About jobs initiated with Oracle the packages DBMS_JOB, DBMS_SCHEDULER can be used

select * from DBA_SCHEDULER_JOBS;
select * from  DBA_JOBS;

[edit]Enable / Disable a job

BEGIN 
  DBMS_SCHEDULER.ENABLE('myjob');
END;
/
BEGIN 
  DBMS_SCHEDULER.DISABLE('myjob');
END;
/

########################################################################################################
################################## Sys n System Default Tablespace ################################################
########################################################################################################

Ensure the users SYS and SYSTEM have 'SYSTEM' as their default tablespace.
You must have sufficient space in the tablespace or be set to extents unlimited.

SQL> SELECT username, default_tablespace FROM dba_users  WHERE username in ('SYS','SYSTEM');


If DEFAULT_TABLESPACE is anything other than SYSTEM tablespace, modify the default tablespace to SYSTEM by using the below command.

SQL> ALTER user SYS default tablespace SYSTEM;
SQL> ALTER user SYSTEM default tablespace SYSTEM;


########################################################################################################
################################## Aud$ Tablespace Check ################################################
########################################################################################################

Ensure that if the aud$ table exists that it is in the SYS schema and in the SYSTEM tablespace.

SQL> SELECT owner,tablespace_name
     FROM dba_tables
     WHERE table_name='AUD$';

########################################################################################################
############################# Check whether database has any externally authenticated SSL users ##################################
########################################################################################################

SQL> SELECT name FROM sys.user$
     WHERE ext_username IS NOT NULL
     AND password = 'GLOBAL';


########################################################################################################
################################## Purging of Recyclebin n Aud$ ################################################
########################################################################################################

Purge the Recyclebin as well as Truncate the Aud$ table after backup( Note:- &&& Use the Doc Final Audit Purging Script)...

purge DBA_RECYCLEBIN;
Truncate table aud$;


########################################################################################################
################################## Remove Enterprise Manager  Database Control repository ################################################
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

Enterprise Manager Database Control is superseded in 12c by Oracle Enterprise Manager Express .

     Therefore no repository is needed anymore .

     Remove  Enterprise Manager  Database Control  repository MANUALLY using the following command

     Note : You will get the emremove.sql script in the Oracle 12c home .

    Copy the emremove.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORACLE_HOME/rdbms/admin and then execute on the source database prior to upgrade.

$emctl stop dbcontrol

SQL> @?/rdbms/admin/emremove.sql

  If the EM repository is not removed up front ,it will be automatically removed during the catuppst.sql post-upgrade phase.

########################################################################################################
################################## Run olspreupgrade.sql ################################################
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

If  OLS(Lable Security) and/or DV ( Database Vault) was already in the  database prior to the upgrade then execute the following steps on Source database prior to upgrade
Note : You will get the olspreupgrade.sql script in the Oracle 12c home .
Copy the olspreupgrde.sql script from the 12c $ORACLE_HOME/rdbms/admin to the source $ORACLE_HOME/rdbms/admin and then execute on the source database prior to upgrade.
SQL> @?/rdbms/admin/olspreupgrade.sql

   - It prepares the move of AUD$ table from SYSTEM to SYS.

   - It processes the audit records to minimize downtime.

   - It moves records to an Interim temporary table.

See  Requirements for Upgrading Databases That Use Oracle Label Security and Oracle Database Vault for complete information


########################################################################################################
############# Drop Oracle 12c  Release 1 supplied users and roles ,if exist in the source database #########
Note :- Its not required in our case as we are upgrading from 12.1.0.1
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%

There are new Oracle users and roles in Oracle 12.1.  If there exist in the source database users or roles with the same names, then they must be dropped before upgrading the database.

Run the preupgrade tool to check for the existence of any users or roles in the source database that use the same names.

Note: If there is a pre-existing user in the database with same name as the 12.1 oracle-supplied users or roles, then move the data of that user to a different schema before dropping the pre-existing user.

Make sure to drop these pre-existing users and/or roles before doing the upgrade.  Else, the upgrade will terminate will with "ORA-01722: invalid number"  error.

########################################################################################################
################## Review and Remove any unnecessary hidden/underscore parameters ######################
########################################################################################################

Please review and remove any unnecessary hidden/underscore parameters prior to upgrading. It is strongly recommended that these be removed before upgrade

unless your application vendors and/or Oracle Support state differently.Changes will need to be made in the init.ora or spfile.
To view existing hidden parameters execute the following command while connected AS SYSDBA:


SQL> SELECT name, value from SYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\' order by name;


########################################################################################################
################## Check the XDB ACLs has start_date and end_date ACE attributes ######################
########################################################################################################

Before upgrading the database to 12c, please run the below query as SYS:

SQL> select aclid, start_date, end_date from xds_ace where start_date is not null; 

If the query returns any row, then please follow Note 1958876.1 Upgrade to 12.1 fails with ORA-01830 date format picture ends before converting entire input string ORA-06512: at "SYS.XS_OBJECT_MIGRATION"  to avoid failure in XDB's upgrade.

########################################################################################################
###### Check the Mitigation patch has been applied on the source Oracle home ######################
NOTE : This step is ONLY applicable if you have applied  Mitigation Patch  on the source database
########################################################################################################
%%%%%%%%%%%%%%% this is not needed %%%%%%%%%%%%%%%%%%%%%%%%%%%
Check the Mitigation patch has been applied on the source Oracle home ,it disables the Java development in the Database which cause error during upgrade

NOTE : This step is ONLY applicable if you have applied  Mitigation Patch  on the source database

Please "enable" the Java development in source database .
Connect to the database as a SYSDBA user
  SQL> exec dbms_java_dev.enable;

And then upgrade the database.

Please refer Note 1985725.1 Database Upgrade failed with Errors “ORA-02290: check constraint (SYS.JAVA_DEV_DISABLED) violated” & “ORA-04045: SYS.DBMS_ISCHED”

########################################################################################################
################################## Shutdown the DB,Listener n OEM ################################################
########################################################################################################

Stop Listener
shutdown immediate
stop oracle agent if running OEM
exit

################################## Unset Variables ################################################
########################################################################################################

-Undefine all the defined oracle parameters.
In my case i undefined the below parameters:
unset ORACLE_BASE
unset ORACLE_SID
unset ORA_NLS10
unset TNS_ADMIN
unset ORACLE_HOME
unset ORA_CRS_HOME
unset CRS_HOME

########################################################################################################
################################## Export New Oracle Home ################################################
########################################################################################################

— Make sure oracle_home is new home

echo $ORACLE_BASE
echo $ORACLE_SID
echo $ORA_NLS10
echo $TNS_ADMIN
echo $ORACLE_HOME
echo $ORA_CRS_HOME
echo $CRS_HOME


–START USING NEW ORACLE HOME
export ORACLE_HOME=/u01/app/oracle/11.2.0.4
in bash_profile set it to new oracle home. logout and log back in again

orapwd file=orapw$SID password=oracle entries=40

vi /etc/oratab
/u01/app/oracle/11.2.0.4

vi /u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile

sqlplus "sys/nopass as sysdba"
create spfile from pfile = ‘/u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile';

–Make sure there is enough archive log space


########################################################################################################
##################### Startup Upgrade n Cat Upgrade(Upgrading Database to 12cR1) ########################
########################################################################################################
instead $ORACLE_HOME user full path


$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus "/ as sysdba"
SQL> startup UPGRADE
SQL> exit

–THIS IS THE UPGRADE
–Takes about 30 minutes to run
show parameter cluster

$ORACLE_HOME/perl/bin/perl /oracle_home12c/db/orahome12c/rdbms/admin/catctl.pl -n  6 -l /oracle_home12c/db/orahome12c/rdbms/admin catupgrd.sql

$ORACLE_HOME/rdbms/admin/perl catctl.pl -n  6 -l $ORACLE_HOME/rdbms/admin catupgrd.sql
/oracle_home12c/db/orahome12c/rdbms/admin

–UPGRADE FOR THE MOST PART COMPLETE

————Wait for Script to Complete————

########################################################################################################
################################## Run the SQL's in Ordered ################################################
########################################################################################################

un the Post-Upgrade Status Tool $ORACLE_HOME/rdbms/admin/utlu121s.sql which provides a summary of the upgrade at the end of the spool log.
It displays the status of the database components in the upgraded database and the time required to complete each component upgrade.
Any errors that occur during the upgrade are listed with each component and must be addressed.


— This order
$ sqlplus "/as sysdba"
SQL> STARTUP
SQL> @utlu121s.sql

Important: The catuppst.sql script is run as part of the upgrade process unless the upgrade returns errors during the process. Check the log file for "BEGIN catuppst.sql" to verify that catuppst.sql ran during the upgrade process. If catuppst.sql has not run, then proceed to run catuppst.sql as shown in this step. Warning messages are also displayed when running catctl.pl indicating that catuppst.sql was not run during the upgrade.

Run catuppst.sql, located in the $ORACLE_HOME/rdbms/admin directory, to perform upgrade actions that do not require the database to be in UPGRADE mode.
SQL> @catuppst.sql

This script can be run concurrently with utlrp.sql.
Run utlrp.sql to recompile any remaining stored PL/SQL and Java code in another session.
SQL> @utlrp.sql

########################################################################################################
################### Identify Invalid Objects With the utluiobj Script #############################
########################################################################################################


Before the upgrade ,the list of invalid SYS/SYSTEM objects is written to registry$sys_inv_objs and non-SYS/SYSTEM objects was written to registry$nonsys_inv_objs by the Pre-Upgrade Information Tool

After the upgrade, run utluiobj.sql from $ORACLE_HOME/rdbms/admin/ to identify/compare any new invalid objects due to the upgrade.

@?/rdbms/admin/utluiobj.sql

########################################################################################################
################################## IN Case of PSU Patch ################################################
########################################################################################################


@?/rdbms/admin/catbundle.sql psu apply


########################################################################################################
################################## Startup All the Nodes ################################################
########################################################################################################

sqlplus "sys/nopass as sysdba"
create spfile from pfile = ‘/u01/app/oracle/admin/${ORACLE_SID}/pfile/upgrade_11.2.0.4.pfile';
startup




########################################################################################################
#### See the InValid Objects #########################################################################

select object_name from dba_objects where status != 'VALID';

## Gather the Stats #########################################################################################

EXEC DBMS_STATS.GATHER_SCHEMA_STATS (‘SYS’);
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

##### Upgrade the Catalog (Optional)
rman catalog username/password@rman_db
upgrade catalog;