Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at support@funoracleapps.com

How to use OEM 12c graphs and activities after Adobe flash is unsupported

No comments

How to use OEM 12c graphs and activities after Adobe flash is unsupported


Adobe flash was unsupported starting 1 Jan 2021. So now using OEM12c graphs and activity bars would be a problem. We will need to upgrade to OEM13c or 19c.

But if you still want to continue using OEM12c then follow the below youtube link. It has all the required information. I use the same for my OEMS12c and works fine in firefox.


Please download the flash old version from the link below and follow the video.




If you like please follow and comment

No comments :

Post a Comment

Oracle EBS ADOP R12.2 Multi-Node Manual Patching

No comments

Oracle  EBS ADOP R12.2 Multi-Node Manual Patching 





In a multi-node setup on EBS 12.2, we can apply patches individually on each node as well.

If ssh is enabled from primary to secondary node then it is not necessary.

But I will show in this post how we can do it manually. This is an interview question and may be required sometimes.

Scenario 1: Shared Application Tier File System with SSH enabled

primary node run below

adop phase=<phase_name>

Scenario 2: Shared Application Tier File System without SSH enabled

primary node: 
adop phase=<phase_name> allnodes=no action=db

secondary node:
adop phase=<phase_name> allnodes=no action=nodb

Note: In a multi-node environment, the cleanup phase is to be executed on the primary node only as it is the DB phase. All other phases have to be executed on primary and all secondary nodes.

Scenario 3: Non-Shared Application Tier File System with SSH enabled

primary node run below

adop phase=<phase_name>

Scenario 4: Non-Shared Application Tier File System without SSH enabled

primary node: 
adop phase=<phase_name> allnodes=no action=db

secondary node:
adop phase=<phase_name> allnodes=no action=nodb






If you like please follow and comment

No comments :

Post a Comment

How to Implement HAPROXY in Oracle Apps R12.1

No comments

How to Implement HAPROXY in Oracle Apps R12.1


In an earlier post, I shared how HAPROXY is used as a reverse proxy for Oracle Apps. Now I am going to share how to implement the same.

I am using a separate server to install HAproxy and one EBS server.

The HAProxy server(OEL 7) I am using in my environment is known as oel7.lab (DNS name I have mapped as funerptest.lab)

[root@oel7 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.110 oel7.lab oel7
192.168.56.110 funerptest.lab funerptest


Steps:

1) Install haproxy
[root@oel7 ~]# yum install haproxy
2) Validate haproxy installation

[root@oel7 ~]# which haproxy
/usr/sbin/haproxy
[root@oel7 ~]# ls -l /etc/haproxy
total 4
-rw-r--r-- 1 root root 3142 Jun 28  2019 haproxy.cfg

3) Check the status of haproxy

[root@oel7 ~]# systemctl status haproxy
● haproxy.service - HAProxy Load Balancer
   Loaded: loaded (/usr/lib/systemd/system/haproxy.service; disabled; vendor preset: disabled)
   Active: inactive (dead)

4) Enable haproxy services after reboot and Enable the outbound connection of haproxy.

[root@oel7 ~]# systemctl enable haproxy
Created symlink from /etc/systemd/system/multi-user.target.wants/haproxy.service to /usr/lib/systemd/system/haproxy.service.

[root@oel7 haproxy]# setsebool -P haproxy_connect_any 1
setsebool:  SELinux is disabled.
systemctl start haproxy
5) Copy certificate and key bundle from your location to /etc/haproxy/bundle.pem

I have created a self-signed certificate. You get a CA-signed certificate as well.

Please refer to the below link on how to create a self-signed certificate.


Club the server certificate and key together in a bundle.

[root@oel7 certificates]# cat server.crt server.key >>/etc/haproxy/bundle.pem
[root@oel7 certificates]# ls -ltr /etc/haproxy/bundle.pem
-rw-r--r-- 1 root root 2879 Mar 28 18:45 /etc/haproxy/bundle.pem

6)Backup original HA config file.

[root@oel7 certificates]# cd /etc/haproxy/
[root@oel7 haproxy]# ls -ltr
total 8
-rw-r--r-- 1 root root 3142 Jun 28  2019 haproxy.cfg
-rw-r--r-- 1 root root 2879 Mar 28 18:45 bundle.pem
[root@oel7 haproxy]# cp haproxy.cfg haproxy.cfg_orig

7) Edit and update defaults settings options in haproxy

Add option forwardfor except 127.0.0.0/8 header ClientIP



8) Edit and update Front end detail in haproxy config. It should have the correct certificate bundle path.

frontend main *:5000 bind 0.0.0.0:443 ssl no-sslv3 crt /etc/haproxy/bundle.pem default_backend ebs

9) Edit and Add Backend details in haproxy config. The URL is for EBS login.

backend ebs balance roundrobin mode http server ebs funebs122.lab:8050



10) Validate haproxy configuration

[root@oel7 haproxy]# haproxy -f /etc/haproxy/haproxy.cfg -c
[WARNING] 086/185942 (2949) : Setting tune.ssl.default-dh-param to 1024 by default, if your workload permits it you should set it to at least 2048. Please set a value >= 1024 to make this warning disappear.
Configuration file is valid

11) Shutdown application services on EBS and update context values to point to SSL haproxy DNS.

s_webentryurlprotocol ==> https
s_webentryhost ==> funerptest
s_webentrydomain ==> lab
s_active_webport ==> 443
s_login_page ==> https://funerptest.lab:443/OA_HTML/AppsLogin
s_endUserMonitoringURL ==> https://funerptest.lab:443/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
s_external_url ==> https://funerptest.lab:443
s_chronosURL ==> https://funerptest.lab:443/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
s_enable_sslterminator ==> Remove # value


