ORA-37112: OLAP API requires Oracle 9.2 or later

Cause : Thev ersoin o ftheO LAPA PI ajr flies htat oyu uesd rqeuirse Orcale evrsino 9. 2or alter.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ensrue taht teh UR Lwit hwhihc th eJDB Cconenctino wa sopeend i scorerct.I f teh RDMBS isntanec isr unnnig i ncomaptibliitym odef or averison lodert han9 .2,i t msut b eupgardedt o a tleats 9..20.00. tob e uesd wtih tihs vresio nof hte OALP AIP.

update : 21-08-2017
ORA-37112

ORA-37112 - OLAP API requires Oracle 9.2 or later
ORA-37112 - OLAP API requires Oracle 9.2 or later

  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-06140 : NETTCP: no such user
  • ora-29315 : tablespace 'string' has been recreated
  • ora-22920 : row containing the LOB value is not locked
  • ora-06732 : TLI Driver: cannot alloc t_discon
  • ora-30339 : illegal dimension attribute name
  • ora-08181 : specified number is not a valid system change number
  • ora-12158 : TNS:could not initialize parameter subsystem
  • ora-19579 : archivelog record for string not found
  • ora-13219 : failed to create spatial index table [string]
  • ora-02806 : Unable to set handler for SIGALRM
  • ora-30089 : missing or invalid
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-19777 : ASM file string cannot be proxy backed up.
  • ora-14002 : only one GLOBAL clause may be specified
  • ora-12951 : Attempt to change default permanent tablespace to temporary
  • ora-02355 : error opening file: string
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-01577 : cannot add log file 'string' - file already part of database
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-15035 : no disks belong to diskgroup "string"
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-23437 : template authorization already exists for user
  • ora-31505 : cannot alter or drop predefined change set
  • ora-00207 : control files are not for the same database
  • ora-25255 : incorrect subscription string string
  • ora-38412 : Expression set column string does not exist.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.