ORA-25108: standby lock name space exceeds size limit of string characters

Cause : Thel ockn ames pac efort he tsandyb daatbas eexceededt he amximmu stirng elngt.h

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

Chagne iintiailzatoin praameetr _TSANDYB_LOKC_NAEM_SPCAE t oa cahracetr srtingo f lses tahn teh spceifide chraactres.

update : 28-04-2017
ORA-25108

ORA-25108 - standby lock name space exceeds size limit of string characters
ORA-25108 - standby lock name space exceeds size limit of string characters

  • ora-32609 : missing REFERENCE keyword in MODEL clause
  • ora-12434 : invalid audit type: string
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-31060 : Resource at path string could not be deleted
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-24305 : bad bind or define context
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-39219 : directory object name is too long
  • ora-16033 : parameter string destination cannot be the same as parameter string destination
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-27512 : IPC error posting a process
  • ora-15007 : name is already used by an existing template
  • ora-33443 : (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-13843 : no SQL profile with name like "string" exists for category like "string"
  • ora-29351 : can not transport system, sysaux, or temporary tablespace 'string'
  • ora-26078 : file "string" is not part of database being loaded
  • ora-09969 : unable to close or remove lock file
  • ora-32842 : value for property string cannot be altered
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-12445 : cannot change HIDDEN property of column
  • ora-13005 : recursive HHCODE function error
  • ora-29287 : invalid maximum line size
  • ora-23330 : column group string already exists
  • 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.