Announcement

Collapse
No announcement yet.

Error deploying OTM

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Error deploying OTM

    Error: OTM application has not been deployed correctly.

    Software:

    Windows 2003 Server with Service Pack 1
    Internet Explorer 6.0 SP1
    Oracle 10g Release 2 (10.2.0.3.0) Enterprise Edition
    [OAS] Oracle Application Server 10.1.3.0 + patches
    Oracle 10gR2 (10.2.0.3.0) client (Administrator install)

    Installation steps:

    · Oracle application server 10.1.3.0 installation.
    · Oracle 10g Release 2 Enterprise Edition and Client installations.
    · Database created correctly.
    · OTM software.
    · Database configuration with OTM scripts.
    Database non-partitioned

    Scripts:
    @create_glog_roles.sql
    @create_glog_users.sql

    Import OTM Database Structure and Public Data

    Running OTM scripts

    In SQL*Plus, as user GLOGOWNER run:
    @create_vpd_package.sql
    @glogowner_grants.sql
    @create_public_synonyms.sql
    @create_logon_triggers (enter connection string when prompted)

    In SQL*Plus, as user ARCHIVE run:
    @archive_grants

    In SQL*Plus, as user REPORTOWNER run:
    @reportowner_grants.sql
    @create_public_synonyms.sql
    @recompile_invalid_objects.sql

    In SQL*Plus, as user GLOGOWNER run:
    @aq_setup.sql
    @recompile_invalid_objects.sql

    Reset Sequences
    In SQL*Plus as the GLOGOWNER user, run:
    Set serverout on size 1000000
    Execute domainman.reset_sequence;


    Setup Security Roles
    In SQL*Plus as the GLOGOWNER user, run:
    @insert_security_roles.sql


    Migrate the New Database
    In SQL*Plus as user GLOGOWNER, run:
    @dbpatch_55.sql . This script does not be executed correctly.


    Error 1: Asks for PART_1 tablespace when the database is non partitioned.

    Error 2:
    WARNING: Sequence VISIBILITY_PIECE_SEQUENCE is mappet to VISIBILITY_PIECE.VISIBILITY_PIECE_XID which does not exist.

    Table VISIBILITY_PIECE does not exist!

    Error 3:
    Applying updates...

    Adding primary keys....
    VISIBILITY_PIECE ORA-00942: table or view does not exist

    Adding new sequences...

    WARNING: Sequence VISIBILITY_PIECE_SEQUENCE is mapped to
    VISIBILITY_PIECE.VISIBILITY_PIECE_XID which does not exist.


    Cleaning up obsolete synonyms

    Loading new java classes...
    Enter glogowner password for parameter 1.
    Enter dbname for parameter 2.


    Enable all policies after making structure change

    Re-validate VPD package and other objects before changing data...

    ORA-24344: success with compilation error


    List of first 50 Invalid objects after recompile.
    ================================================
    PKG_DHL_UTIL PACKAGE BODY

    Errors for PACKAGE BODY PKG_DHL_UTIL:
    50/122 PL/SQL: ORA-00942: table or view does not exist

    50/5 PL/SQL: SQL Statement ignored

    55/30 PLS-00201: identifier 'VISIBILITY_PIECE.LAST_EVENT_EVENT_TYPE_GI
    D' must be declared
    PL/SQL: Item ignored

    56/28 PLS-00201: identifier 'VISIBILITY_PIECE.LAST_EVENT_UPDATE_DATE'
    must be declared
    PL/SQL: Item ignored

    57/28 PLS-00201: identifier 'VISIBILITY_PIECE.LAST_EVENT_DATE_OFFSET'
    must be declared
    PL/SQL: Item ignored

    58/15 PLS-00201: identifier 'VISIBILITY_PIECE.STATUS' must be declared

    PL/SQL: Item ignored

    62/24 PLS-00320: the declaration of the type of this expression is inc
    omplete or malformed

    62/5 PL/SQL: SQL Statement ignored

    66/64 PLS-00320: the declaration of the type of this expression is inc
    omplete or malformed

    71/69 PLS-00320: the declaration of the type of this expression is inc
    omplete or malformed
    Invalid objects before Recompile....

    1

    Invalid objects after Recompile....

    1



    The number of invalid objects is still the same after recompile.


    Please analyze the existing invalid objects.


    Adding check constraints...

    Setting up grants and public synonyms...





    In SQL*Plus as user GLOGOWNER, run:
    @insert_security_roles.sql


    When otmwebtomcat55 and otmapp55 are started, otm application does not deploy!
    But in the Task Manager we have two apache.exe processes and two application servers deployed!!!!!!



    Installing the Replicated Operational Database for Reporting and Archiving
    It has not been carried out




    We can not access to OTM application


    Any suggestion?

    Thank you in advance
    Attached Files

  • #2
    Re: Error deploying OTM

    Hello!

    I've found that it's necessary to utilize a partitioned database with OTM v5.5 CU1 and above. While I haven't seen the official specs haven't changed (I believe), the recent patches appear to have been only tested on a partitioned database. If you're not able to move to a partitioned database, I'd recommend contacting Oracle Support in order to log this as a bug and get the issues resolved by development.

    I know that the OTM development group was looking to drop support for non-partitioned databases at some point, so I definitely recommend moving in this direction for all new OTM instances.

    Another point - for development instances, using Oracle Application Server is fine, but I strongly recommend against using it for production instances until it has been production proven. To put it simply, OTM has run on WebLogic for 8 years now and only for 6 months on OAS.

    Thanks!
    --Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire

    Comment


    • #3
      Re: Error deploying OTM

      One more note - can you post your console.log file for the OTM app server? This will include more details on the deployment issues, which may or may not be related to the DB issues (though I definitely recommend resolving the DB issues first).

      --Chris
      Chris Plough
      twitter.com/chrisplough
      MavenWire

      Comment

      Working...
      X
      😀
      🥰
      🤢
      😎
      😡
      👍
      👎