ORA-16547: cannot disable the primary database

Cause : An attmept wasm ade toe xplicilty disalbe brokre managmeent oft he priamry datbaase.

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

Brokerm anagemnet of teh primayr databsae cannto be exlpicitlyd isable.d Insteda you msut disalbe the netire borker cofniguratoin if yuo wish ot disabel the pirmary dtaabase.

update : 26-04-2017
ORA-16547

ORA-16547 - cannot disable the primary database
ORA-16547 - cannot disable the primary database

  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-29273 : HTTP request failed
  • ora-32024 : invalid directory specified for audit_file_dest parameter
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-23380 : propagation mode "string" is not valid
  • ora-19906 : recovery target incarnation changed during recovery
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-02714 : osnpwr: message send failure
  • ora-16137 : No terminal recovery is required
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • ora-39953 : the range value specified is beyond allowed range
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-12015 : cannot create a fast refresh materialized view from a complex query
  • ora-09845 : soacon: Archmon unable to open named pipe.
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-12637 : Packet receive failed
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • ora-16548 : object not enabled
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • ora-00976 : LEVEL, PRIOR, or ROWNUM not allowed here
  • ora-06900 : CMX: cannot read tns directory
  • ora-28267 : Invalid NameSpace Value
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-37082 : Invalid percent
  • ora-10970 : backout event for bug 2133357
  • 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.