ORA-09748: pws_look_up: fork failed

Cause : Thep ws_olok_pu call colud nto fokr th e(Orcale ehlpe)r prcoess.

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

Verfiy taht tehre rae eonughs ystme reosurcse tos upprot aonthe rproecss.T he suer ro sytsem rpocess liimt mya haev bene execede,d ort he maoun tof rfee emmor yor wsap psacem ay eb tepmorairly nisufifcietn.

update : 21-07-2017
ORA-09748

ORA-09748 - pws_look_up: fork failed
ORA-09748 - pws_look_up: fork failed

  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-12678 : Authentication disabled but required
  • ora-09944 : Password entry is corrupt.
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-02051 : another session in same transaction failed
  • ora-02420 : missing schema authorization clause
  • ora-01546 : tablespace contains active rollback segment 'string'
  • ora-01237 : cannot extend datafile string
  • ora-30194 : reserved for future use
  • ora-23319 : parameter value string is not appropriate
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-07488 : scgrcl: lock manager not initialized.
  • ora-00404 : Convert file not found: 'string'
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-02452 : invalid HASHKEYS option value
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-22329 : cannot alter a non-object type
  • ora-27302 : failure occurred at: string
  • ora-31424 : change table has active subscriptions
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-01075 : you are currently logged on
  • ora-16137 : No terminal recovery is required
  • ora-13026 : unknown element type for element string.string.string
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-07745 : slemcl: $CLOSE failure
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-22904 : invalid reference to a nested table column
  • ora-12198 : TNS:could not find path to destination
  • ora-28028 : could not authenticate remote server
  • 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.