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 : 29-06-2017
ORA-12664

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

  • ora-01225 : thread number string is greater than MAXINSTANCES string
  • ora-25335 : AQ array operations not allowed for buffered messages
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-12353 : secondary stored object cannot reference remote object
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-16196 : database has been previously opened and closed
  • ora-32117 : Source LOB is null
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-30192 : reserved for future use
  • ora-09217 : sfsfs: failed to resize file
  • ora-07562 : sldext: extension must be 3 characters
  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-27080 : too many files open
  • ora-26734 : different datafiles_directory_object parameter must be specified
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-27544 : Failed to map memory region for export
  • ora-30462 : unsupported operator: string
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-01271 : Unable to create new file name for file string
  • ora-29267 : illegal call
  • ora-13267 : error reading data from layer table string
  • ora-19758 : failed to enable/disable block change tracking: out of SGA memory
  • ora-02045 : too many local sessions participating in global transaction
  • ora-32632 : incorrect subquery in MODEL FOR cell index
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-12166 : TNS:Client can not connect to HO agent.
  • ora-25000 : invalid use of bind variable in trigger WHEN clause
  • ora-32102 : invalid OCI handle
  • ora-37012 : (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.
  • 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.