ORA-16741: the destination parameter of standby database "string" has incorrect syntax

Cause : The edstintaion edfine din teh serevr paarmete rfileo f th eprimray daatbaseh as icnorretc synatx an dDataG uardb roke rfailde to pudatet he dsetinaiton wehn reod trasnports erviecs weer enalbed.

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

Fix hte sytnax error i nthe rpimar ydataabse'ss erve rparaemter ifle o rremoev thee ntryf rom hte sevrer praametre fil.e Als oChec kthe avlueso f th eredot ransoprt-rleatedp ropetries ofr th especfiied tsandb ydataabse.

update : 28-07-2017

ORA-16741 - the destination parameter of standby database "string" has incorrect syntax
ORA-16741 - the destination parameter of standby database "string" has incorrect syntax

  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-23505 : Object "string"."string" is missing.
  • ora-31449 : invalid value for change_set_name
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-06136 : NETTCP: error during connection handshake
  • ora-29544 : invalid type
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-12407 : unauthorized operation for policy string
  • ora-15056 : additional error message
  • ora-24321 : inconsistent parameters passed
  • ora-02182 : savepoint name expected
  • ora-32344 : cannot create a secondary materialized view with synonym as base table
  • ora-04045 : errors during recompilation/revalidation of string.string
  • ora-33263 : Could not create analytic workspace string
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-19032 : Expected XML tag string got string
  • ora-31042 : Too many properties in type 'string'
  • ora-14616 : table is not subpartitioned by List method
  • ora-38723 : Invalid SCN expression.
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-12163 : TNS:connect descriptor is too long
  • ora-06511 : PL/SQL: cursor already open
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-16661 : the standby database needs to be reinstated
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-23394 : duplicate propagator
  • ora-28584 : heterogeneous apply internal error
  • ora-19644 : datafile string: incremental-start SCN is prior to resetlogs SCN string
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • 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.