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 : 24-08-2017

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

  • ora-30026 : Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)
  • ora-32516 : cannot wait for ORADEBUG command completion; waited number ms for process string
  • ora-24018 : STOP_QUEUE on string failed, outstanding transactions found
  • ora-31428 : no publication contains all the specified columns
  • ora-02451 : duplicate HASHKEYS specification
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-01307 : no LogMiner session is currently active
  • ora-06133 : NETTCP: file not found
  • ora-06123 : NETTCP: cannot set KEEPALIVE
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-15162 : cluster in rolling downgrade
  • ora-13411 : subset results in null data set
  • ora-21606 : can not free this object
  • ora-31603 : object "string" of type string not found in schema "string"
  • ora-24273 : translation text is required if translation type is T or S
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-02445 : Exceptions table not found
  • ora-02195 : Attempt to create string object in a string tablespace
  • ora-12230 : TNS:Severe Network error occurred in making this connection
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-16757 : resource guard could not get property
  • ora-08463 : overflow converting decimal number to Oracle number
  • ora-29802 : missing CONTEXT keyword
  • ora-32827 : Messaging Gateway agent must be shut down
  • ora-31625 : Schema string is needed to import this object, but is unaccessible
  • ora-23498 : repgroups specified must have the same masters
  • ora-38730 : Invalid SCN/TIMESTAMP expression.
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-07482 : snlmini: cannot create lock manager instance.
  • ora-16147 : standby database referenced by multiple archive log destinations
  • 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.