Announcement

Collapse
No announcement yet.

shortcut to OTM DB installation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • shortcut to OTM DB installation

    Hi All,
    As a learning / new commer to OTM biggest challenge was to install OTM, When ever I was installing OTM the biggest problem was with the DB scripts which were never getting installed fully as there was allways an error not sure if it was only my issue, infact I had tracked many issues posted with same errors.
    This post is to create a short cut on reducing the script running problem

    This is only for people who want to install OTM for learning or Training purpose and not for any

    This for 5.5v CU5
    Files listed
    OTM-DB-OLD.doc -> Old steps as mentioned in Admin Guide
    OTM-DB-NEW.doc -> modified by me.
    TABLE_SPACE.sql -> in case you encounter the problem with standard file use this.
    imp_otmv55.par -> DB import file.
    otmDUMP_04012010.dmp -> database dump file

    hope this helps!!
    Attached Files
    B.S.Chakravarthy Yadav
    Product Design Head

  • #2
    Re: shortcut to OTM DB installation

    Nice work of putting everthing together.
    However, I found some parts you are missing or misunderstood.

    Here are my tips for OTM DB Installation:
    Create Database
    Make sure DB parameter O7_DICTIONARY_ACCESSIBILITY=true
    This is the most important step. Without this, you might encounter all kind of problems later.

    Create Tablespace
    Make sure you have at least 4GB for DATA and INDX tablespaces to import OTM seeded DB dump (otmv55_partition.dmp)

    Import Database
    Based on my experiences, it's better to import DB by sys (despite OTM Admin Guide says to use system)

    OTM DB Scripts
    Make sure all scripts in Admin Guide are executed without error.

    dbpatch_55.sql
    - No matter for fresh installation or upgrade, dbpatch_55.sql MUST be applied.
    - Before execute the script, make sure the following classes are in CLASSPATH, if you are using OAS
    [OTM]/oas/j2ee/home/lib/ejb.jar
    [OTM]/oas/j2ee/home/lib/jta.jar
    [OTM]/oas/jdbc/lib/ojdbc14dms.jar
    [OTM]/oas/lib/dms.jar
    - After the script is completed, check the log files (dbpatch_xxx.log and update_content_xxx.log) to ensure they are error free before proceeding to the next step

    Export Database
    For backup or DB transfer purpose, you might need to export DB. Based on my experiences, you must export DB by sys with FULL=Y option or using exp_GC3.par

    Re-import Database
    For restore or DB transfer purpose, you might need to re-import DB. After DB is imported, re-apply OTM DB scripts including insert_security_roles.sql, but NO need to re-apply dbpatch_55.sql
    --
    Joseph Liang
    MavenWire APAC
    http://www.mavenwire.com/

    Comment


    • #3
      Re: shortcut to OTM DB installation

      Hi Joseph,
      Thanks for the input,

      Actaully the .dmp was taken after the execution of dbpatch_55.sql and insert_security_roles.sql

      sorry to ask a dumb question as I am a semi technical guy and not a DBA what difference does it make if i don't run these scripts as already the dump contains the executed scripts and i simply import the .dmp as when i test the same the object count and the DB structure remained same.
      or am i missing smething?
      Thanks




      B.S.Chakravarthy Yadav
      Product Design Head

      Comment


      • #4
        Re: shortcut to OTM DB installation

        See OTM Admin Guide (http://download.oracle.com/docs/cd/B...nistration.pdf) - Oracle Export/Import Utility section
        8. After the import finished successfully, there are post-import SQL scripts to be run in the target database. The steps to run these scripts are described in the Installing Oracle Transportation Management on the Database Server section. It is important to follow the instructions to run the scripts. Ensure you log in to the database as right users when running the scripts.
        --
        Joseph Liang
        MavenWire APAC
        http://www.mavenwire.com/

        Comment


        • #5
          Re: shortcut to OTM DB installation

          Originally posted by josephliang View Post
          Here are my tips for OTM DB Installation:
          Create Database
          Make sure DB parameter O7_DICTIONARY_ACCESSIBILITY=true
          This is the most important step. Without this, you might encounter all kind of problems later.

          Just a note that in 6.1 this is changed to false. You will need to login as sysdba before any of your connect strings to import/export a database going forward. Also insert_security_roles.sql is no longer used.
          If my post was helpful please click on the Thanks! button

          MavenWire Hosting Admin
          15 years of OTM experience

          Comment


          • #6
            Re: shortcut to OTM DB installation

            Need to start learning 6.x after this project
            --
            Joseph Liang
            MavenWire APAC
            http://www.mavenwire.com/

            Comment


            • #7
              Re: shortcut to OTM DB installation

              Hi
              I am not sure if this is a valid request,
              Is it possible for any member to upload a DB dump as i have done for 5.5 CU5 for 6.0 as i want to compare the same.
              Actually I amworking on OTM SeedDB concept where we generally used to upload to create all the setups in our previous ERP application and instead of running the scripts for every new customer we just use to import this dump.
              Above request is for testing in my personal meachine and not for any commercial use
              Thanks in advance
              B.S.Chakravarthy Yadav
              Product Design Head

              Comment


              • #8
                Re: shortcut to OTM DB installation

                When I am trying to install Db for OTM 6.0 I am not ale to set O7_DICTIONARY_ACCESSIBILITY to true
                It is allways returning false

                I tried below command at SQLPROMPT
                alter system set o7_dictionary_accessibility=true scope=spfile;
                and also
                set the same in init.ora file

                but still I am getting error : O7_DICTIONARY_ACCESSIBILITY is false.
                is there any other way to make it as true
                B.S.Chakravarthy Yadav
                Product Design Head

                Comment


                • #9
                  Re: shortcut to OTM DB installation

                  got the ans from a DBA
                  after executing the
                  alter system set o7_dictionary_accessibility=true scope=spfile;
                  we need to execute
                  startup force command in SQLPROMPT
                  B.S.Chakravarthy Yadav
                  Product Design Head

                  Comment


                  • #10
                    Re: shortcut to OTM DB installation

                    Don't worry - even I keep a note doc with some of the install differences. It's funny how much changes with v6.1

                    --Chris

                    Comment

                    Working...
                    X