ORA-24031: invalid value, string should be non-NULL

Cause : Parameter is NULL.

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

Specify a non NULL value for the parameter.

update : 27-05-2017
ORA-24031

ORA-24031 - invalid value, string should be non-NULL
ORA-24031 - invalid value, string should be non-NULL

  • ora-00602 : internal programming exception
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-29834 : REF datatype not supported with operators
  • ora-24018 : STOP_QUEUE on string failed, outstanding transactions found
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-27102 : out of memory
  • ora-06432 : ssaio: Buffer Not Aligned
  • ora-00235 : control file fixed table inconsistent due to concurrent update
  • ora-12438 : repeated policy option: string
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-26091 : requested direct path operation not supported
  • ora-31637 : cannot create job string for user string
  • ora-12852 : PARALLEL_MIN_SERVERS must be less than PROCESSES, string
  • ora-39052 : cannot specify SKIP_CURRENT on initial start of a job.
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-14251 : Specified subpartition does not exist
  • ora-02263 : need to specify the datatype for this column
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-25212 : invalid PRIORITY specified when using sequence deviation
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-28512 : cannot get data dictionary translations from string
  • ora-25425 : connection lost during rollback
  • ora-37031 : (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-25116 : invalid block number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-31438 : duplicate change table string
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-30732 : table contains no user-visible columns
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • 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.