12) Update httpd.conf file to make sure that the Actual Client IP is read in the access log not the haproxy server IP. In real this would be done in the template file to avoid removal of entry after autoconfig(httpd_conf_1013.tmp)

cd $FND_TOP/admin/template/custom
cp ../httpd_conf_1013.tmp .


Edit httpd_conf_1013.tmp on EBS server and uncomment below

UseWebCacheIp ON

13) Run autoconfig on EBS application.

14) Add compatibility URL setting in IE.

15) Re-test the new EBS URL with HTTPS. The client will only see haproxy server securing your main

ebs application server.




16) Reconfigure workflow or any other required setup as per the environment.






If you like please follow and comment

No comments :

Post a Comment

Self-Signed Certificate and How to Create a Using OpenSSL

No comments

Self-Signed Certificate and How to Create a Using OpenSSL



SSL is for Secure Socket Layer is To secure connection an SSL Certificate is used which is commonly used on web servers.


SSL Certificates mainly serve two functions:

  • Authenticates the identity of the servers (so that users know that they are not sending their information to the wrong server).
  • Encrypts the data that is being transmitted.

Mostly we use CA Certification Authority(Go-Daddy, Verisign, etc..) as a trusted certificate. 
But we can also use a self-signed certificate. 

Self Signed Certificate

A self-signed certificate is a certificate that is signed by its own creator rather than a trusted authority. 
These are less trustworthy as an attacker can create a self-signed certificate and launch a middle attack.

Self-signed certificates in scenarios like:

1) Intranet.
2) Personal sites with few visitors.
3) Development or Testing phase of the application.


Don't use a self-signed certificate for the application that transmits critical data.


How to Create a Self-Signed Certificate Using OpenSSL

OpenSSL is a command-line tool that is used for TLS (Transport Layer Security) and SSL (Secure Socket Layer) protocols.

On Linux please run below commands:

1) openssl genrsa -out server.key 2048 ---> Generate Private key
2) openssl req -new -key server.key -out server.csr ---> Generate a Certificate Signing Request CSR.
3) openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt ---> Self sign the Certificate

[root@oel7 ~]# pwd
/root
[root@oel7 ~]# mkdir certificates
[root@oel7 ~]# pwd
/root
[root@oel7 ~]# cd certificates/
[root@oel7 certificates]# openssl genrsa -out server.key 2048
Generating RSA private key, 2048 bit long modulus
....+++
................+++
e is 65537 (0x10001)
[root@oel7 certificates]# ls -ltr
total 4
-rw-r--r-- 1 root root 1679 Mar 28 18:09 server.key
[root@oel7 certificates]# openssl req -new -key server.key -out server.csr
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [XX]:IN
State or Province Name (full name) []:Delhi        
Locality Name (eg, city) [Default City]:Delhi
Organization Name (eg, company) [Default Company Ltd]:Funoracleapps Ltd
Organizational Unit Name (eg, section) []:IT
Common Name (eg, your name or your server's hostname) []:*.lab
Email Address []:

Please enter the following 'extra' attributes
to be sent with your certificate request
A challenge password []:
An optional company name []:
[root@oel7 certificates]# ls -ltr
total 8
-rw-r--r-- 1 root root 1679 Mar 28 18:09 server.key
-rw-r--r-- 1 root root 1001 Mar 28 18:11 server.csr
[root@oel7 certificates]# openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt
Signature ok
subject=/C=IN/ST=Delhi/L=Delhi/O=Funoracleapps Ltd/OU=IT/CN=*.lab
Getting Private key
[root@oel7 certificates]# ls -ltr
total 12
-rw-r--r-- 1 root root 1679 Mar 28 18:09 server.key
-rw-r--r-- 1 root root 1001 Mar 28 18:11 server.csr
-rw-r--r-- 1 root root 1200 Mar 28 18:12 server.crt


I am giving *.domain_name as the CN name to use for multiple servers within the domain.





If you like please follow and comment

No comments :

Post a Comment

How to install GUI on Oracle Linux 7

No comments

How to install GUI on Oracle Linux 7





As a root user run the below commands

1)yum update  

2)yum groupinstall "Server with GUI"

3)Enable GUI on system startup

ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target

or

 systemctl set-default graphical.target

4) Reboot the Server and it will start in GUI 





If you like please follow and comment

No comments :

Post a Comment

How to disable HTTP port in Oracle Apps R12.1 when SSL is enabled

No comments

How to disable HTTP port in Oracle Apps R12.1 when SSL is enabled

If we have SSL enabled in our Oracle Apps/EBS then the web service/HTTP server would be listening on the HTTPS port. In this scenario, we can disable the HTTP services for security reasons. It is not mandatory but a good practice.

Steps:

1) Make a custom folder in FND top, if not already present.

 mkdir -p $FND_TOP/admin/template/custom

2) Navigate to custom folder.

cd $FND_TOP/admin/template/custom

3) Copy the http configuration template

cp ../httpd_conf_1013.tmp .

4) Update the custom file by commenting out the following line:
Listen %s_http_listen_parameter%

5) Run autoconfig and restart services to verify. Now the connection to HTTP port will not work.




If you like please follow and comment

No comments :

Post a Comment

Query to find full Access Details for Users in EBS/Oracle Apps

No comments

Query to find full Access Details for Users in EBS/Oracle Apps

