EBS R12.2 Upgrade: Rapidwiz Prerequisite Check Fails With Message: DB Version Check Has Failed.

 

Issue Description:

Oracle E-business suite R12.2 Upgrade File System Pre-install check Failed :

——————-ADX Database Utility Finished—————

DB Version Check has failed.
Not able to check the Database version. Please make sure the Database is at 11.2.0.3 or higher

DB service_names Check has failed.
Not able to check if ebs_patch as an entry exists in Database service_name parameter.

Existing DB SID validation has failed.
Connection to database failed.  Unable to validate the current SID

FIX:

Database connectivity issue can be resolved by doing the following steps :

Review the  sqlnet.ora file and confirm the following entries are present:

SQLNET.ALLOWED_LOGON_VERSION_SERVER

i) If the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE:

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

ii) If SEC_CASE_SENSITIVE_LOGON is set to TRUE

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10

Modify the service_names parameter  and include ebs_patch as shown below and retry.

SQL> sho parameter service

NAME                                 TYPE        VALUE
———————————— ———– ——————————
service_names                        string      dnbtyi

SQL> alter system set service_names=’dnbtyi’,’ebs_patch’ scope=both ;

System altered.

SQL> sho parameter service

NAME                                 TYPE        VALUE
———————————— ———– ——————————
service_names                        string      dnbtyi, ebs_patch

After change issue should be resolved.

Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

How to set up the Oracle Wallets in Oracle Database 19C

PRVG-11250 : The check "RPM Package Manager database" was not performed because

ORA-00257:archiver error, connect internal only until freed

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

How to write to a CSV file using Oracle SQL*Plus

Change Password in an Oracle Database