Re: OAM Application dashboard not reflecting the DEV server details after cloning

Hi all,

Thanks a lot for your support on this.

I would like to share my solution how I could resolve. Basically the
information was not given properly when running clone on appsTier by my
other colleague. I scrapped everything and copied a new binaries from
production and ran adcfgclone,pl properly and after few changes in context
file autoconfig was run. Things are resolved.

Once again thank you very much for your help and optional approaches, as it
will help for other s.

Regards,
RG


On Dec 10, 2007 1:11 AM, vikram singh <vikramsingh120@xxxxxxxxx> wrote:

>
> Hi,
>
> To clear the nodes information from the instance immediately after the
> clone, we use the below command:
>
> SQL> conn apps/<apps_passwd>
> SQL> select node_name from fnd_nodes;
> SQL> exec fnd_conc_clone.setup_clean;
> SQL> select node_name from fnd_nodes;
> SQL> -- Run the cmclean script. This script can be downloaded from the
> metalink.
>
> Later run AutoConfig to re-populate the node information in *fnd_nodes*table. 
> Before running  AutoConfig, it is advisable to check the value for
> *s_hostname* in the $CONTEXT_FILE. This should reflect the correct
> nodename. (Generally when using Virtual hostnames, this value is wrongly
> pointed to the virtual name rather than the real hostname)
>
> Additionally, you can execute the "Synchronize Workflow Local Tables"
> request from the application to ensure all the workflow related tables are
> in sync. I am not sure if this helps in this scenario, but it is definitely
> worth a try. You can run this request from the SQL*Plus prompt also (in case
> it is not possible to bring up the concurrent managers for some reason)
> using the below SQL:
>
> SQL> conn apps/<apps_passwd>
> SQL> begin
>     apps.wf_local_synch.BULKSYNCHRONIZATION(
>         P_ORIG_SYSTEM=>'ALL',
>         P_PARALLEL_PROCESSES=>2,
>         P_LOGGING=>'LOGGING',
>         P_RAISEERRORS=>TRUE,
>         P_TEMPTABLESPACE=>'APPLSYSX');
> END;
> /
>
> There is a separate version of this command if you are using OATM. for
> more details you can refer metalink note: *418130.1*
>
> Hope this helps.
>
> Thanks,
> Vikram..
>
> *
> *On Dec 9, 2007 3:54 PM, Samer ALJazZar <samer.jazzar@xxxxxxxxx> wrote:
>
> > Hello,
> >
> > run this command in the cloned Instance
> >
> > then run autoconfig in both dbtier and appstier
> >
> > regards,
> >
> > On Dec 9, 2007 10:28 AM, Atul Kumar <atul_iiit@xxxxxxxxx> wrote:
> >
> > > RG,
> > >
> > >   Also check FND_NODES in cloned (DEV) instance , if they have
> > > additional entry for Prod (source) instance as well. If you see prod entry
> > > in FND_NODES table of DEV instance that will mean there was some issue
> > > during clone.
> > >
> > >
> > > Kindly confirm if everything sompleted successfully during cloning.
> > >
> > >
> > > Regards
> > > Atul Kumar
> > > http://onLineAppsDBA.com <http://onlineappsdba.com/>  (One Stop Shop
> > > for Apps DBA's)
> > >
> > >
> > >
> > > *hyder hussain syed <sd.hyder@xxxxxxxxx>* wrote:
> > >
> > > Hi
> > >
> > >
> > > You need to check the DEV  listeners and tnsname files and also check
> > > dbc file .
> > >
> > >  otherwise run the autoconfig on DEV instance and see the autoconfig
> > > log file ,
> > >
> > >
> > > Best Regards
> > > Hyder
> > >
> > > On Dec 9, 2007 3:50 AM, Apps DBA <dbaorapps@xxxxxxxxx> wrote:
> > >
> > > > Hello gurus,
> > > >
> > > > We did recently a cloning of DEV from PROD instance.
> > > >
> > > > I am facing the issue that when I login to OAM the Application
> > > > Dashboard is reflecting production database server details and all the 
> > > > PROD
> > > > server information. Can any one please let me know what is the approach 
> > > > in
> > > > resolving this issue?.
> > > > Is there any issue with OAM?
> > > >
> > > >
> > > > http://hostname.domainname:8000/oa_servlets/weboam/oam/oamApps$target=TPROD
> > > >
> > > > Thanks,
> > > > RG
> > > >
> > >
> > >
> > >
> >
> >
> > --
> > Samer M. ALJazzar
> > Oracle Database Administrator-ITD
> > National Bank of Kuwait
> > Mob:- 7298729
>
>
>

Other related posts: