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
