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;
Refered Notes:
The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1
How to Change the System Name in Workflow?
Doc ID: 387337.1
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;
Refered Notes:
The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1
How to Change the System Name in Workflow?
Doc ID: 387337.1
No comments:
Post a Comment