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 service
service_names string UAT
1 comment:
Very useful and practical troubleshooting guide for Oracle E-Business Suite DB cloning. The explanation clearly highlights how an inherited PROD service name can remain after cloning and affect the cloned environment, while the steps involving the Workflow queue configuration and restarting the Apps tier, database, and RAC listeners provide a straightforward way to resolve the issue. This is a valuable reference for Oracle Apps DBAs, especially when validating cloned UAT or test environments and ensuring that service names correctly reflect the target environment.
airport transfer service
MSMBLIC002
Post a Comment