After Cloning DB Tier Service Name Shows PROD (Source Database) Name

After Cloning DB Tier, Service Name shows like this. (The same also name also reflecting in lsnrctl status UAT)  This is wrong, So we need do the folloing steps.

Error Message:

sql > show parameter service

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

Solutions:

Step 1: Shut down the Apps Tier, if it's up (adstpall.sh).

Then Go to respective Directory.

/UAT/oracle/uatappl/fnd/11.5.0/patch/115/sql

$ ls -lrt wfctqrec.sql

-----wfctqrec.sql

step 2:SQL> sqlplus apps/passwd
SQL> @wfctqrec.sql applsys passwd

Step 3: Bounce the DB and Local Listener in Both RAC Nodes (using srvctl)

Setp 4: Start Both Nodes and Listener

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


After finishing above tasks, its changed.

sql > show parameter serviceservice_names string UAT