Attempting a fresh install of Enterprise ZAM 7.5 install using Oracle 10g R2 database server with appropriate full Licence.
* Fresh install of W2K3 R2 server on ESX guest server, .net 2 and Oracle client 10g r2 10.02
* Oracle net service name configured using Oracle tools and test connectivity
* Run the scripts against the Oracle database as per instructions included in the Oracle_Schema_Creation_Scripts_7_5.zip - completes with no error.
* Install ZAM using the ZEN75_AssetMgmt.iso from Novell's download site.
*At the appropriate point in the install create the ODBC data source and run the reg file customized with appropriate settings.
* Run DBInit - completes with no error.
* Cancel the Database creation tool as per install instructions.
* Install copies some files for the File Store creation, then attempts to connect to the data base and fails with the following error:
"Zenworks Asset Management Setup cannot connect to the database due to an unknown DBP Exception"
* Click on OK to dismiss error message and the installer reports "File Store Initialization Failed".
* Test database connectivity using any of the available tools (command line, odbc gui, Oracle tools gui etc) and connects just fine.
* Any subsequent attempt to run the ZAM installer results in the same error.

This install has been attempted many times and it always fails at the same point with the same issue.

setup.log shows:
// ----------------------------------------------------------------- //
// --- Log Opened: 24/11/2008 12:20:48 PM


***
Module: DBPersist - 24/11/2008 12:20:49 PM
Method: HandleError
RWDBStatus - Code: 5 Terminal: FALSE
Message: SQL call failed.
Error1: 1017 Message1: 28000
Error2: 1 Message2: [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied



***
Module: DBPersist - 24/11/2008 12:20:49 PM
Method: HandleError
DOXException [2.5.4] DOXErrorChain:
[2.5.3] DBOracleErrorHandler::serverError() -
Param1 {[5] SQL call failed.}
Param2 {[1017] 28000}
Param3 {[1] SQL call failed.}
Param4 {}

[2.5.4] DBOracleErrorHandler::serverError() -
Param1 {}
Param2 {}
Param3 {}
Param4 {}

[2.5.4] DBOracleErrorHandler::serverError() -
Param1 {}
Param2 {}
Param3 {}
Param4 {}


// --- Log Closed: 24/11/2008 12:20:49 PM
// ----------------------------------------------------------------- //


Reading this log it appears that the installer is now using credentials that are incorrect, yet in the previous dbinit step the credentials it uses work OK?

What am I missing?