ORA-27128: unable to determine pagesize

Cause : sysconf() call failed

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

contact Oracle support

update : 30-04-2017
ORA-27128

ORA-27128 - unable to determine pagesize
ORA-27128 - unable to determine pagesize

  • ora-32584 : missing LOG keyword
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-12703 : this character set conversion is not supported
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-33332 : (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
  • ora-24172 : rule set string.string has errors
  • ora-28007 : the password cannot be reused
  • ora-06303 : IPA: Message send error
  • ora-00081 : address range [string, string) is not readable
  • ora-24167 : incompatible rule engine objects, cannot downgrade
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-28238 : no seed provided
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-08308 : sllfop: Cannot open file
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-30731 : scope constraint not allowed on nested table column when the nested table is being created
  • ora-28164 : REVOKE already specified
  • ora-12342 : open mounts exceeds limit set on the OPEN_MOUNTS parameter
  • ora-28006 : conflicting values for parameters string and string
  • ora-16551 : short string copied
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-10373 : parallel query server kill event
  • ora-09957 : Unable to send termination request to IMON
  • ora-31021 : Element definition not found
  • ora-01487 : packed decimal number too large for supplied buffer
  • 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.