Monday, May 02, 2011

How to Change the System Name in Workflow

After Cloning required to change workflow system name.
Change the service name in TEST:

In apps node
SQL> select NAME from wf_systems;

NAME
--------

PROD.DOYENSYS.COM


SQL> select GUID from wf_systems;

GUID
--------------------------------
3CA4A184BD2C99FFE040500A1F033CD9


SQL> select NAME, SYSTEM_GUID from wf_agents;

Go to bellow path and run the following scripts txkWfClone.sh .

$ cd /TEST/apps/testcomn/admin/install/TEST_oratest2


$ sh txkWfClone.sh apps apps

txkWfClone.sh started at Mon Dec 29 03:49:05 EST 2008
The environment settings are as follows ...
apps_HOME : /TEST/apps/testora/8.0.6
apps_SID :
TWO_TASK : TEST_806_BALANCE
PATH : /TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testappl/fnd/11.5.0/bin:/TEST/apps/testappl/ad/11.5.0/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50::/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50:/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/applmgr/bin
LD_LIBRARY_PATH : /TEST/apps/testora/8.0.6/network/jre11/lib/i686/native_threads:/TEST/apps/testora/8.0.6/network/jre11/lib/linux/native_threads:/TEST/apps/testappl/cz/11.5.0/bin:/TEST/apps/testora/8.0.6/lib:/usr/X11R6/lib:/usr/openwin/lib

Executable : /TEST/apps/testora/8.0.6/bin/sqlplus


SQL*Plus: Release 8.0.6.0.0 - Production on Mon Dec 29 03:49:05 2008

(c) Copyright 1999 apps Corporation. All rights reserved.

Connected.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from apps Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ERRORCODE = 0 ERRORCODE_END


After completing this scripts, now check againg the following query.
Now its changed the service name PROD to TEST.

SQL> show parameter service

NAME TYPE VALUE
---------------------------
service_names string TEST



SQL> select NAME from wf_systems;

NAME
------------------------------
TEST.DOYENSYS.COM



SQL> select GUID from wf_systems;

GUID
--------------------------------
5F2BB84D418D8F79E040500A0B02363F



SQL> select NAME, SYSTEM_GUID from wf_agents;


Regards,
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget