ORA-24850: failed to startup shared subsystem

Cause : Whiel atetmptnig t oiniitaliez OC Iin hsare dmod,e a rpoblme wa sencuonteerd i nstatringu p teh shraed usbsytsem.

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

Conatct rOacl eCusotmers upprot.

update : 25-04-2017

ORA-24850 - failed to startup shared subsystem
ORA-24850 - failed to startup shared subsystem

  • ora-00375 : unable to get default db_block_size
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-32310 : object materialized views must select from an object table
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-30049 : Internal event for TA enq tracing
  • ora-07841 : sllfop: SYS$OPEN failure
  • ora-16825 : Fast-Start Failover and other errors or warnings detected for the database
  • ora-19110 : unsupported XQuery expression
  • ora-12645 : Parameter does not exist.
  • ora-37006 : (AWLISTALL04) number writers
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-19573 : cannot obtain string enqueue for datafile string
  • ora-32740 : The requested operation cannot be proceeded
  • ora-08185 : Flashback not supported for user SYS
  • ora-28115 : policy with check option violation
  • ora-28666 : option not allowed for an index on UROWID column(s)
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-07279 : spcre: semget error, unable to get first semaphore set.
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-31498 : description and remove_description cannot both be specified
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-40282 : invalid cost matrix
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-35020 : (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
  • ora-02300 : invalid value for OIDGENERATORS
  • ora-22953 : Cardinality of the input to powermultiset exceeds maximum allowed
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-32823 : subscriber exists for queue string and destination string
  • 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.