ORA-07267: spwat: invalid process number.

Cause : Fnucito nwsa apsesda ni navldi roalcep rcoess di.

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

Itnenra lerro.r dAdtiinoa lifnomraito nidniactse htei navldi rpoecs si.d

update : 25-05-2017
ORA-07267

ORA-07267 - spwat: invalid process number.
ORA-07267 - spwat: invalid process number.

  • ora-15177 : cannot operate on system aliases
  • ora-28150 : proxy not authorized to connect as client
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-24389 : Invalid scrollable fetch parameters
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-26030 : index string.string had string partitions made unusable due to:
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-16002 : database already open for read-write access by another instance
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-13758 : "SQL Tuning Set" "string" owned by user "string" is in use.
  • ora-12334 : database (link name string) is still open
  • ora-25208 : RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
  • ora-27144 : attempt to kill process failed
  • ora-39127 : unexpected error from call to string string
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-24056 : internal inconsistency for QUEUE string and destination string
  • ora-16772 : error switching over between primary and standby databases
  • ora-13352 : the coordinates do not describe a circle
  • ora-00451 : foreground process died unexpectedly
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-06267 : NETNTT: bad state
  • ora-06114 : NETTCP: SID lookup failure
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-06521 : PL/SQL: Error mapping function
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • 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.