ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

Cause : There are not any available and appropriate database instances registered with the listener, that are part of the service identified by SERVICE_NAME given in the connect descriptor and that have the specified INSTANCE_ROLE (and INSTANCE_NAME, if specified).

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

Check to make sure that the INSTANCE_ROLE specified is correct. Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that they are ready to accept connections.

update : 23-04-2017
ORA-12522

ORA-12522 - TNS:listener could not find available instance with given INSTANCE_ROLE
ORA-12522 - TNS:listener could not find available instance with given INSTANCE_ROLE

  • ora-32156 : Cannot perform operation on stream
  • ora-07843 : sllfcl: LIB$FREE_VM failure
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-27074 : unable to determine limit for open files
  • ora-31090 : invalid database schema name "string"
  • ora-12731 : invalid collation class in regular expression
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-31415 : change set string does not exist
  • ora-12418 : user string not found
  • ora-19599 : block number string is corrupt in string string
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-08312 : sllfop: unrecognized processing option
  • ora-01757 : Must specify an object number
  • ora-37020 : (XSMULTI01) Analytic workspace string is not in MULTI mode.
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-02422 : missing or invalid schema element
  • ora-38505 : invalid default value for the attribute
  • ora-16119 : building transaction at SCN string
  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-27057 : cannot perform async I/O to file
  • ora-31520 : CDC subscription string already subscribes to publication ID string
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-02171 : invalid value for MAXLOGHISTORY
  • ora-06560 : pos, string, is negative or larger than the buffer size, string
  • ora-39030 : invalid file type string
  • ora-14007 : missing LESS keyword
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-07279 : spcre: semget error, unable to get first semaphore set.
  • ora-13024 : polygon has less than three segments
  • 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.