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 : 28-06-2017

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

  • ora-09702 : sem_acquire: cannot acquire latch semaphore
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-30446 : valid workload queries not found
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-28345 : cannot downgrade because there exists encrypted column
  • ora-09757 : osnipn: port allocation failure.
  • ora-23305 : internal deferred RPC error: string
  • ora-27061 : waiting for async I/Os failed
  • ora-19246 : XQ0026 - validation failed - element string not found in in-scope element declarations
  • ora-04081 : trigger 'string' already exists
  • ora-24181 : The type string does not exist
  • ora-28333 : column is not encrypted
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-16509 : the request timed out
  • ora-24010 : QUEUE string does not exist
  • ora-03240 : User's temporary tablespace same as tablespace being migrated
  • ora-01120 : cannot remove online database file string
  • ora-06122 : NETTCP: setup failure
  • ora-06531 : Reference to uninitialized collection
  • ora-16407 : Standby database is in the future of the archive log
  • ora-30072 : invalid time zone value
  • ora-02725 : osnpbr: cannot send break signal
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-29813 : non-supported object type with associate statement
  • ora-30342 : referenced level is not defined in this dimension
  • ora-13282 : failure on initialization of coordinate transformation
  • ora-06592 : CASE not found while executing CASE statement
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-16781 : the status of redo transport service for a database is unknown
  • 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.