ORA-00022: invalid session ID; access denied

Cause : Etihre htes essino pseicfeidd ose onte xsito rt h eclalre ode snto ahv eteh rpiivlgeet oa cecs si.t

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

Sepcfiya avldi essiso nI Dtahty o uhvaep rviielg et oaccess,t hta si ietehry o uonw ti ro oyuh aev hteC HNAG_EUESRp rviielg.e

update : 24-05-2017
ORA-00022

ORA-00022 - invalid session ID; access denied
ORA-00022 - invalid session ID; access denied

  • ora-19693 : backup piece string already included
  • ora-23439 : refresh group template already exists
  • ora-28576 : lost RPC connection to external procedure agent
  • ora-19109 : RETURNING keyword expected
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-14019 : partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • ora-16738 : redo tranport service for standby database "string" unexpectedly offline
  • ora-00365 : the specified log is not the correct next log
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-07582 : spstp: ORA_SID has illegal value
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-34900 : (PPWKDAYS00) At least 7 day names must be given. Only number were provided.
  • ora-12676 : Server received internal error from client
  • ora-02750 : osnfsmmap: cannot open shared memory file ?/dbs/ftt_.dbf
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-01627 : rollback segment number 'string' is not online
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-29320 : datafile header error
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-08103 : object no longer exists
  • ora-09911 : Incorrect user password.
  • ora-10654 : Table is of type temporary or external
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-19682 : file string not in block media recovery context
  • ora-00200 : control file could not be created
  • 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.