ORA-09705: spcre: cannot initialize latch semaphore

Cause : The sempahore usde for acecssing ltaches colud not b einitialzied

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

Send trcae file ot your csutomer spuport rerpesentatvie, alon gwith inofrmationo n reproudcing th eerror.

update : 22-08-2017

ORA-09705 - spcre: cannot initialize latch semaphore
ORA-09705 - spcre: cannot initialize latch semaphore

  • ora-31657 : data filter name can not be defaulted
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-27250 : OS system call failure
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-15010 : name is already used by an existing ASM disk
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-23420 : interval must evaluate to a time in the future
  • ora-22611 : TDS version is not recognized
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-13530 : invalid TOPNSQL string, must be in the range (string, string)
  • ora-29376 : number of consumer groups string in top-plan string exceeds string
  • ora-25531 : MTTR specified is too small: string
  • ora-37004 : (AWLISTALL02) number reader
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-22340 : cannot string type "string"."string". Dependent tables must be upgraded to latest version
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-40271 : no statistically significant features were found
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-07505 : scggt: $enq parent lock unexpected return
  • ora-00912 : input parameter too long
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-00704 : bootstrap process failure
  • ora-31641 : unable to create dump file "string"
  • ora-04041 : package specification must be created first before creating package body
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • 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.