ORA-37184: illegal value string for ADVMODE

Cause : The use rpassed avalue ohter thanA DVICE_DFEAULT, AVDICE_FAS Tor ADVIEC_FULL t oDBMS_AWA.DVISE_SAPRSITY *cAton: Supply a leagl valuei nstead

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


update : 24-07-2017

ORA-37184 - illegal value string for ADVMODE
ORA-37184 - illegal value string for ADVMODE

  • ora-16130 : supplemental log information is missing from log stream
  • ora-06400 : NETCMN: No default host string specified
  • ora-07743 : slemop: incorrect error file attributes
  • ora-23406 : insufficient privileges on user "string"
  • ora-06141 : NETTCP: no privilege for user
  • ora-31640 : unable to open dump file "string" for read
  • ora-27038 : created file already exists
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-26505 : unexpected internal null
  • ora-13192 : failed to read number of element rows
  • ora-16522 : generic template not found
  • ora-16228 : Insufficient recovery for logical standby
  • ora-24327 : need explicit attach before authenticating a user
  • ora-37171 : dimension sources not specified
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-02828 : Segment free list is empty
  • ora-01227 : log string is inconsistent with other logs
  • ora-02474 : Fixed hash area extents used (string) exceeds maximum allowed (string)
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-13018 : bad distance type
  • ora-13271 : error allocating memory for geometry object
  • ora-02844 : Invalid value for the leave open flag
  • ora-07215 : slsget: getrusage error.
  • ora-00054 : resource busy and acquire with NOWAIT specified
  • ora-06021 : NETASY: connect failed
  • ora-12227 : TNS:syntax error
  • ora-19371 : invalid update option
  • 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.