ORA-12664: Services required by server not available on the client

Cause : Service(s) that was (were) required by the server process were not available on the client process.

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

Configure the client with the services required by the server (best solution) or delete the requirement from the configuration file of the server (least secure).

update : 30-04-2017

ORA-12664 - Services required by server not available on the client
ORA-12664 - Services required by server not available on the client

  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-01491 : CASCADE option not valid
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-30942 : XML Schema Evolution error for schema 'string' table string column 'string'
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-15035 : no disks belong to diskgroup "string"
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-25401 : can not continue fetches
  • ora-02270 : no matching unique or primary key for this column-list
  • ora-07627 : smsfre: $CRETVA failure
  • ora-28508 : invalid value string for Heterogeneous Services initialization parameter string
  • ora-06523 : Maximum number of arguments exceeded
  • ora-19653 : cannot switch to older file incarnation
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-25300 : Cannot drop buffer for queue with buffered subscribers
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-38029 : object statistics are locked
  • ora-24336 : invalid result set descriptor
  • ora-19233 : XQ0013 - invalid pragma
  • ora-16100 : not a valid Logical Standby database
  • ora-22313 : cannot use two versions of the same type "string"
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-27373 : unknown or illegal event source queue
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-03218 : invalid option for CREATE/ALTER TABLESPACE
  • ora-07622 : smscre: $CREATE failure
  • ora-28521 : no heterogeneous capability information available
  • ora-12683 : encryption/crypto-checksumming: no Diffie-Hellman seed
  • 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.