Contact Premier Online Trainings Today

Oracle Apps DBA - R12.2 Upgrade: Rapidwiz Prerequisite Check Fails DB service_names Check has failed

Date Added: 21 Dec.2019 Date Updated: 21 Dec.2019 Oracle Apps DBA Full Blog

R12.2 Upgrade: Rapidwiz Prerequisite Check Fails DB service_names Check has failed

Issue:

DB service_names Check
DB service_names Check has failed.
Add ebs_patch as an entry in Database service_names parameter before proceeding.
 
Solution:
 
Modify the service_names parameter to include ebs_patch as shown below and retry.
 
SQL> show parameter service
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      PROD
SQL>
SQL> show parameter spfile
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /db/oracle/PROD/12.1.0/dbs/spfilePROD.ora
SQL>
 
SQL> select name from v$database;
 
NAME
---------
PROD
 
SQL> alter system set service_names='PROD','ebs_patch' scope=both ;
 
System altered.
 
SQL> show parameter service
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      PROD, ebs_patch
SQL>
 
SQL> shut immediate
SQL> startup