This query can be helpful during audits and other user details-related requirements.

Query:

SELECT
    distinct fu.user_name "User_Name",
    fu.end_date "User_End_Date",
    frt.responsibility_name "Responsibility_Name",
    fat.application_name "Application_Name",
    furg.start_date "Responsibility_Start_Date",
    furg.end_date "Responsibility_End_Date",
    fu.last_update_date "Last Updated Date",
    (SELECT user_name
FROM fnd_user
WHERE user_id = fu.last_updated_by) "Last Update By"
FROM
    fnd_user_resp_groups_direct furg,
    applsys.fnd_user fu,
    applsys.fnd_responsibility_tl frt,
    applsys.fnd_responsibility fr,
    applsys.fnd_application_tl fat,
    applsys.fnd_application fa
WHERE
        furg.user_id = fu.user_id
    AND
        furg.responsibility_id = frt.responsibility_id
    AND
        fr.responsibility_id = frt.responsibility_id
    AND
        fa.application_id = fat.application_id
    AND
        fr.application_id = fat.application_id
        and fat.language='US'
    ORDER BY 1;





If you like please follow and comment

No comments :

Post a Comment

Create Logical Volume with 100 percent volume group space

No comments

Create Logical Volume with 100 percent volume group space


Command:

lvcreate -n <lv_name> -l 100%FREE <vg_name>





If you like please follow and comment

No comments :

Post a Comment

Orapki Quick Reference and Usage with wallets

No comments

Orapki Quick Reference and Usage with wallets




In this post, I am going to share about orapki which is a command-line tool. You can also use Oracle Wallet Manager(owm) as well, but that is not the scope of this post.

Oracle Wallets:
Wallet is a password-protected container used to store authentication and signing credentials, including private keys, certificates, and trusted certificates needed by SSL. The wallets it creates can be read by Oracle Database, Oracle Application Servers (OHS) used commonly in EBS when enabling SSL , and the Oracle Identity Management infrastructure.

In Oracle mostly there will be 3 types of wallets

1.Password protected - ewallet.p12
Required password for all operations like display, add,delete

2.Password protected with autologin- ewallet.p12 and  cwallet.sso

Required password for the only add, delete not for display. It can be read by oracle products without a password.

3.Auto_login_only - cwallet.sso

Doesn’t require a password for any operations.



Useful Commands Quick Reference.

Make sure the environment sourced is correct.

Creating and Viewing Oracle Wallets with orapki:

1.password-protected wallet creation:
orapki wallet create -wallet wallet_location

This command will prompt you to enter and re-enter a wallet password. It creates a wallet in the location specified for -wallet.

If you see a command as below 

orapki wallet create -wallet .

This means the wallets files would be created in your present working directly.


2.Password-Protected with auto-login enabled
This command creates a wallet with auto-login enabled, or it can also be used to enable auto-login on an existing wallet. If the wallet_location already contains a wallet, then auto-login will be enabled for it. To disable the auto-login feature, delete cwallet.sso.For wallets with the auto-login feature enabled, you are prompted for a password only for operations that modify the wallet, such as add


3. Autologin wallets:
To create an auto-login wallet (cwallet.sso) that does not need a password, use the following command:
orapki wallet create -wallet wallet_location -auto_login_only

This command creates an auto-login wallet (cwallet.sso) that does not need a password to open. You can also modify or delete the wallet without using a password. File system permissions provide the necessary security for such auto-login wallets.

Example:
orapki wallet create -wallet . -auto_login -pwd apps123

pwd : is a password for wallet

4.To view an Oracle wallet:

orapki wallet display -wallet wallet_location

or 

orapki wallet display -wallet .


5.Modifying the Password for a Wallet:

To change the wallet password, use the following command:

orapki wallet change_pwd -wallet wallet_location [-oldpwd password ] [-newpwd password]

6.How to add private key and certificates generated using openssl?

a.Create Wallet using openssl:

openssl pkcs12 -export -in jaydba_blogspot_com_cert.cer -inkey jaydba_blogspot_com.key -cerfile jaydba_blogspot_com_interm.cer -out ewallet.p12

b.Enable auto login:

orapki wallet create -wallet . -auto_login

7.How to Convert JKS to wallet:

a.create a password protected Oracle wallet with autologin:

orapki wallet create -wallet . -pwd password  -auto_login

b.Migrate the JKS keystore entries to the wallet:

orapki wallet jks_to_pkcs12 -wallet . -pwd password -keystore ./ewallet.jks -jkspwd password

8. Create a self signed certificate and export it

 orapki wallet add -wallet . -pwd apps123  -dn "CN=`hostname`, OU=Example Department, O=Example Company, L=NewYork, ST=US, C=US"  -keysize 2048 -self_signed -validity 365
  
  orapki wallet export -wallet . -dn "CN=`hostname`, OU=Example Department, O=Example Company, L=NewYork, ST=US, C=US" -cert /private/user/orapki_use/root/b64certificate.txt
  
9.  Export a certificate Request from an Oracle wallet:

orapki wallet export -wallet .-dn "CN=`hostname`, OU=Example Department, O=Example Company, L=NewYork, ST=US, C=US"  -request export_cert_server.txt -pwd apps123

10. Export a certificate from an Oracle wallet:

orapki wallet export -wallet . -dn "CN=`hostname`, OU=Example Department, O=Example Company, L=NewYork, ST=US, C=US"  -cert certificate_filename

11. View a certificate

orapki cert display -cert /private/user/orapki_use/server/cert.txt -complete

