After Cloning DB Tier Service Name Shows PROD Name

After Cloning DB Tier Service Name Shows PROD Name

After Cloning DB Tier, Service Name shows like this. This 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: Bounce the Apps Tier.

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 Listener in Both RAC Nodes

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 service
service_names string UAT, SYS$APPLSYS.WF_CONTROL.UAT.DOYENSYS.COM

OR
sql > show parameter serviceservice_names string UAT