April 5, 2022

How to backup EBS R12.2 application using shell script

 

How  to backup EBS R12.2 application using shell script


Create a shell script with any name for example /home/applmgr/apps_backup.sh

#!/bin/bash

date=`date +%d%m%Y`

. /app/prod/apps/fs2/EBSapps/appl/APPSPROD_prodappdb.env

echo ""

/app/prod/apps/fs2/inst/apps/PROD_prodappdb/admin/scripts/adpreclone.pl appsTier pwd=<apps_passwd> <<EOF

weblogic123

EOF

echo "---------Application Preclone end `date` --------------"

echo "" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log

echo "--------------Tar backup end `date`---------------" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log

cp /backup/PROD_APPS_Backup/apps_prod_$(date +%d-%m-%Y).tar.gz /remote_HDD/PROD_Backup_DND/Apps_backup/

echo "--------------backup copied to External HDD completed at `date`---------------" >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log

 

Once done , schedule it in crontab as per your requirement

0 0 * * * /home/applmgr/apps_backup.sh

March 16, 2022

Error "libdb.so.2: cannot open shared object file: No such file or directory "

libdb.so.2: cannot open shared object file: No such file or directory

 Applicable to :-

Oracle E-Business Suite Technology Stack - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Linux x86
Linux x86-64


So , while doing a fresh clone in a new hardware, we faced the error message “libdb.so.2: cannot open shared object file: No such file or directory”  during startup of apache service in EBS. This error is also common in any other oracle application(such as discoverer, demantra) where oracle http service is being used.

 

Reason: This error is observed on linux server 5 and above where Soft link libdb.so.2 is missing.

SOLUTION:-

It might happen that file libgdbm.so.2.0.0 may not exist in server, for that you need to copy it from another server where this file exists or you can download it from below link

libgdbm.so.2.0.0

Now, execute the following steps:

1. Shut down all services on the Application tier

2. Copy libgdbm.so.2.0.0 inside /usr/lib

3. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

4. Start application tier services again and this time will start without error.


March 9, 2022

Error while opening EBS url after cloning - " You are trying to access a page that is no longer active."

 

Recently for one of my customer, I was doing a new R12.1.3 clone into a new server which was outside of their production domain. So after the cloning when tried to open the EBS url from browser it showed error saying  “You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.”


So after doing a bit of google, I found a document from oracle support suggesting a possibility that if the server hostname container underscore (_) such behaviour is observed. But in our case hostname contained no underscore so this was not the case.

So I did the following to resolve the issue

Login to database as apps user

sqlplus apps/xxxx

SQL> select session_cookie_domain from icx_parameters;

 

SESSION_COOKIE_DOMAIN

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

.olddomain.co.in

 

The session_cookie_domain column is still looking for olddomain.co.in

 

So I nulled the value

 

SQL> update icx_parameters set session_cookie_domain=null;

1 row updated.

 

SQL> commit;

Commit complete.

 

SQL> select session_cookie_domain from icx_parameters;

SESSION_COOKIE_DOMAIN

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

 

 

 

After this I bounced the apache services.

 

[applmgr@ebsr122 ~]$ cd $ADMIN_SCRIPTS_HOME

 

[applmgr@ebsr122 scripts]$ adapcctl.sh stop

 

[applmgr@ebsr122 scripts]$ adapcctl.sh start

 

Then I checked the url again , and it logged in without any error.


March 2, 2022

How to Download EBS R12.2.0 software

 

Many people find it problematic to download EBS software, So I will show here how to download it easily.

Login to http://edelivery.oracle.com/ using your credentials.

To download oracle ebs , write down with “Oracle Advanced Supply Chain Planning” . Don’t write Oracle E business suite as this will only download the EBS software not all the components of it. Select any version to download, for example I choose 12.2.11. This will download the base 12.2 version along with 12.2.11 files.





On top right corner click on view items and continue,



On next screen, deselect the components you don't want to download, for example I dont want to donwload EBS Languages & mobile application archive, so I did not select it.


On next screen, if you don’t want to install VISION instance, you can deselect the files written with “VISION” .





Once selection is done, click on Download and files will start downloading.




February 6, 2022

How To Apply weblogic PSU Patch

 

How To Apply weblogic PSU Patch

Env Details:

OS= Windows Server 2012 R12 64bit

#Middleware Home

MW_HOME= D:\Oracle\Middleware

Step 1.  

In this example we will be installing WLS PSU 10.3.6.0.211019(p33172858_1036_Generic.zip)

So download the patch from support.oracle.com

P.S. Following are the generic steps for installing a WLS Psu patch. But its always recommended to go through the readme file first and act accordingly.

Step 2.

Shutdown weblogic services in following order.

1.       Stop opmn process

2.       Stop WLS_REPORTS services

3.       Stop WLS_FORMS services

4.       Stop Weblogic Admin server

 

Step 3.

Remove any previously applied WebLogic Server Patch Set Update and associated overlay patches