12. Add a trusted certificate to the wallet

orapki wallet add -wallet . -trusted_cert -cert /private/user/orapki_use/root/b64certificate.txt

13. Add a user certificate to the wallet

orapki wallet add -wallet . -user_cert -cert /private/user/orapki_use/server/cert.txt





If you like please follow and comment

No comments :

Post a Comment

How to Enable Password Authentication in AWS EC2 Instances

No comments

How to Enable Password Authentication in AWS EC2 Instances


By default, the authentication is done using ssh keys. Enabling password authentication is a security loophole.

Step 1:

Login to AWS instances using ssh key

ssh -i your-key.pem username@ip_address

Step 2:

Setup a password for the user using passwd command along with the username.
My username that I want to enable is "himanshu"
sudo passwd himanshu

Step 3:

Edit sshd_config file.
sudo vi /etc/ssh/sshd_config

Find the Line containing 'PasswordAuthentication' parameter and change its value from 'no' to 'yes'
PasswordAuthentication yes

If you want to set up 'root' login, find  'PermitRootLogin' parameter and change its value from 'prohibit-password' to 'yes'
PermitRootLogin yes

After these changes save the file and exit.

Step 4:

Restart the SSH service.

service sshd restart           

or systemctl  sshd  restart

Step 5:

Now log in using the password you set for the user. 

ssh himanshu@34.56.4.4



If you like please follow and comment

No comments :

Post a Comment

Query to find if we are connected to Run or Patch Database Edition on EBS12.2

No comments

Query to find if we are connected to Run or Patch Database Edition on EBS12.2

In Oracle Apps R12.2 if we want to determine that database connection is to run or patch edition. The below query can help you to get the answer

Query:

SQL> select ad_zd.get_edition_type from dual;
GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN







If you like please follow and comment

No comments :

Post a Comment

Upgrade the IAS oracle home to 10.1.3.5 in Oracle EBS R12.1

No comments

Upgrade the IAS oracle home to 10.1.3.5 in EBS R12.1


I was doing an IAS oracle home upgrade in EBS 12.1, so didn't find any easy document to refer to. I am sharing the steps that I created to make it easy for readers.

Checking Current Version:

IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server

Server built:   Jul  7 2008 14:58:00


Steps:

Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084

Download Environment Preparation Patch 8920270 for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0)

Apply the Oracle E-Business Suite Release 12 Template patch to support OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Apply 7359933. Follow the patch readme for any pre-requisite or post-requisite steps.-- Already present in my environment


Open VNC  and set the 10.1.3 home environment.

cd $ORA_CONFIG_HOME/10.1.3

. fuat_funebs122.env

Backup 10.1.3 home

cp -ipr 10.1.3 10.1.3_bkp

unzip p8626084_101350_LINUX.zip

 2 disk file will be  created 


Create a response file

cd  $IAS_ORACLE_HOME/OPatch

Run ./ocm/bin/emocmrsp

A response file would be created with the name ocm.rsp


Back up the file opmnctl at 1013_ORACLE_HOME/opmn/bin

Copy the file $INST_TOP/ora/10.1.3/opmn/bin/opmnctl to

10.1.3 ORACLE_HOME/opmn/bin


Change directory to <patch-top>/Disk1(for patch 8626084)

On Linux 64bit:

Use the following command to specify 32bit shell emulation, before running the installer as detailed below:


linux32 bash

Run the 10.1.3.5 Patch Set installer on VNC

./runInstaller -ignoreSysPrereqs







Click Next




Select the correct 10.1.3 Home






























Remember no services have to be taken down





























Click Yes





























EEnter the <oc4jadmin> user password for the OracleAS 10g 10.1.3 instance that is being patched. If you are upgrading from OracleAS 10g 10.1.3.0, the default password is 'secret'. Otherwise the default password is 'oafm', if it was not changed after Release 12 installation































There will be a brief pause in the installer when the application tier processes are stopped.
































If getting above error, then

  1. Back up the 10.1.3 Oracle Home/inventory/contentsXML/comps.xml file
  2. Change the INST_LOC variable in the
    10.1.3 Oracle Home/inventory/contentsXML/comps.xml file to the correct
    1013_ORACLE_HOME.
  3. Run the 10.1.3.5 Patch Set installer again after canceling this.
































Run above as root user.































Click OK and then
Edit file

 

$IAS_ORACLE_HOME/config/run_opatch_generic.sh

And add  -ocmrf /u01/oracle/fuat/apps/tech_st/10.1.3/OPatch/ocm.rsp in opatch command (This is same ocm file created in earlier steps)

 

Click retry

































Exit after installation is done.



Regenerate appsborg.zip and appsborg2.zip files

Run adadmin, and choose Generate product JAR files (with the no force option) to generate the appsborg.zip and appsborg2.zip files.

Validate the version now

 

$ $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server

Server built:   Jul 21 2009 11:12:22

 or

  1. Run the command 'opatch lsinventory -detail'
  2. Look for 'Oracle Application Server PatchSet' in the 'Product' column. 'Version' should show 10.1.3.5.0.


Restart application tier services

That's it.


Note:

If any further OracleAS 10g patches are applied, ensure that you repeat the Steps to regenerate appsborg.zip and appsborg2.zip and restart the application tier services.


You can Apply the October 2015 CPU or a later CPU to Oracle Fusion Middleware 10.1.3.5. if required.


If you like please follow and comment

No comments :

Post a Comment

Error while generating jar in Oracle Apps the adogjf() Unable to copy Registry.Dat

