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 : 30-05-2017

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

  • ora-09203 : sfofi: error opening file
  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-01500 : failure in getting date/time
  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-22902 : CURSOR expression not allowed
  • ora-16587 : ambiguous object specified to Data Guard broker
  • ora-27006 : sbtremove returned error
  • ora-32739 : Hang analysis aborted due to failed heap re-grow
  • ora-32317 : cannot run a job from a job
  • ora-02072 : distributed database network protocol mismatch
  • ora-12922 : concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
  • ora-26056 : Requested direct path operation on a view is not supported.
  • ora-06109 : NETTCP: message receive failure
  • ora-03125 : client-server protocol violation
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-28045 : SSL authentication between database and OID failed
  • ora-13025 : polygon does not close
  • ora-12699 : Native service internal error
  • ora-19931 : file string has invalid creation SCN string
  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-02257 : maximum number of columns exceeded
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-25100 : TABLESPACE option can only be used with ALTER INDEX REBUILD
  • ora-23405 : refresh group number string does not exist
  • ora-04075 : invalid trigger action
  • ora-09708 : soacon: failed to bind socket to port.
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-15005 : name "string" is already used by an existing alias
  • 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.