I ran the ZEN 6.5 installation on the Master Server (NW 6 Sp4e eDir 8.7.3) and my Oracle 8i DB running on a Unix Server started giving these errors:
The following errors were found in the alert log for MGMTDB
Alert log was copied into /u01/admin/MGMTDB/bdump/alert_MGMTDB.log.monitored
This procedure checks the alert every 5 minutes
Thu Aug 12 15:00:08 PDT 2004
--------------------------------------------------------------


ORA-1535 signalled during: create rollback segment rb2 TABLESPACE "RBS" STOR...
Thu Aug 12 14:56:44 2004

ORA-1636 signalled during: alter rollback segment rb2 online...
Thu Aug 12 14:56:44 2004

ORA-25143 signalled during: alter tablespace cim3 default storage (maxextents ...
DDL_AUDIT~12-AUG-2004 14:57:02~CREATE PROCEDURE ZENWORKS.C$NETWAREOPERATINGSYSTEM~12,1188~ZENWORKS ,FSMIS~JDBC THIN CLIENT~FSMIS

We tried to upgrade the DB to Oracle 9i and run the scripts mentioned in the upgrade from Zen 4 to 6.5 documentation.
and now in ConsoleOne when I try to do an Inventory Query I get the following message:

The configured database is not a compatible database.
You are trying to access the later version of the ZENworks database.

My P:\Zenworks\Inv\server\WmInv\logs\zenworksinvservi ce log file has this when I restart the invstart on my NW6 server:

[8/13/04 13:44:22.292] ZENInv - Server Config: The severconfig service start is pending...
[8/13/04 13:44:23.678] ZENInv - Server Config: Getting Cascade INit time
[8/13/04 13:44:25.450] ZENInv - Server Config: Database Location Policy DN is CN=Server Package:General:ZENworks Database.OU=MIS.O=WFM
[8/13/04 13:44:27.858] ZENInv - Server Config: The severconfig service is started...
[8/13/04 13:44:29.511] ZENInv - Sync Scheduler: The scheduler service start is pending...
[8/13/04 13:44:30.677] ZENInv - Sync Scheduler: This is the schedule fetchedRun Daily: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday From 5:30:00 PM To 5:00:00 AM (Randomly dispatch during time period)
[8/13/04 13:44:31.664] ZENInv - Sync Scheduler: fetchSchedule returned: true
[8/13/04 13:44:32.635] ZENInv - Sync Scheduler: The scheduler service is started...
[8/13/04 13:44:33.771] ZenInv - Upgrade Service: Info : Read zenInvComponentStatus = 6.5 12 0
[8/13/04 13:44:34.737] ZenInv - Upgrade Service: Inventory Server zenInvComponentStatus = 6.5 12 0
[8/13/04 13:44:35.936] Service Manager: start(ServiceDataAccessor, String[]) not found in 'com.novell.zenworks.desktop.inventory.storer.Stor erServiceInit'
[8/13/04 13:44:37.652] ZENInv - Storer: Start with 'ServiceStatusChangeListener' invoked
[8/13/04 13:44:37.944] ZenInv - Upgrade Service: Unzipping the file migrate.zip
[8/13/04 13:44:41.106] ZenInv - Upgrade Service: Transforming the Migration SQL files...
[8/13/04 13:44:47.297] ZENInv - Storer: zenworks.isClosed =true
[8/13/04 13:44:48.689] ZENInv - Storer: The current NDS tree=WFMTREE
[8/13/04 13:44:49.675] ZENInv - Storer: Storer from dblocation user: MW_DBA driver: oracle.jdbc.driver.OracleDriver protocol: jdbc:oracle: subname: thin:@ port: 1543
[8/13/04 13:44:50.725] ZENInv - Storer: url[From DBObject]: jdbc:oracle:thin:@198.162.208.15:1543:mgmtdb
[8/13/04 13:44:51.876] ZENInv - Storer: wsdn: CN=Inventory Service_FSMIS.OU=MIS.O=WFMi = 0
[8/13/04 13:44:52.963] ZENInv - Storer: Loading Storer test properties file
[8/13/04 13:44:53.984] Service Manager: start(ServiceDataAccessor, String[]) not found in 'com.novell.zenworks.desktop.inventory.strconverte r.STRConverterServiceInit'
[8/13/04 13:44:54.506] ZENInv - Status Reporting: Unable to write message to the XML file for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:44:55.190] ZENInv - STRConverter: Start with 'ServiceStatusChangeListener' invoked
[8/13/04 13:44:56.312] ZenInv - Upgrade Service: Starting Schema Migration
[8/13/04 13:44:57.732] ZENInv - Status Reporting: Number of records to add are: 1 for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:44:58.404] ZenInv - Upgrade Service: mw_dba->alter tablespace cim3 default storage (maxextents unlimited) is being executed
[8/13/04 13:45:00.466] ZenInv - Upgrade Service: Could not do the operation. details:ORA-25143: default storage clause is not compatible with allocation policy
ErrorCode:25143
[8/13/04 13:45:01.078] ZENInv - Status Reporting: Adding record 0 for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:45:01.605] ZenInv - Upgrade Service: Totaltime taken for Schema Migration : 3308
[8/13/04 13:45:03.833] ZENInv - Storer: cim.isClosed =true
[8/13/04 13:45:04.960] ZENInv - Status Reporting: Number of modified records are: 0 for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:45:05.095] ZENInv - Status Reporting: Unable to write message to the XML file for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:45:06.149] ZENInv - Storer: Database is not initialized..will retry after 300 seconds
[8/13/04 13:45:07.344] ZENInv - STRConverter: Loading STRConverter test properties file
[8/13/04 13:45:08.403] ZENInv - Storer: Storer: Database not initialized as it is being upgraded ...will retry after 300 seconds.
[8/13/04 13:45:09.769] ZENInv - Status Reporting: Number of records to add are: 1 for DN=CN=Inventory Service_FSMIS.OU=MIS.O=WFM
[8/13/04 13:45:10.380] Service Manager: start(ServiceDataAccessor, String[]) not found in 'com.novell.zenworks.desktop.invent





I am not sure where to start.
I would have no problem removing inv from all my NW servers and starting with a clean DB.
But I have 22 server to do and in 6 weeks we are adding up to 30 more.
So I would like to find a straightforward solution that I can document.

Thanks for any help you can give.
Jarett