No comments

Error while generating jar in Oracle Apps the adogjf() Unable to copy Registry.Dat

While generating jar using adadmin getting below error.

Error:

Error copying the Forms Registry file to /u01/oracle/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat
ISSUE:

  Copying Registry.dat from the Forms Java directory to /u01/oracle/apps/apps_st/comn/java/classes ...

AutoPatch error:
Error copying the Forms Registry file to /u01/oracle/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat.


adogjf() Unable to copy Registry.Dat.

AutoPatch error:
Failed to generate the product JAR files

Cause:

Incorrect ORACLE_HOME sourced

Solution:


-bash-3.2$ echo $ORACLE_HOME
/u01/oracle/apps/tech_st/10.1.3
-bash-3.2$ cd $APPL_TOP

-bash-3.2$ . APPSEBS_funapps.env
-bash-3.2$ echo $ORACLE_HOME

/u01/oracle/apps/tech_st/10.1.2



If you like please follow and comment

No comments :

Post a Comment

OPatch detects your platform as 226 while this patch supports other platforms.

No comments

OPatch detects your platform as 226 while this patch supports other platforms.

While applying security patches under 'Oracle Fusion Middleware 10.1.3.5 getting the below error. This arises when applying a 32-bit version patch on 64 bits environment.

Error:

OPatch detects your platform as 226 while this patch 21815758 supports platforms:
   46 (Linux Intel)


Cause

OPatch detects your platform as 46 while this patch 21815758 supports platforms:
226 (Linux x86-64)


46 (Linux Intel)

226 (Linux x86-64)

Solution

export OPATCH_PLATFORM_ID=46
then opatch apply


Patch will complete successfully.



 



If you like please follow and comment

No comments :

Post a Comment

Cloning an EBS instance R12.2.10 from OEL 6.10 to OEL 7.9 using adcfgclone and RMAN

No comments

Cloning an EBS instance R12.2.10 from OEL 6.10 to OEL 7.9 using adcfgclone and RMAN




In this post, I am going to share how to clone the EBS R12.2.10 instance from OEL 6 to OEL 7. This can be used for the normal cloning process as well.


Source Machine: OEL 6.10
DB : 12.1.0.2
APPS: 12.2.10

Target Machine: OEL 7.9
DB : 12.1.0.2
APPS: 12.2.10

Shared Mount between both machines: /media/sf_Downloads

Pre-requisites:
Please install a target machine with Oracle Linux 7.9 and install all related RPMs from the below post.



Target Machine Preparation

1) Edit Security Limits.conf and enter below values

/etc/security/limits.conf:
---------------
 * hard nofile 65536
 * soft nofile 4096
 * hard nproc 16384
 * soft nproc 2047
 * hard stack 16384
 * soft stack 10240

2) Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

Validate using below

# sestatus

3) If you have the Linux firewall enabled, you will need to disable or configure it.

To disable it, do the following.

# systemctl stop firewalld
# systemctl disable firewalld

4) Validate user oracle and applmgr users

[root@funebs122 yum.repos.d]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[root@funebs122 yum.repos.d]# id applmgr
uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall)
[root@funebs122 yum.repos.d]# usermod -aG dba applmgr
[root@funebs122 yum.repos.d]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password contains the user name in some form
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@funebs122 yum.repos.d]# passwd applmgr
Changing password for user applmgr.
New password: 
BAD PASSWORD: The password fails the dictionary check - it is based on a dictionary word
Retype new password: 
passwd: all authentication tokens updated successfully.


5) Create directory structure for EBS

[root@funebs122 yum.repos.d]# mkdir /oraapps122
[root@funebs122 yum.repos.d]# chown oracle:dba /oraapps122
[root@funebs122 yum.repos.d]# chmod 777 /oraapps122

6) Set your inventory location under /etc/oraInst.loc as  

vi /etc/oraInst.loc

inventory_loc=/oraapps122/oracle/oraInventory 
inst_group=dba 

From oracle user create directory

mkdir -p /oraapps122/oracle/oraInventory
chmod 777 /oraapps122/oracle/oraInventory

7) Validate Swap space


[root@funebs122 yum.repos.d]# cat /proc/meminfo |grep -i swap
SwapCached:            0 kB
SwapTotal:      16773116 kB
SwapFree:       16773116 kB



Source Machine 


1) Make sure the database is in archive mode.

SYS@GOLD >archive log list;
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /oracleapps/DATABASE/GOLD/data
Oldest online log sequence     76
Next log sequence to archive   77
Current log sequence	       77
2) Download patch 17537119 from My Oracle Support, unzip it under /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc and run /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc/checkDBpatch.sh to avoid ADOP related issues. 
if etcc directory doesn't exists, please create.

3) Run ad-pre clone on database and application.
DB:
perl adpreclone.pl dbTier

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

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password: 
Verifying if Database Patch checker (ETCC) exists in /oracleapps/DATABASE/GOLD/12.1.0/appsutil/etcc 


Running:
perl /oracleapps/DATABASE/GOLD/12.1.0/appsutil/bin/adclone.pl java=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/jre mode=stage stage=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/oracleapps/DATABASE/GOLD/12.1.0/appsutil/GOLD_ebs122.xml showProgress 


Beginning database tier Stage - Wed Mar  3 08:47:41 2021

