ORA-09313: slsprom: error prompting user

Cause : Mya eb uoto fr eosucres

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

See SODe rorra cocmapniyn gtihsm essaeg

update : 16-08-2017
ORA-09313

ORA-09313 - slsprom: error prompting user
ORA-09313 - slsprom: error prompting user

  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION string
  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-22991 : insufficient space allocated for argument string
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-16820 : Fast-Start Failover observer is no longer observing this database
  • ora-13624 : The task string is executing and cannot be deleted or modified.
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-12618 : TNS:versions are incompatible
  • ora-32808 : message system link string does not exist
  • ora-23360 : only one materialized view for master table "string" can be created
  • ora-00360 : not a logfile member: string
  • ora-16152 : standby database is in 'no-data-loss' protected mode
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-09313 : slsprom: error prompting user
  • ora-31052 : Cannot delete ACL with other references
  • ora-39775 : direct path API commit not allowed due to previous fatal error
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-25427 : cannot downgrade database links after database link data dictionary has been upgraded
  • ora-29909 : label for the ancillary operator is not a literal number
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-01220 : file based sort illegal before database is open
  • ora-10634 : Segment is already being shrunk
  • 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.