Error deploying OTM

[new_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

[chrisplough]

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

[chrisplough]

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