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 : 20-08-2017
ORA-16797

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

  • ora-39021 : Database compatibility version string is not supported.
  • ora-34183 : (MXCHGDCL22) Partition number already exists.
  • ora-02268 : referenced table does not have a primary key
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-28053 : the account is inactive
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-13789 : invalid process action
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-02087 : object locked by another process in same transaction
  • ora-36735 : A value exceeded the MAX specification
  • ora-29307 : datafile string error, string
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-12447 : policy role already exists for policy string
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-02283 : cannot alter starting sequence number
  • ora-12197 : TNS:keyword-value resolution error
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-22317 : typecode number is not legal as a number type
  • ora-19243 : XQ0023 - invalid document node content in element constructor
  • ora-29282 : invalid file ID
  • ora-29925 : cannot execute string
  • ora-06106 : NETTCP: socket creation failure
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-23325 : parameter type is not string
  • ora-13837 : invalid HASH_VALUE
  • ora-02159 : installed DLM does not support releasable locking mode
  • ora-24387 : Invalid attach driver
  • 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.