/oracleapps/DATABASE/GOLD/12.1.0/appsutil/jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracleapps/DATABASE/GOLD/12.1.0/oui -classpath /oracleapps/DATABASE/GOLD/12.1.0/lib/xmlparserv2.jar:/oracleapps/DATABASE/GOLD/12.1.0/jdbc/lib/ojdbc6.jar:/oracleapps/DATABASE/GOLD/12.1.0/appsutil/java:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/OraInstaller.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/ewt3.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/share.jar:/oracleapps/DATABASE/GOLD/12.1.0/oui/jlib/srvm.jar:/oracleapps/DATABASE/GOLD/12.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /oracleapps/DATABASE/GOLD/12.1.0/appsutil/GOLD_ebs122.xml -stage /oracleapps/DATABASE/GOLD/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password : 
Log file located at /oracleapps/DATABASE/GOLD/12.1.0/appsutil/log/GOLD_ebs122/StageDBTier_03030847.log

  -     50% completed       

Completed Stage...
Wed Mar  3 08:48:09 2021

APPS:



perl adpreclone.pl appsTier

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

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.25

Enter the APPS User Password: 
Enter the Weblogic AdminServer password : 

 Checking the status of the Oracle WebLogic Administration Server....

 Running perl /oracleapps/APPLICATION/GOLD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml -servername=AdminServer -promptmsg=hide  

The Oracle WebLogic Administration Server is up.

wlsDomainName: EBS_domain_GOLD
WLS Domain Name is VALID.

Running:
perl /oracleapps/APPLICATION/GOLD/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/clone component=appsTier method= appctx=/oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml showProgress 



 Setting the wls environment 

Beginning application tier Stage - Wed Mar  3 09:13:15 2021

/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/java/classes:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/oui/jlib/share.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/oracleapps/APPLICATION/GOLD/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/appl/admin/GOLD_ebs122.xml -stage /oracleapps/APPLICATION/GOLD/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg 

Log file located at /oracleapps/APPLICATION/GOLD/fs1/inst/apps/GOLD_ebs122/admin/log/clone/StageAppsTier_03030913.log

  -     20% completed       

Completed Stage...
Wed Mar  3 09:30:24 2021

4) Take a rman backup.

rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 3 09:39:23 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: GOLD (DBID=3218346444)

RMAN> list backup of database;

using target database control file instead of recovery catalog
specification does not match any backup in the repository

RMAN> show all;

RMAN configuration parameters for database with db_unique_name GOLD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO 30000 M;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracleapps/DATABASE/GOLD/12.1.0/dbs/snapcf_GOLD.f'; # default


Start the RMAN backup of the database. I am taking backup at a shared location so that I don't have to manually copy backup pieces to the target server. Else, please copy backup pieces to the target machine.

RMAN> RUN
{
  ALLOCATE CHANNEL ch1 TYPE DISK;
  BACKUP
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_D_%T_%u_s%s_p%p'
  DATABASE
  CURRENT CONTROLFILE
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_C_%T_%u'
  SPFILE
  FORMAT '/media/sf_Downloads/RMAN_BACKUP/%d_S_%T_%u'
  PLUS ARCHIVELOG
  FORMAT '/media/sf_Downloads/RMANBACKUP/%d_A_%T_%u_s%s_p%p';
  RELEASE CHANNEL ch1;
 }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 
5) Take tar backup of the Database Oracle Home and EBSapps folder from the application run file system.

tar -zcvf /media/sf_Downloads/12.1.0.tar.gz 12.1.0

My run file system is fs1 so taking tar from fs1.

tar -zcvf /media/sf_Downloads/EBSapps.tar.gz EBSapps


Go to Target Machine which is OEL 7.9.

1) We need to configure our database.

a) Make a directory structure for database home and data files.

[oracle@funebs122 oraapps122]$ mkdir -p /oraapps122/DATABASE/FUAT /oraapps122/DATABASE/FUAT/data
[oracle@funebs122 oraapps122]$ mkdir -p /oraapps122/DATABASE/FUAT/arch
FUAT-- Duplicate DB name and funebs122 my hostname.

b) Copy the Oracle Home tar from the shared location which was taken from the source instance to  /oraapps122/DATABASE/FUAT.

[oracle@funebs122 sf_Downloads]$ cp 12.1.0.tar.gz /oraapps122/DATABASE/FUAT/
c) Untar the file.

[oracle@funebs122 /oraapps122/DATABASE/FUAT]$ tar -zxvf 12.1.0.tar.gz 

d) Set below value

export ORACLE_HOME=/oraapps122/DATABASE/FUAT/12.1.0
export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib
export ORACLE_SID=FUAT


e)Run adcfgclone for configuring oracle Home.

[oracle@funebs122 bin]$ perl adcfgclone.pl dbTechStack

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

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.65

Enter the APPS password : 

Running: Context clone...

Log file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/CloneContext_0303160655.log

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

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

Target System Base Directory : /oraapps122/DATABASE

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

Target System Database SID : FUAT

Role separation is supported y/n [n] ? : n

Target System utl_file_dir Directory List : /tmp

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

Target System DATA_TOP Directory 1 [/oraapps122/DATABASE/data] : /oraapps122/DATABASE/FUAT/data

Target System RDBMS ORACLE_HOME Directory [/oraapps122/DATABASE/12.1.0] : /oraapps122/DATABASE/FUAT/12.1.0

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

Target System Display [funebs122: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] : 30

Checking the port pool 30
done: Port Pool 30 is free
Report file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/temp/portpool.lst
The new database context file has been created :
  /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml
Check Clone Context logfile /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/CloneContext_0303160655.log for details.

Running Rapid Clone with command:

Running:
perl /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/adclone.pl java=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml showProgress contextValidated=true


