ORA-24793: Test DTP service start and stop

Cause : internal use only

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


update : 29-04-2017

ORA-24793 - Test DTP service start and stop
ORA-24793 - Test DTP service start and stop

  • ora-07417 : sfareq: One or more database writers not active.
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-00104 : deadlock detected; all public servers blocked waiting for resources
  • ora-22953 : Cardinality of the input to powermultiset exceeds maximum allowed
  • ora-13125 : partition key is already set
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-03007 : obsolete feature
  • ora-16204 : DDL successfully applied
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-00210 : cannot open the specified control file
  • ora-30373 : object data types are not supported in this context
  • ora-39082 : Object type string created with compilation warnings
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-19698 : %s is from different database: id=string, db_name=string
  • ora-30966 : error detected in the XML Index layer
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-16555 : the Data Guard database is not active
  • ora-13790 : invalid value for time limit
  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-25950 : missing where clause in join index specification
  • ora-01905 : STORAGE keyword expected
  • ora-28106 : input value for argument #string is not valid
  • ora-13509 : error encountered during updates to a AWR table
  • ora-40206 : invalid setting value for setting name string
  • ora-13497 : %s
  • ora-16774 : error stopping Redo Apply
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-24422 : error occurred while trying to destroy the Session Pool
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • 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.