Wrong Service Name

Issue:
====

After Cloning using RMAN, For the RAC instances with oracle Apps 11i. The service name shows source instance name, ie)PROD.

In RAC DB Node 1:

sql > show parameter service

service_names string TEST, SYS$APPLSYS.WF_CONTROL.PROD.DOYENSYS.COM

In RAC DB Node 2:

sql > show parameter service

TEST

So, In Node 1 it shows as PROD and in Node 2 it show correctly as TEST.

Reason:
======

The database service name is created by the concurrent manager Service, So Clean up the queues which is old one and bounce the RAC and apps and check.

Solution:
========

Step 1: Down the Apps Tier.

Step 2: Run the Following Script.

PWD :
=====

/TEST/oracle/testappl/fnd/11.5.0/patch/115/sql

[applmgr@oraappstest1 sql]$ ls -lrt wfctqrec.sql

-rwxr-xr-x 1 applmgr oinstall 2916 May 16 2006 wfctqrec.sql

[applmgr@oraappstest1 sql]$ sqlplus apps tstapps/passwd @wfctqrec.sql applsys passwd

Step 3: Down the DB, Listener in Both RAC Nodes and Bounce

Step 4: Now Bounce the Apps Tier.

Step 5: Now check the show parameter service, It shows

sql > show parameter service

service_names string TEST, SYS$APPLSYS.WF_CONTROL.TEST.DOYENSYS.COM

Note :

SOURCE : PROD
TARGET : TEST