Beginning rdbms home Apply - Wed Mar  3 16:08:22 2021

/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oraapps122/DATABASE/FUAT/12.1.0/oui -classpath /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/java:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/share.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml -stage /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone   -showProgress
APPS Password : Log file located at /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/ApplyDBTechStack_03031608.log
  /      0% completed       

Completed Apply...
Wed Mar  3 16:11:24 2021

Starting database listener for FUAT:
Running:
/oraapps122/DATABASE/FUAT/12.1.0/appsutil/scripts/FUAT_funebs122/addlnctl.sh start FUAT
Logfile: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/addlnctl.txt

You are running addlnctl.sh version 120.4


Starting listener process FUAT ...


LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-MAR-2021 16:11:24

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /oraapps122/DATABASE/FUAT/12.1.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oraapps122/DATABASE/FUAT/12.1.0/network/admin/FUAT_funebs122/listener.ora
Log messages written to /oraapps122/DATABASE/FUAT/12.1.0/admin/FUAT_funebs122/diag/tnslsnr/funebs122/fuat/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=funebs122.lab)(PORT=1551)))
STATUS of the LISTENER
------------------------
Alias                     FUAT
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                03-MAR-2021 16:11:25
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oraapps122/DATABASE/FUAT/12.1.0/network/admin/FUAT_funebs122/listener.ora
Listener Log File         /oraapps122/DATABASE/FUAT/12.1.0/admin/FUAT_funebs122/diag/tnslsnr/funebs122/fuat/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=funebs122.lab)(PORT=1551)))
Services Summary...
Service "FUAT" has 1 instance(s).
  Instance "FUAT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/addlnctl.txt for more information ...  


Running ETCC to check status of DB technology patches... 


 +===============================================================+ 
 |    Copyright (c) 2005, 2020 Oracle and/or its affiliates.     | 
 |                     All rights reserved.                      | 
 |             Oracle E-Business Suite Release 12.2              | 
 |          Database EBS Technology Codelevel Checker            | 
 +===============================================================+ 

Validating context file: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml

Using context file from command line argument:
/oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml


Starting Database EBS Technology Codelevel Checker, Version 120.82 
Wed Mar  3 16:11:26 IST 2021
Log file for this session : /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/log/checkDBpatch_10124.log

Identifying database release. 
Database release set to 12.1.0.2.

Connecting to database. 

+-----------------------------------------------------------------------------+
[WARNING] DB-ETCC: Could not connect to database, so unable to check:
  - Whether database is in READ-WRITE mode. 
  - Existence of table needed to store DB-ETCC results. 
  - Enablement of database In-Memory option. 
    If this feature is enabled, additional fixes need to be verified.

Resolve the database connectivity issue, and then rerun DB-ETCC.
+-----------------------------------------------------------------------------+

Bugfix file /oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.57
This file will be used for identifying missing bugfixes. 

Mapping file /oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.32
This file will be used for mapping bugfixes to patches.


[WARNING] DB-ETCC: Bugfix XML file (/oraapps122/DATABASE/FUAT/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.
 Check if a newer version is available in patch 17537119.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

All the required one-off bugfixes are present in Database ORACLE_HOME.

[WARNING] Database not available. DB-ETCC results cannot be stored.

Finished checking fixes for Oracle Database: Wed Mar  3 16:11:43 IST 2021

Log file for this session: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/clone/bin/log/checkDBpatch_10124.log

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

f) Create the database using duplicate commands and with backup pieces.

Source environment file and Start database in nomount

Edit /oraapps122/DATABASE/FUAT/12.1.0/dbs/initFUAT.ora file and add below db and log convert parameter.

DB_FILE_NAME_CONVERT=(/oracleapps/DATABASE/GOLD/data/,/oraapps122/DATABASE/FUAT/data/)
LOG_FILE_NAME_CONVERT=(/oracleapps/DATABASE/GOLD/data/,/oraapps122/DATABASE/FUAT/data/)
[oracle@funebs122 12.1.0]$ . FUAT_funebs122.env
[oracle@funebs122 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 3 16:24:45 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@FUAT >startup nomount pfile='/oraapps122/DATABASE/FUAT/12.1.0/dbs/initFUAT.ora'
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size		    2926472 bytes
Variable Size		  452987000 bytes
Database Buffers	 1677721600 bytes
Redo Buffers		   13848576 bytes

Start Duplicate

[oracle@funebs122 dbs]$ rman AUXILIARY /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Mar 3 16:31:34 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: FUAT (not mounted)

RMAN> DUPLICATE DATABASE TO FUAT
        BACKUP LOCATION '/media/sf_Downloads/RMAN_BACKUP/'
  NOFILENAMECHECK;2> 3> 


g)  Connect to sqlplus using apps/source_Apps_password and run fnd conc cleanup.

[oracle@funebs122 ~]$ sqlplus apps/apps

SQL*Plus: Release 12.1.0.2.0 Production on Wed Mar 3 18:23:36 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Wed Mar 03 2021 18:23:14 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

APPS@FUAT >select node_name from fnd_nodes;

NODE_NAME
--------------------------------------------------------------------------------
AUTHENTICATION
EBS122

APPS@FUAT >EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

APPS@FUAT >commit;

Commit complete.

APPS@FUAT >select node_name from fnd_nodes;

no rows selected



h) Run Autoconfig on DB Tier

