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
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
Comment