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 : 26-09-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-19558 : error de-allocating device
  • ora-28113 : policy predicate has error
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • ora-16126 : loading table or sequence string
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-29803 : missing ANCILLARY keyword
  • ora-31001 : Invalid resource handle or path name "string"
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-30066 : test support - drop rollback segment wait
  • ora-07584 : spdcr: invalid value for ORA_sid_(proc_)PQL$_item
  • ora-02170 : FREELIST GROUPS storage option not allowed
  • ora-16134 : invalid MANAGED recovery FINISH option
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-12490 : DBHIGH cannot be lowered
  • ora-12659 : Error received from other process
  • ora-12002 : there is no materialized view log on table "string"."string"
  • ora-01283 : Options specified is invalid
  • ora-30051 : VERSIONS clause not allowed here
  • ora-12993 : tablespace 'string' is offline, cannot drop column
  • ora-39220 : file name is too long
  • ora-33050 : (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
  • ora-12991 : column is referenced in a multi-column constraint
  • ora-02843 : Invalid value for kernel flag
  • ora-06020 : NETASY: initialisation failure
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-36977 : (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
  • ora-27507 : IPC error disconnecting from a port
  • ora-36720 : (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
  • 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.