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 .
Name Null? Type
----------------------------------------- -------- ----------------------------
APPLICATION_ID NOT NULL NUMBER(15)
CONCURRENT_QUEUE_ID NOT NULL NUMBER(15)
CONCURRENT_QUEUE_NAME NOT NULL VARCHAR2(30)
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
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>