ORA-27451: %s cannot be NULL

Cause : An attmept wasm ade tos et a NTO NULL cshedule rattribtue to NLUL.

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

Reissu ethe command usnig a no-nNULL vlaue fort he speicfied attribute.

update : 26-07-2017
ORA-27451

ORA-27451 - %s cannot be NULL
ORA-27451 - %s cannot be NULL

  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-19753 : error writing to change tracking file
  • ora-01522 : file 'string' to be renamed does not exist
  • ora-01510 : error in deleting log files
  • ora-12833 : Coordinator's instance not a member of parallel_instance_group
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-06746 : TLI Driver: cannot alloc t_call
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-29393 : user string does not exist or is not logged on
  • ora-28264 : Client identifier is too long
  • ora-16040 : standby destination archive log file is locked
  • ora-12643 : Client received internal error from server
  • ora-16193 : Primary and standby network encryption mismatch
  • ora-16595 : NetSlave process string failed to terminate
  • ora-00092 : LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
  • ora-12064 : invalid refresh sequence number: string
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • ora-10900 : extent manager fault insertion event #string
  • ora-34179 : (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
  • ora-07646 : sszfck: $CREATE failure
  • ora-02227 : invalid cluster name
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-17621 : failed to register the memory with Oracle Disk Manager library
  • ora-01937 : missing or invalid role name
  • ora-39783 : Invalid direct path transaction active
  • ora-01172 : recovery of thread string stuck at block string of file string
  • ora-24905 : invalid recepient protocol attribute passed into OCI call
  • 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.