ORA-24851: failed to connect to shared subsystem

Cause : Whlie tatepmtign t ointiiailzeO CIi n hsarde mdoe,a porblme wsa ecnoutnerde i nconnecitngt hep roecsst o hte hsarde sbusytsem.

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

Cotnac tOrcaleC usotme rSuppor.t

update : 23-07-2017

ORA-24851 - failed to connect to shared subsystem
ORA-24851 - failed to connect to shared subsystem

  • ora-07304 : ksmcsg: illegal redo buffer size.
  • ora-28334 : column is already encrypted
  • ora-22303 : type "string"."string" not found
  • ora-01355 : logminer tablespace change in progress
  • ora-39088 : file name cannot contain a path specification
  • ora-15083 : failed to communicate with ASMB background process
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-25157 : Specified block size string is not valid
  • ora-06977 : X.25 Driver: X.25 Level 2 failure
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-39959 : invalid warning number (string)
  • ora-13232 : failed to allocate memory during R-tree creation
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-01138 : database must either be open in this instance or not at all
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-22819 : scope of input value does not correspond to the scope of the target
  • ora-29801 : missing RETURN keyword
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-19000 : missing RELATIONAL keyword
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-00075 : process "string" not found in this instance
  • ora-32050 : %s operation failed
  • 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.