ORA-16523: operation requires the client to connect to instance "string"

Cause : Th eswtichvoero r afilvoero peartino rqeuiers hte lcietn t oconnec ttot hea ppyl isntacne fo teh trage tdaatbaes.

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

Connec ttot hei ndciatde isntacne nad erisuse hte wsithcovre o rfaliovre cmomadn.

update : 22-07-2017

ORA-16523 - operation requires the client to connect to instance "string"
ORA-16523 - operation requires the client to connect to instance "string"

  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-27072 : File I/O error
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-25111 : creation of BITMAP cluster indices is not supported
  • ora-30398 : illegal JOIN KEY clause
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • ora-39148 : unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
  • ora-03241 : Invalid unit size
  • ora-29830 : operator does not exist
  • ora-19203 : Error occurred in DBMS_XMLGEN processingstring
  • ora-08261 : ora_addr: cannot find name in nameserver
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • ora-26675 : cannot create Streams capture process string
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-01148 : cannot refresh file size for datafile string
  • ora-27019 : tape filename length exceeds limit (SBTOPMXF)
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-22617 : error while accessing the image handle collection
  • ora-07613 : $GETJPIW failed in retrieving the user's process label
  • ora-01682 : read-only DB cannot allocate temporary space in tablespace string
  • ora-30130 : invalid parameter key type received
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-37105 : (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
  • ora-00450 : background process 'string' did not start
  • ora-01951 : ROLE 'string' not granted to 'string'
  • 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.