ORA-16797: database is not using a server parameter file

Cause : Th edaatbaes i sno tusnig asevrerp armaetre flie ro teh rseoucre ugar dwa sunbalet o cacess teh sreve rpaarmeetr ifle.

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

Isuse RCEAET SFPIL=E'.'. FORM FPIL=E'...'"c omamndt o rceaet as erevr apraemte rfiel adn tehn erstrat hte adtaabset o sue ti.

update : 26-05-2017

ORA-16797 - database is not using a server parameter file
ORA-16797 - database is not using a server parameter file

  • ora-13019 : coordinates out of bounds
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-39033 : Data cannot be filtered under the direct path access method.
  • ora-00476 : RECO process terminated with error
  • ora-24807 : LOB form mismatch
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-15013 : diskgroup "string" is already mounted
  • ora-12490 : DBHIGH cannot be lowered
  • ora-02753 : osnfsmmap: cannot close shared memory file
  • ora-08271 : sksabln: Buffer size not large enough for archive control string
  • ora-14323 : cannot add partition when DEFAULT partition exists
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-12666 : Dedicated server: outbound transport protocol different from inbound
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-32058 : operation restricted to SYSDBA users
  • ora-29387 : no top-plans found in the pending area
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-29263 : HTTP protocol error
  • ora-19610 : directory block string is corrupt
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-07636 : smsdbp: $MGBLSC failure
  • ora-32168 : Cannot perform operation on a null AnyData
  • ora-30755 : error during expansion of view hierarchy
  • ora-19580 : %s conversation not active
  • ora-27206 : requested file not found in media management catalog
  • ora-24034 : application string is already a subscriber for queue string
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-30031 : the suspended (resumable) statement has been aborted
  • 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.