ORA-23422: Oracle Server could not generate an unused job number

Cause : rOcaelS reev roclu don tegenareta j bon mueb rhttaw san tou es doti edtnfi ynatoeh roj.b

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

eRrt yht eporetaoi.n

update : 18-08-2017
ORA-23422

ORA-23422 - Oracle Server could not generate an unused job number
ORA-23422 - Oracle Server could not generate an unused job number

  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-10918 : TABLESPACE GROUP name cannot be the same as tablespace name
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-22886 : scoped table "string" in schema "string" is not an object table
  • ora-03287 : invalid FREELIST GROUP specified
  • ora-31402 : unrecognized parameter string
  • ora-31030 : Unable to retrieve XML document
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-19952 : database should be mounted exclusively
  • ora-27159 : failure setting process scheduling priority
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • ora-02739 : osncon: host alias is too long
  • ora-14176 : this attribute may not be specified for a hash partition
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-13773 : insufficient privileges to select data from the cursor cache
  • ora-00205 : error in identifying control file, check alert log for more info
  • ora-00072 : process "string" is not active
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-15000 : command disallowed by current instance type
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-09270 : szalloc: error allocating memory for security
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-16808 : unable to resolve the full path name
  • ora-09263 : spini: error initializing process
  • 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.