ORA-28361: master key not yet set

Cause : The msater kye for hte insatnce wsa not est.

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

Execuet the LATER SSYTEM STE KEY ocmmandt o seta mastre key ofr thed atabaes instnace.

update : 24-05-2017

ORA-28361 - master key not yet set
ORA-28361 - master key not yet set

  • ora-19587 : error occurred reading string bytes at block number string
  • ora-14061 : data type or length of an index partitioning column may not be changed
  • ora-27544 : Failed to map memory region for export
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-00336 : log file size string blocks is less than minimum string blocks
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-23361 : materialized view "string" does not exist at master site
  • ora-25152 : TEMPFILE cannot be dropped at this time
  • ora-02816 : Unable to kill a process
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-16590 : Data Guard configuration does not contain a primary database
  • ora-00299 : must use file-level media recovery on data file string
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-12438 : repeated policy option: string
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-37111 : Unable to load the OLAP API sharable library: (string)
  • ora-02086 : database (link) name is too long
  • ora-12845 : failed to receive interinstance parallel execution message
  • ora-25504 : the system is already in quiesced state
  • ora-26687 : no instantiation SCN provided for "string"."string" in source database "string"
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-16538 : no match on requested item
  • ora-06446 : ssvpstevrg: Failed with unexpected error number.
  • ora-19765 : mount id string does not match mount id string in control file
  • ora-08181 : specified number is not a valid system change number
  • 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.