In this example, we didn’t have any previously applied wls PSU installed.

To get information about list of patches installed run following command.

Cd D:\Oracle\Middleware\utils\bsu

D:\Oracle\Middleware\utils\bsu>bsu.cmd -report

Patch Report

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

  Report Info

    Report Options

      bea_home.................. ### OPTION NOT SET

      product_mask.............. ### OPTION NOT SET

      release_mask.............. ### OPTION NOT SET

      profile_mask.............. ### OPTION NOT SET

      patch_id_mask............. ### OPTION NOT SET

    Report Messages

  BEA Home.................. D:\Oracle\Middleware

 

  Product Description

  Product Name.............. WebLogic Server

  Product Version........... 10.3.6.0

  Installed Components...... Core Application Server, Administration Console, Co

nfiguration Wizard and Upgrade Framework, Web 2.0 HTTP Pub-Sub Server, WebLogic

SCA, WebLogic JDBC Drivers, Third Party JDBC Drivers, WebLogic Server Clients, W

ebLogic Web Server Plugins, UDDI and Xquery Support, Evaluation Database, Worksh

op Code Completion Support

  Product Install Directory. D:\Oracle\Middleware\wlserver_10.3

  Java Home................. null

  Jave Vendor............... Sun

  Java Version.............. 1.6.0_29

  Patch Directory........... D:\Oracle\Middleware\patch_wls1036

 

  Product Description

  Product Name.............. Oracle Coherence

  Product Version........... 3.7.1.1

  Installed Components...... Coherence Product Files

  Product Install Directory. D:\Oracle\Middleware\coherence_3.7

  Java Home................. null

  Jave Vendor............... null

  Java Version.............. null

  Patch Directory........... D:\Oracle\Middleware\patch_ocp371

 

We faced error while generating above report. Error was like "java.lang.OutOfMemoryError: Java heap space" 

 

Solution :

This solution is for Windows 64bit OS.

Go to $MW_HOME/utils/bsu

Prepare to edit the bsu.sh (for UNIX) or bsu.cmd (for Windows)

Find the MEM_ARGS setting, e.g., the default as MEM_ARGS="-Xms256m -Xmx512m"

Increase these values to a higher setting, e.g., MEM_ARGS="-Xms4096m –Xmx4096m"

 

 

Step 4.

Apply WLS BSU (Smart Update) fix for quicker patch application. This step can be skipped if the fix is already applied.

Apply patch Patch 12426828 SMARTUPDATE 3.3 INSTALLER PLACEHOLDER 

Check readme file for patch apply instructions.

To check bsu version

%MW_HOME%\utils\bsu\bsu.cmd -version (for Windows)
$MW_HOME/utils/bsu/bsu.sh -version (for Unix/Linux)

 

Step 5.

Create Cache_dir

Create Directory cache_dir inside $MW_HOME/utils/bsu

Copy The Downloaded Patch To $MW_HOME/utils/bsu/cache_dir 

And unzip it inside cache_Dir directory.

 

 

Step 6. 

Set The Environment Using setWLSEnv.sh 

cd D:\Oracle\Middleware\wlserver_10.3\server\bin

setWLSEnv.cmd

 

Step 7. 

Run The Patch Install Command Using bsu.cmd

Syntax:- - Execute bsu.cmd -install -patch_download_dir={MW_HOME}/utils/bsu/cache_dir -patchlist={PATCH_ID} -prod_dir={MW_HOME}/{WL_HOME}

bsu.cmd -install -patch_download_dir=D:\Oracle\Middleware\utils\bsu\cache_dir -patchlist=21Y4 -prod_dir=D:\Oracle\Middleware\wlserver_10.3 -install -log=patch_apply.log -log_priority=trace

 

This entire process takes sometime to complete.

 

Step 8.

Verifying the Patch

cd $MW_HOME/utils/bsu

 bsu.cmd -report -bea_home=D:\Oracle\Middleware -output_file=bsureprot.log

 

Also, this can be verified from weblogic console.

Domain Structure -> Servers->Click on Adminserver ->Monitoring ->General

This page will show you weblogic version.

 

Step 9.

Start all weblogic services

1.       Start  Weblogic Admin server

2.       Start WLS_FORMS services

3.       Start WLS_REPORTS services

4.       Start OPMN services


If you need to remove patchset:-

bsu.cmd -remove -patchlist=21Y4 -prod_dir=D:\Oracle\Middleware\wlserver_10.3

 

 

 

 

 

 

January 29, 2022

The user does not have the privileges to run commands as user "root" using the Privilege Delegation tool "/usr/bin/sudo"

While installing agent in target host for oracle enterprise manager 13c, following error is observed 

"The user  does not have the privileges to run commands as user "root" using the Privilege Delegation tool "/usr/bin/sudo" 





Solution:-

1. Ignore this warning and proceed with installation. Execute <agent Oracle Home>/root.sh manually after logging in as root.

OR

Ensure the sudo privileges for <AGENT_INSTALL_USER> to execute the command set in sudoers file.

