1 Reply Latest reply on Aug 7, 2017 6:42 PM by Aldrich

    Cloning issue.

    3178882

      Team,

      We have two virtual nodes. 1. novprddb1test and 2. novprdapp1test . We run database, CM and Admin on novprddb1test. Form and Web runs on novdevapp1test.

      Currently, both novprddb1test and novprdapp1test point to physical host

       

      I have perform the below steps to perform the clone but facing couple of issues.

       

      DB ; 10.2.0.3.0

      App ; 11.5.9

      OS : OSF1 agdcfinnovtest1.novelis.biz V5.1 2650 alpha (HP-TRU64)

       

      Step 1. Restore and recovered the database from rman backup.

      Step2 . Re-created the control file and opened the db name with new name.

      Step 3. Build the xml file on db tire

      Step 4 . Change the parameter s_hostname and s_virtualhostaname  on xml from hostname to virtual hostname. (agdcfinnovtest1 to novprddb1test)

      Step 5 . start the listener on db tier. (

      Step 6 . I try to configure the cm tier from adcfgclone but ran into couple issues.(unable to connect to database if the listener is running with physical host) so I copied the xml file from prod to test server and made necessary changes to file and ran the autoconfig . autoconfig completed successfully.

      Step 7.  For web tier I did the same copy the xml file from prod to test server and made necessary change . ran the autoconfig .

      Autoconfig completed successfully.

       

      I can able to view the forms using dev60cgi/f60cgi

       

      found that fnd_concurrent_queues table didnt update properly. will that be the issue ..?

      CONCURRENT_QUEUE_NAME having varchar2(30) but we are having 32 characters . 

       

      desc apps.fnd_concurrent_queues;

      Name Null? Type

      ----------------------------------------- -------- ----------------------------

      APPLICATION_ID NOT NULL NUMBER(15)

      CONCURRENT_QUEUE_ID NOT NULL NUMBER(15)

      CONCURRENT_QUEUE_NAME NOT NULL VARCHAR2(30)

       

         

      CONTROL_CODETARGET_NODENODE_NAMECONCURRENT_QUEUE_NAME
      ENOVPRDDB1TESTNOVPRDDB1TESTFNDSM_NOVPRDDB1TEST
      EAUTHENTICATIONAUTHENTICATIONFNDSM_AUTHENTICATION
      ENOVPRDAPP1TEST.NOVELIS.BIZNOVPRDAPP1TEST.NOVELIS.BIZFNDSM_NOVPRDAPP1TEST.NOVELIS.B
      ENOVPRDDB1TEST.NOVELIS.BIZNOVPRDDB1TEST.NOVELIS.BIZFNDSM_NOVPRDDB1TEST.NOVELIS.BI

       

      Currently I’m facing two issues which

      Issue 1 . the login page issue

      I can able to get the home page but when i click on e-business page im getting web page not found.

       

       

      issue 2. CCM are not coming up and unable to view o/p file.

      Routine AFPCAL received failure code while parsing or running your

      concurrent program CPMGR

      Review your concurrent request log file for more detailed information.

      Make sure you are passing arguments in the correct format.

      The PRODTEST_0803@PRODTEST internal concurrent manager has terminated with status 1 - giving up.

       

      Workaround till now I did for CCM issue.

      Restart db and app

      Execute FND_CONC_CLONE.SETUP_CLEAN

      cmclean.sql

      Autoconfig on db tier

      Autoconfig on db cm tier

      Autoconfig on db web tier

       

      Workaround till now I did for view o/p issue .

       

      Check the RRS:Service Prefix

      Check Concurrent:GSM Enabled

      Relink FNDFS : adrelink.sh force=y "fnd FNDFS"

       

      In tnsname.ora file . FNDFS_ prefix with virtual alias so I made manaual entry with hostname being what is returned from a "uname -n" but still facing the same issue.

      with the FNDFS_<hostname>

      with the FNDFS_<SID>

      with the FNDFS_<hostname.domain>