Oracle Apps DBA
Oracle DBA & Apps DBA , Weblogic Admin , Fustio Administrator , GRC Admin
Wednesday, 14 September 2022
EBS 12.2.10 WebLogic Console is not working
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
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
================================
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..
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;