SQL execution error, ORA-30041 installing ZAM 7.0 on Oracle

  • Document ID:3005275
  • Creation Date:23-May-2006
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Asset Management

Environment

Novell ZENworks Asset Management 7 - ZAM7

Situation

The ZAM 7.0 setup routine via the cd will fail with the following error on 10G release 2::
'SQL execution error, ORA-30041: Cannot grant quota on the tablespace' during the'Creating System User ID' process.

Resolution

Downloadand run the Oracle Schema Creation scripts provided within the ZAM toolkit on the support site.
Oraclehas changed the rules for 10g release 2 where by you can no longer set QUOTA UNLIMTED ON TEMP tablespaces and this now appears to be the default behavior.

You must remove the syntax QUOTA UNLIMITED ON TSCTEMP which occurs both during the creation of the schema owner NCSYSTEM and the user NCSTARTUP.