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)