ORA-23537: function or procedure string is not allowed to be invoked from this site.

Cause : This function or procedure is restricted to the backend or middle tier site

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

Connect to the proper site before calling this function or procedure.

update : 27-06-2017

ORA-23537 - function or procedure string is not allowed to be invoked from this site.
ORA-23537 - function or procedure string is not allowed to be invoked from this site.

  • ora-02332 : cannot create index on attributes of this column
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-29837 : insufficient privileges to execute implementation type
  • ora-27014 : skgfqpini: translation error while expanding SS_UDMPDIR
  • ora-30728 : maximum number of columns exceeded
  • ora-14267 : cannot specify PARALLEL clause when adding a (Composite) Range partition
  • ora-15130 : diskgroup "string" is being dismounted
  • ora-31205 : DBMS_LDAP: PL/SQL - Invalid LDAP Auth method.
  • ora-31071 : Invalid database username or GUID string
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-31652 : command response message was invalid type - detaching job
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-36684 : (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-36924 : (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
  • ora-16641 : failure to acquire broker configuration metadata lock
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-12204 : TNS:received data refused from an application
  • ora-00444 : background process "string" failed while starting
  • ora-06440 : ssaio: the asynchronous read returned incorrect number of bytes
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-07444 : function address string is not readable
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-24141 : rule set string.string does not exist
  • ora-27476 : "string.string" does not exist
  • ora-24100 : error in ktz testing layer
  • ora-17620 : failed to register the network adapter with Oracle Disk Manager library: string
  • ora-12062 : transaction string received out of sequence from site 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.