ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

Cause : The LOCK_NAME_SPACE initialization parameter contained a value that is too long.

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

Correct the LOCK_NAME_SPACE initialization parameter.

update : 24-09-2017

ORA-15002 - parameter LOCK_NAME_SPACE exceeds limit of string characters
ORA-15002 - parameter LOCK_NAME_SPACE exceeds limit of string characters

  • ora-22619 : all collection elements have already been accessed
  • ora-02274 : duplicate referential constraint specifications
  • ora-19580 : %s conversation not active
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-22327 : cannot change a type to NOT INSTANTIABLE if it has dependent tables
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-24050 : subscribers are not supported for exception queue string
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-12480 : specified clearance labels not within the effective clearance
  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-28168 : attempted to grant password-protected role
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-08318 : sllfsk: Error reading file
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-30753 : column or table string is substitutable
  • ora-38201 : assert if pin during flush
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-28654 : table and partition not overflow compatible
  • ora-24803 : illegal parameter value in lob read function
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-13352 : the coordinates do not describe a circle
  • ora-24272 : initialization value must be either F or T
  • ora-13865 : Module name must be specified
  • ora-30106 : reserved for future use
  • 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.