How to Create NEW DOMAIN in OTM (GLOG)

Hi All,

OTM (Oracle Transportation Management) which is perviously GLOG. Here we are giving the steps to create a new domain.

1) connect to the OTM instance and shutdown all components except the database

OTM Web Tier
#su –
#cd /etc/init.d
#./otweb55 stop

OTM App Tier
#su –
#cd /etc/init.d
#./otmapp55 stop

OTM Reports Tier
#su –
#cd /etc/init.d
#./otmrptweb55 stop
#su – oracle
#cd /oracle/product/fr10g/opmn/bin
#./opmncrtl stopall

BPEL
#su – oracle
#cd /oracle/product/oas10g/opmn/bin
#./opmnctl stopproc ias-component=OraBPEL

2) su – otm55
3) cd /oracle/otm/glog/oracle/script8
4) sqlplus glogowner/glogowner@otmdb    ==>> Log in a glogowner
5) SQL> @create_pkg_novpd_inschema_copy.sql;   ==>> Complile the package
6) SQL> @novpd_domain_copy_script_builder.sql;   ==>> to generate the domain copy script “novpd_load.sql
7) SQL> execute pkg_novpd_domain_copy.set_copy_parameters(‘EBS’, ‘FUNC’, true, false);
Parameter definition (source domain Name, target domain name, copy_child_domains,
retrieve domain information from remote target database(if false, pulls informaiton from the local source database instead of a remote target database)
8) SQL> set serverout on size 1000000;    ===>> Set the server output parameters to print the following command
9) SQL> execture pkg_novpd_domain_copy.print_copy_parameters; ===>> verify the parameters (i.e. EBS to FUNC copy)
10) SQL> @vpd_load.sql;      ==>> Perform the copy of EBS to FUNC…
12) restart OTM

BPEL
#su – oracle
#cd /oracle/product/oas10g/opmn/bin
#./opmnctl startproc ias-component=OraBPEL

OTM Reports Tier
#su – oracle
#cd /oracle/product/fr10g/opmn/bin
#./opmnctl startall
#su –
#cd /etc/init.d
#./otmrptweb55 start

OTM App Tier
#su – oracle
#cd /etc/init.d
#./otmapp55 start

OTM Web Tier
#su – oracle
#cd /etc/init.d
#./otweb55 start

11) SQL> execute domainman.reset_sequence;   ==>> reset the master internal sequence numbers (only for a fresh instance, not a clone…)

Advertisements
  1. December 3, 2014 at 4:07 am

    What’s Going down i am new to this, I stumbled upon this I have discovered It absolutely useful and it has
    aided me out loads. I am hoping to give a contribution & help other users like its helped me.
    Good job.

    Like

    • ursvenkat
      December 18, 2014 at 2:51 pm

      Thank you.

      Like

  2. December 10, 2014 at 6:56 am

    We’re a group of volunteers and starting a new scheme in our community.
    Your site provided us with valuable info to work on. You’ve done a
    formidable job and our entire community will bee thankful to you.

    Like

  3. a
    December 11, 2014 at 11:49 am

    Hello! Do you know if they make any plugins to help with Search Engine
    Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Many thanks!

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: