Download - Manual Cloning
db tier
1.control file creation:startup nomountcreate controlfile set database "clon" resetlogs noarchivelog-- set standby to maximize performance maxlogfiles 16 maxlogmembers 5 maxdatafiles 512 maxinstances 1 maxloghistory 7260logfile group 1 ( '/u00/app/orsbox/oradata/clondata/log01a.dbf', '/u00/app/orsbox/oradata/clondata/log01b.dbf' ) size 10m, group 2 ( '/u00/app/orsbox/oradata/clondata/log02a.dbf', '/u00/app/orsbox/oradata/clondata/log02b.dbf' ) size 10m-- standby logfiledatafile '/u00/app/orsbox/oradata/clondata/system01.dbf', '/u00/app/orsbox/oradata/clondata/system02.dbf', '/u00/app/orsbox/oradata/clondata/system03.dbf', '/u00/app/orsbox/oradata/clondata/system04.dbf', '/u00/app/orsbox/oradata/clondata/system05.dbf', '/u00/app/orsbox/oradata/clondata/ctxd01.dbf', … …. …./u00/app/orsbox/oradata/clondata/edrd01.dbf', '/u00/app/orsbox/oradata/clondata/edrx01.dbf', '/u00/app/orsbox/oradata/clondata/prpd01.dbf', '/u00/app/orsbox/oradata/clondata/prpx01.dbf'character set us7ascii;
2.remove existing control files
bash-2.05$ ls cnt*cntrl01.dbf cntrl02.dbf cntrl03.dbfbash-2.05$ rm cntrl01.dbfbash-2.05$ rm cntrl02.dbf
bash-2.05$ rm cntrl03.dbf
3. edit init parameter file as required , rename the concern context name directories parallelyset the variable oracle_sid=”new db name”set your env of source inorder to open sqlplus
4.run the controlfile script with database nomount by specifying the path of pfile.open the database
5.change the entries in listener and tns names file
6.edit the env file, addblnctl.sh and addbctl.sh scripts
7.set the path variable
/u00/app/orsbox/oracle/clondb/9.2.0/apache/perl/bin:/u00/app/orsbox/oracle/clondb/9.2.0/bin:/usr/bin:/bin:/usr/bin/x11:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/git/bin:/usr/x11r6/bin:/usr/local/bin
8.run the env file
9.start the listener
----------------------------------------
application tier
change the below in each and every file
hostnamesid / two_taskport
try to bring up the services one by one in the below order after modifying the respective set of files.
listenerapacheformsreportsconcurrentphp – if u have issues.
1.modify the clon_oc109.env
2.modify /u00/app/apsbox/applmgr/clonappl/fnd/11.5.0/fndenv.env
3.change the context name dir’s in $common_top/admin
4.change /u00/app/apsbox/applmgr/clonappl/admin/adovars.env
5.edit the entries in /u00/app/apsbox/applmgr/cloncomn/html/bin/appsweb_clon_oc109.cfg (server parameters)
6.modify the parameters in /u00/app/apsbox/applmgr/clonappl/customclon_oc109.env (if required)
/u00/app/apsbox/applmgr/clonora/8.0.6/clon_oc109.env
7.modify the listener and tnsnames files located at "/u00/app/apsbox/applmgr/clonora/8.0.6/network/admin/clon_oc109"
8.modify the env file of ias_home/u00/app/apsbox/applmgr/clonora/ias/clon_oc109.env
9.edit the tnsnames in ias_home/u00/app/apsbox/applmgr/clonora/ias/network/admin/clon_oc109/tnsnames.ora
10.change scripts in common top
adalnctl.shadcmctl.shadfmsctl.sh
/u00/app/apsbox/applmgr/clonappl/clon.env/u00/app/apsbox/applmgr/clonora/8.0.6/clon.env
adrepctl.shadtcfctl.sh
/u00/app/apsbox/applmgr/cloncomn/html/env.txtadapcctl.sh
/u00/app/apsbox/applmgr/clonora/ias/apache/apache/bin/apachectl/u00/app/apsbox/applmgr/clonora/ias/apache/modplsql/cfg/wdbsvr.app/u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/httpd_pls.conf/u00/app/apsbox/applmgr/clonora/ias/apache/modplsql/cfg/plsql_pls.conf/u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/apps.conf/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/jserv.conf
/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/jserv.properties /u00/app/apsbox/applmgr/clonappl/imt/11.5.0/admin/scripts/imtjserv.properties
"/u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/ssl.crt/ca-bundle.crt"
/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/zone.properties/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/mobile.properties
/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/viewer4i.properties/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/xmlsvcs.properties/u00/app/apsbox/applmgr/clonora/ias/soap/webapps/soap/web-
inf/config/soap.properties/u00/app/apsbox/applmgr/clonora/ias/soap/webapps/soap/web-
inf/config/soapconfig.xml/u00/app/apsbox/applmgr/clonora/ias/apache/jserv/etc/jserv.properties
/u00/app/apsbox/applmgr/clonappl/imt/11.5.0/admin/scripts/imtjserv.properties /u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/httpd.conf.default /u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/oracle_apache.conf
/u00/app/apsbox/applmgr/clonora/ias/apache/modplsql/cfg/plsql.conf/u00/app/apsbox/applmgr/clonora/ias/xdk/admin/xml.conf/u00/app/apsbox/applmgr/clonora/ias/apache/jsp/conf/ojsp.conf/u00/app/apsbox/applmgr/clonora/ias/oem_webstage/oem.conf/u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/imeeting.conf/u00/app/apsbox/applmgr/clonora/ias/apache/apache/conf/apps.conf
addisctl.sh/u00/app/apsbox/applmgr/clonora/8.0.6/discwb4/discwb.sh
adfrmctl.shadstpall.shgsmstart.shadstrtal.shjtffmctl.sh
/u00/app/apsbox/applmgr/clonappl/fnd/11.5.0/secure/oc109_clon.dbc
11.xml file modification
/u00/app/apsbox/applmgr/clonappl/admin/clon_oc109.xml/u00/app/apsbox/applmgr/clonappl/admin/topfile.txt/u00/app/apsbox/applmgr/clonappl/admin/adconfig.txt
12 . $fnd_top/bin/concsub
13.change discoverer scripts located in/u00/app/apsbox/applmgr/clonora/8.0.6/discwb4/util
applypreferences.shcheckdiscoverer.shregisterall.shregistercollector.shregisterpreference.shregistersession.shregistersessionwithlog.shruncol.shrunpref.shrunses.shstartall.shstartgatekeeper.shstartgkconfig.shstartlocator.shstartoad.shstartosagent.shstopall.shstopgatekeeper.shstoplocator.shstopoad.shstoposagent.shunregistercollector.shunregisterpreference.shunregistersession.sh
startall logfile details
[service control execution report]the report format is: <service> <script> <status>
oracle apache server clon_oc109 adapcctl.sh started oracletnslistener80apps_clon_oc109 adalnctl.sh started oracleconcmgrclon_oc109 adcmctl.sh started oracleformsserver-forms60clon_oc109 adfrmctl.sh started oracle reports server [rep60_clon_oc109] adrepctl.sh started oracle metrics client clon_oc109 adfmcctl.sh started oracle metrics server clon_oc109 adfmsctl.sh started oracle fulfillment server clon_oc109 jtffmctl.sh started oracle discoverer services clon_oc109 addisctl.sh started (no need to bother) oracle apache server clon_oc109 for pl/sql adapcctl.sh disabled oracle tcf socketserver clon_oc109 adtcfctl.sh disabled oracle icsm clon_oc109 ieoicsm.sh disabled oracle iprocurement bulk loader clon_oc109 icxblkctl.sh disabled
14.$oa_html/bin/appsweb.cfg for plsql
15.appsweb_cfg in $appl_top/u00/app/apsbox/applmgr/clonappl/fnd/11.5.0/resource/appsweb.cfg/u00/app/apsbox/applmgr/clonappl/fnd/11.5.0/resource/appsweb_clon_oc109.cfg
16. modify the following entries in the table in apps schemasql> select node_name from fnd_nodes;sql> update fnd_nodes set node_name='oc109';
sql> desc fnd_profile_option_values; name null? type ------------------------------- -------- ---- application_id not null number profile_option_id not null number level_id not null number level_value not null number last_update_date not null date last_updated_by not null number(15) creation_date not null date created_by not null number(15) last_update_login not null number(15) profile_option_value varchar2(240) level_value_application_id number(15)
sql> select profile_option_value from fnd_profile_option_values where profile_option_value like '%http%';
profile_option_value--------------------------------------------------------------------------------http://oc107.oracle.com:8003/pls/prodhttp://oc107.oracle.com:8003/dev60cgi/f60cgihttp://maps.yahoo.com/py/maps.py?bfcat=&pyt=tmap&newfl=use+address+below&addr=@address1&csz=@city+@state+@postal_code&country=@country&get%aomap=get+map
http://elocation.oracle.com/servlets/lbshttp://elocation.oracle.com/servlets/lbshttp://oc107.oracle.com:8003/oa_servletshttp://oc107.oracle.com:8003/oa_servletshttp://oc107.oracle.com:8003http://oc107.oracle.com:8003/discwb4/html/discolaunch.htm?connect=[apps_secure]
profile_option_value
--------------------------------------------------------------------------------http://oc107.oracle.com:8003/discoverer4i/viewer?connect=[apps_secure]http://oc107.oracle.com:8003/oa_mediahttp://oc107.oracle.com:8003/configurator/oracle.apps.cz.servlet.uiservlethttp://oc107.oracle.com:8003/configurator/oracle.apps.cz.servlet.uiservlethttp://oc107.oracle.com:8003/oa_mediahttp://oc107.oracle.com:8003/oa_servlets/ibyecapphttp://oc107.oracle.com:8003/oa_html/http://oc107.oracle.com:8003/pls/prod_portal30/portal30.homehttp://myserver.mycompany.com:15010/gatekeeper.iorhttp://maps.yahoo.com/py/maps.py?bfcat=&pyt=tmap&newfl=use+address+below&addr=$address$&csz=$city$%20$state$%20$zipcode$&country=$country$&get%20map=get+map
profile_option_value--------------------------------------------------------------------------------
http://ap906sun.us.oracle.com:15010/gatekeeper.iorhttp://www.oracle.comhttp://oc107.oracle.com:8003/oa_mediahttp://oc107.oracle.com:8003/dev60cgi/rwcgi60http://oc107.oracle.com:8003/pls/prod/http://oc107.oracle.com:8003/cachehttp://oc107.oracle.com:8003http://ap804sun.us.oracle.com:778/oa_htmlhttps://globalaccess.dnb.com/access/scriptshttp://chalk.us.oracle.com:8090
profile_option_value--------------------------------------------------------------------------------http://elocation.oracle.com/elocation/lbs
30 rows selected.
sql> select profile_option_value from fnd_profile_option_values where profile_option_value like '%prod%' or profile_option_value like '%oc107%' or profile_option_value like '%prod%';
profile_option_value--------------------------------------------------------------------------------per:br_prod_hrper:br_prod_hrssp:br_prod_sspsmphxt:br_prod_otm_masterota:br_prod_ota/u00/app/apsbox/applmgr/prodappl/ams/11.5.0/bin//u00/app/apsbox/applmgr/prodcomn/admin/inbound/prod_oc107/damaged product
product_coverageprodprod
profile_option_value--------------------------------------------------------------------------------prodprodoc107.oracle.com/u00/app/apsbox/applmgr/prodcomn/admin/log/prod_oc107oc107prodoc107.oracle.comoc107.oracle.com/u00/app/apsbox/applmgr/prodcomn/admin/inbound/prod_oc107/u00/app/apsbox/applmgr/prodappl/cn/11.5.0/bin/u00/app/orsbox/oracle/proddb/9.2.0/appsutil/outbound/prod_oc107
profile_option_value--------------------------------------------------------------------------------/u00/app/apsbox/applmgr/prodora/ias/apache/apache/conf/ssl.crt/ca-bundle.crtoc107.oracle.comoc107.oracle.com/u00/app/orsbox/oracle/proddb/9.2.0/appsutil/outbound/prod_oc107prod_appsoc107.oracle.com:8003prodproduction/u00/app/apsbox/applmgr/prodcomn/admin/log/prod_oc107
31 rows selected.
17.start all the services
18.checkthe front end ,
19.perform aoljtest
20.if any problem with front end you can check the forms page through the following link
http://oc109.oracle.com:8003/dev60cgi/f60cgi
csh - to supress editor colourscd - - to go to the dir previously we came fromgrep -i <string> * (to search the string entry in all the files in current directory)set -o vi (to use the previous commands in $ shell)esc :%s,<old value>,<new value>,g (to replace all the old values with new value in the editor globally)