[oracle@funebs122 ~]$ cd $ORACLE_HOME/appsutil/scripts
[oracle@funebs122 scripts]$ ls
FUAT_funebs122
[oracle@funebs122 scripts]$ cd FUAT_funebs122/
[oracle@funebs122 FUAT_funebs122]$ ls
adautocfg.sh  adchknls.pl  addbctl.sh  addlnctl.sh  adexecsql.pl  adpreclone.pl  adstopdb.sql  adstrtdb.sql
[oracle@funebs122 FUAT_funebs122]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oraapps122/DATABASE/FUAT/12.1.0/appsutil/log/FUAT_funebs122/03031825/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
	Using ORACLE_HOME location : /oraapps122/DATABASE/FUAT/12.1.0

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AL32UTF8

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
	Classpath                   : :/oraapps122/DATABASE/FUAT/12.1.0/jdbc/lib/ojdbc6.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/java/xmlparserv2.jar:/oraapps122/DATABASE/FUAT/12.1.0/appsutil/java:/oraapps122/DATABASE/FUAT/12.1.0/jlib/netcfg.jar:/oraapps122/DATABASE/FUAT/12.1.0/jlib/ldapjclnt12.jar:/oraapps122/DATABASE/FUAT/12.1.0/jlib/orai18n.jar

	Using Context file          : /oraapps122/DATABASE/FUAT/12.1.0/appsutil/FUAT_funebs122.xml

Context Value Management will now update the Context file

	Updating Context file...COMPLETED

	Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.


2) Configure Application Tier

a) make the Below directory structure from applmgr user.

[applmgr@funebs122 oraapps122]$ mkdir -p /oraapps122/APPS/FUAT
[applmgr@funebs122 oraapps122]$ cd /oraapps122/APPS/FUAT
[applmgr@funebs122 FUAT]$ ls
[applmgr@funebs122 FUAT]$ mkdir fs1 fs2 fs_ne
[applmgr@funebs122 FUAT]$ ls -ltr
total 0
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs_ne
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs2
drwxr-xr-x. 2 applmgr oinstall 6 Mar  3 16:36 fs1

b) Copy the tar taken in source to fs1 as it was taken from run file system which at source and untar it.

[applmgr@funebs122 FUAT]$ cd fs1
[applmgr@funebs122 fs1]$ ls -ltr
total 0
[applmgr@funebs122 fs1]$ cp /media/sf_Downloads/EBSapps.tar.gz .
tar -zxvf EBSapps.tar.gz

c) Run adcfgclone for application configuration now.

[applmgr@funebs122 clone]$ cd /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone
[applmgr@funebs122 clone]$ ls
appl  appsts  bin  context  FMW  html  jlib  jre  oui  prereq
[applmgr@funebs122 clone]$ cd bin
[applmgr@funebs122 bin]$ ls
adaddnode.pl  adcfgclone.pl  adchkutl.sh  adclonectx.pl  adclone.pl
[applmgr@funebs122 bin]$ perl adcfgclone.pl appsTier dualfs

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

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.65

Enter the APPS password : 

Enter the Weblogic AdminServer password : 

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


Running: Context clone...

Log file located at /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContext_0303182714.log

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

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

Target System Database SID : FUAT

Target System Database Server Node [funebs122] : 

Target System Database Domain Name [lab] : 

Target System Base Directory : /oraapps122/APPS/FUAT

Target System Base Directory set to /oraapps122/APPS/FUAT

Target System Current File System Base set to /oraapps122/APPS/FUAT/fs1

Target System Other File System Base set to /oraapps122/APPS/FUAT/fs2

Target System Fusion Middleware Home set to /oraapps122/APPS/FUAT/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /oraapps122/APPS/FUAT/fs2/FMW_Home

Target System Web Oracle Home set to /oraapps122/APPS/FUAT/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /oraapps122/APPS/FUAT/fs2/FMW_Home/webtier

Target System Appl TOP set to /oraapps122/APPS/FUAT/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /oraapps122/APPS/FUAT/fs2/EBSapps/appl

Target System COMMON TOP set to /oraapps122/APPS/FUAT/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /oraapps122/APPS/FUAT/fs2/EBSapps/comn

Target System Instance Home Directory [/oraapps122/APPS/FUAT] : 

Target System Current File System Instance Top set to /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122

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

Target System Display [funebs122:0.0] : 

Target System Root Service [enabled] : 

Target System Web Entry Point Services [enabled] : 

Target System Web Application Services [enabled] : 

Target System Batch Processing Services [enabled] : 

Target System Other Services [disabled] : 

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

Target System Port Pool [0-99] : 30

Checking the port pool 30
done: Port Pool 30 is free
Report file located at /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122/admin/out/portpool.lst

Target System proxy port [80] : 

UTL_FILE_DIR on database tier consists of the following directories.

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

Creating Patch file system context file.....

Log file located at /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0303182812.log

Target System Other File System Instance Top set to /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122

Target System Port Pool [0-99] : 40

Checking the port pool 40
done: Port Pool 40 is free
Report file located at /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/admin/out/portpool.lst
The new APPL_TOP context file has been created :
  /oraapps122/APPS/FUAT/fs2/inst/apps/FUAT_funebs122/appl/admin/FUAT_funebs122.xml
Check Clone Context logfile /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0303182812.log for details.

FMW Pre-requisite check log file location : /oraapps122/APPS/FUAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...

Configuring: Run file system....
LogFile located at /oraapps122/APPS/FUAT/fs1/inst/apps/FUAT_funebs122/admin/log/clone/run/RCloneApplyAppstier_03031828.log



3) Open the EBS URL and validate.



If you like please follow and comment

No comments :

Post a Comment