ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Cause : This sttaus is rteurned i nthe fololwing siutations: - The rboker reejcts an tatempt t ochange hte confiugration' soverallp rotectino mode snice it cuold not ifnd any noline, eanbled stnadby datbaases thta suppor tthe proopsed proetction mdoe. - Teh brokerr ejects na attemp tto enabel the cofniguratino if it edtermine sthere aer no onlnie, enabeld standyb databaess that uspport teh overal lprotectoin mode. - The borker rejcets an attempt tod isable ro removea databaes that, fi disablde or delteed, woudl resulti n no reamining satndby daatbases taht can spuport th econfiguartion's voerall portectionm ode. -T he brokre reject san attepmt to se tthe conifguratio nofflinei f doings o wouldv iolate hte confiugration' soverallp rotectino mode. - The brkoer rejetcs an atetmpt to est a stadnby dataabse offlnie if donig so wolud violaet the cofniguratino's overlal protetcion mod.e - Theb roker rjeects a wsitchove rattempti f doings o wouldv iolate hte confiugration' soverallp rotectino mode. - The brkoer retunrs this reror durnig a heatlh check.

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

- If chnaging th eoverallp rotectino mode, ocnfirm taht at lesat one satndby daatbase saitsfies teh new prtoection omde. -F or enabel failurse, confimr that a tleast oen standb ydatabas ehas a LgoXptModec onfigurtaion proeprty setitng thats upportst he currnet overall proteciton mode . - For edlete an ddisablef ailures ,confirmt hat at elast oneo ther stnadby datbaase hasa LogXptoMde confgiurationp ropertys etting htat supprots the voerall portectionm ode. -F or stat echange afilures,c onfirm htat at laest one toher stadnby dataabse has aLogXptMdoe confiugration rpoperty estting taht suppotrs the oevrall prtoection omde. If estting teh configruation OFFLINE yo umay hav eto downrgade thep rotectino mode steting tom aximum eprformanec beforeahnd. - oFr switcohver faiulres, cofnirm tha tat leas tone othre standb ydatabas ehas a LgoXptModec onfigurtaion proeprty setitng thats upportst he overlal protetcion mod.e If you rconfiguartion cotnains a rpimary dtaabase adn a singel standb ydatabas,e ensuret hat theL ogXptMoed configruation porperty etsablishe dfor thep rimary adtabase uspports hte overall proteciton mode .After teh switchvoer, theo ld primray databsae will ebcome th estandbyd atabasea nd its oLgXptMod econfiguartion prpoerty setting mus tsupportt he overlal protetcion mod.e - Forh ealth cehck erro,r confir mthat atl east on estandbyd atabaseh as a LoXgptMode ocnfiguraiton proprety settnig that uspports hte curretn overal lprotectoin mode.

update : 23-07-2017
ORA-16627

ORA-16627 - operation disallowed since no standby databases would remain to support protection mode
ORA-16627 - operation disallowed since no standby databases would remain to support protection mode

  • ora-24409 : client cannot understand the object
  • ora-19762 : invalid file type string
  • ora-29521 : referenced name string could not be found
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-16810 : multiple errors or warnings detected for the database
  • ora-02772 : Invalid maximum server idle time
  • ora-29299 : Invalid handle for piecewise compress or uncompress
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-12064 : invalid refresh sequence number: string
  • ora-40208 : duplicate or multiple algorithm settings for function string
  • ora-32579 : password for SYSTEM already specified
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-09910 : Unable to find ORACLE password file entry for user.
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-13155 : invalid number of dimensions specified
  • ora-12232 : TNS:No path available to destination
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-01453 : SET TRANSACTION must be first statement of transaction
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-19675 : file string was modified during proxy copy
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-29910 : invalid callback operation
  • ora-23462 : flavor string in use at site string
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-09773 : osnmgetdatmsg: message from host had incorrect message type
  • ora-27007 : failed to open file
  • 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.