a. Enable Sudo user setup on target host without password.

    As root user login to the target server:

# visudo
Locate the following line in the file mentioned
root    ALL=(ALL)       ALL


Add the following line below the line mentioned .Here r12devdb is the user that would be used to connect the server and continue with the installation.


r12devdb  ALL=(ALL)       ALL

 

2. Continue installation in console.






January 22, 2022

How to start/stop/ check status of OMS and Agent in OEM 13c

 

How to start/stop/ check status of OMS and Agent in OEM 13c

 

To start  Oracle Management Server(OMS), login to oem server.

Navigate to oracle middleware home

export MW_HOME= /data2/app/oracle/middleware

cd $MW_HOME/bin

[oem@ccuine25 bin]$ ./emctl start oms

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Starting Oracle Management Server...

WebTier Successfully Started

Oracle Management Server Successfully Started

Oracle Management Server is Up

JVMD Engine is Up

 

To Check status of OMS

cd $MW_HOME/bin

[oem@ccuine25 bin]$ ./emctl status oms -details

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Enter Enterprise Manager Root (SYSMAN) Password :

Console Server Host        : ccuine25.xyz.co.in

HTTP Console Port          : 7788

HTTPS Console Port         : 7803

HTTP Upload Port           : 4889

HTTPS Upload Port          : 4903

EM Instance Home           : /data2/app/oracle/gc_inst/em/EMGC_OMS1

OMS Log Directory Location : /data2/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log

OMS is not configured with SLB or virtual hostname

Agent Upload is locked.

OMS Console is locked.

Active CA ID: 1

Console URL: https://ccuine25.xyz.co.in:7803/em

Upload URL: https://ccuine25.xyz.co.in:4903/empbs/upload

 

WLS Domain Information

Domain Name            : GCDomain

Admin Server Host      : ccuine25.xyz.co.in

Admin Server HTTPS Port: 7102

Admin Server is RUNNING

 

Oracle Management Server Information

Managed Server Instance Name: EMGC_OMS1

Oracle Management Server Instance Host: ccuine25.xyz.co.in

WebTier is Up

Oracle Management Server is Up

JVMD Engine is Up

 

To Shutdown OMS:-

cd $MW_HOME/bin

[oem@ccuine25 bin]$ ./emctl stop oms -all

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Stopping Oracle Management Server...

WebTier Successfully Stopped

Oracle Management Server Successfully Stopped

AdminServer Successfully Stopped

Oracle Management Server is Down

JVMD Engine is Down

 

To Start OEM agent (In Target Server):-

export AGENT_HOME=/DEV/agent/emagent/agent_inst

cd $AGENT_HOME/bin

[r12devdb@ccuine14 bin]$ ./emctl start agent

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Starting agent ........ started.

 

To Stop OEM agent (In Target Server):-

cd $AGENT_HOME/bin

[r12devdb@ccuine14 bin]$ ./emctl stop agent

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Stopping agent ... stopped.

 

To check status of OEM agent(In Target Server):-

cd $AGENT_HOME/bin

[r12devdb@ccuine14 bin]$ ./emctl status agent

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

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

Agent Version          : 13.5.0.0.0

OMS Version            : 13.5.0.0.0

Protocol Version       : 12.1.0.1.0

Agent Home             : /DEV/agent/emagent/agent_inst

Agent Log Directory    : /DEV/agent/emagent/agent_inst/sysman/log

Agent Binaries         : /DEV/agent/emagent/agent_13.5.0.0.0

Core JAR Location      : /DEV/agent/emagent/agent_13.5.0.0.0/jlib

Agent Process ID       : 5265

Parent Process ID      : 5115

Agent URL              : https://ccuine14.xyz.co.in:3872/emd/main/

Local Agent URL in NAT : https://ccuine14.xyz.co.in:3872/emd/main/

Repository URL         : https://ccuine25.xyz.co.in:4903/empbs/upload

Started at             : 2021-12-22 10:48:33

Started by user        : r12devdb

Operating System       : Linux version 3.10.0-1062.el7.x86_64 (amd64)

Number of Targets      : 5

Last Reload            : (none)

Last successful upload                       : 2021-12-22 12:59:38

Last attempted upload                        : 2021-12-22 12:59:38

Total Megabytes of XML files uploaded so far : 5.58

Number of XML files pending upload           : 0

Size of XML files pending upload(MB)         : 0

Available disk space on upload filesystem    : 24.53%

Collection Status                            : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2021-12-22 13:00:24

Last successful heartbeat to OMS             : 2021-12-22 13:00:24

Next scheduled heartbeat to OMS              : 2021-12-22 13:01:24

 

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

Agent is Running and Ready

 

 


Oracle Database 26ai Installation Using RPM on Oracle Linux 9 (OEL 9) – Step-by-Step Guide

  In this post I will describe the installation of Oracle Database 26ai 64-bit on Oracle Linux 9 (OL8) 64-bit. The installation requires a m...