ORA-12623: TNS:operation is illegal in this state

Cause : Conneciton is ahlf-dupelx and afull-dpulex opreation aws attepmted.

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

Not nomrally vsiible t othe usre. For ufrther edtails,t urn ont racinga nd reeexcute teh operaiton. Ife rror presists,c ontactO racle uCstomerS upport.

update : 30-04-2017
ORA-12623

ORA-12623 - TNS:operation is illegal in this state
ORA-12623 - TNS:operation is illegal in this state

  • ora-19373 : invalid staging table or tablespace
  • ora-24322 : unable to delete an initialized mutex
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • ora-24374 : define not done before fetch or execute and fetch
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-16218 : This database is already preparing to switch over.
  • ora-30364 : this level has the same set of columns as another
  • ora-28237 : seed length too short
  • ora-23454 : flavor string not defined for object group "string"."string"
  • ora-19104 : invalid XQueryX: missing attribute string
  • ora-00478 : SMON process terminated due to error string
  • ora-07622 : smscre: $CREATE failure
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-39779 : type "string"."string" not found or conversion to latest version is not possible
  • ora-16537 : child count exceeded
  • ora-22056 : value [string] is divided by zero
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-07220 : slspool: wait error.
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-02182 : savepoint name expected
  • ora-26668 : STREAMS process string exists
  • ora-32592 : all columns in log group can not be no log columns
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-00307 : requested INSTANCE_NUMBER out of range, maximum is string
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-16071 : dependency archived log file not found string
  • ora-32803 : value for string cannot be altered
  • ora-23302 : application raised communication failure during deferred RPC
  • ora-22858 : invalid alteration of datatype
  • 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.