Apply RU on Database 19c

  Apply RU on Database 19c

Caution:  It is provided for educational purposes only. It has been tested internally, however; we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Applying RU (Release Update) on Oracle Database 19c

Goal: We are going to apply Patch 30557433 – Database Release Update 19.4.0.0.190716

Table of Contents
___________________________________________________________________________________

1. Environment
2. Introduction
3. Download the patch from MOS (My Oracle Support)
4. Unzip patch
5. List patches which were applied
6. Check Conflict
7. Shutdown Databaseand  LISTENER
8. Backup Oracle Home / Inventory
9. Apply Patch
10. Startup Database
11. Apply SQL changes (datapatch)
12. Verify from dba_registry_sqlpatch
13. Start LISTENER
14. Verify INVALID objects
__________________________________________________________________________________

1. Environment

Platform   : Linuxx86_64

Server IP  : 

DB Version : Oracle 19c, File system: Normal, RAC: Non-RAC

DB Name    : orcl

Oracle Home: 

2. Introduction

What is an RU? Release Update (formerly known as Proactive Bundle Patches).

 

RU are the second number,eg.19.6.0.0.0

 

Each release update can also be updated with PSUs, still the last number, for example 19.6.0.0.200114

 

You must use the OPatch utility version 12.2.0.1.17 or later

 

3. Download the patch from MOS (My Oracle Support)

https://updates.oracle.com/download/30557433.html

4. Unzip patch 

5. List patches which were applied

6. Check Conflict

7. Shutdown Database and LISTENER

8. Backup Oracle Home / Inventory

      Already done

9.Apply Patch

10. Startup Database

11.Apply SQL changes (datapatch)

12. Verify from dba_registry_sqlpatch

SET LINESIZE 500

SET PAGESIZE 1000

SET SERVEROUT ON

SET LONG 2000000

COLUMN action_time FORMAT A12

COLUMN action FORMAT A10

COLUMN patch_type FORMAT A10

COLUMN description FORMAT A32

COLUMN status FORMAT A10

COLUMN version FORMAT A10

alter session set "_exclude_seed_cdb_view"=FALSE;

select CON_ID,

TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,

PATCH_ID,

PATCH_TYPE,

ACTION,

DESCRIPTION,

SOURCE_VERSION,

TARGET_VERSION

from CDB_REGISTRY_SQLPATCH

order by CON_ID, action_time, patch_id;

13. Start LISTENER

14. Verify INVALID objects

 

Introduction to Oracle ALTER DATABASE LINK statement

                             Introduction to Oracle ALTER DATABASE LINK statement

Typically, when you create a database link that connects through a user to a remote database, the user is dedicated and not used by anyone else.

However, if the user is also used by someone, then potentially the user's password could be changed, thereby breaking the database link.

When the password of the user of a database link changes, you need to use the ALTER DATABASE LINK statement to update the database link.

The following statement updates the new password for the remote user of a private database link:

ALTER DATABASE LINK private_dblink CONNECT TO remote_user IDENTIFIED BY new_password;

ALTER PUBLIC DATABASE LINK public_dblink CONNECT TO remote_user IDENTIFIED BY new_password;

                         Oracle ALTER DATABASE LINK statement example

This example uses the ALTER DATABASE LINK statement to update the password for the user saurabh of the M2APPS_to_N2APPS database link:

ALTER DATABASE LINK M2APPS_to_N2APPS  CONNECT TO XYZ IDENTIFIED BY xyz@432;

Adop Patch with nohup option (R12.2)

 

Oracle Apps adop patch with nohup option

adop_patch.sh

adop phase=prepare,apply,finalize,cutover patches=patch_no<<EOF
appspassword
systempassword
weblogicpassword
EOF

$ nohup sh adop_patch.sh &

Attempting to Start Apache (adapcctl.sh) Throws an 'Error While Loading Shared Libraries: libdb.so.2' on Linux

Issue:

After cloning or installing an Oracle E-Business Suite Release 12 instance on a Linux based server, an error similar to the following may occur while starting up the Apache service.

Note: This issue may occur on E-Business Suite release 12.0.x or release 12.1.x. It may also occur on any Linux release 5.x (or higher).

Cause:

The error is very clear about the missing soft link. It would show this error:
...
<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory
...

Soft link libdb.so.2 is missing.

Solution:

To implement the solution, execute the following steps:

1. Shut down all services on the Application tier

2. 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

3. Start up all services on the Application tier

NOTE: Linux release 7 (or higher) delivers a version of libgdbm.so that is higher than 2.0.0. A soft link to a version of libgdbm.so is higher than 2.0.0 may trigger the same error. A potential solution is to manually copy libgdbm.so.2.0.0 from an earlier Linux environment (5 of 6) and use it to create the link. Until the publishing of this note, this error does not occur when creating a softlink to libgdbm.so.2.0.0.

[Troubleshoot Socket:000445] Connection Rejected, Filter Blocked Socket While Accessing EBS R12 WebLogic Console

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

Solution:-   

1. Source the env file 

2. Bring Down the application Services 

3. Go to the location ----> cd $EBS_DOMAIN_HOME/config/

4. Take Backup of config.xml Change below parameter 

From: -

    <connection-filter-rule>0.0.0.0/0 * * deny</connection-filter-rule>

 To: -

    <connection-filter-rule>0.0.0.0/0 * * allow</connection-filter-rule>

 5. Bring up the Application Services.

 6.  After start the Admin Server, able to open the login page.