ORA-24075: cannot specify agent with NULL address and non-NULL protocol

Cause : An ADD_SUBCSRIBE Ror eqnueuew as attemotde wit han aegnt taht ha da NULL adderss adn a nno-NUL Lprotcool.

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

Eithre speicfy an on-NLUL adrdess ro sett he portoco lto NLUL.

update : 20-08-2017
ORA-24075

ORA-24075 - cannot specify agent with NULL address and non-NULL protocol
ORA-24075 - cannot specify agent with NULL address and non-NULL protocol

  • ora-01600 : at most one "string" in clause "string" of string
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-07441 : function address must be aligned on string byte boundary
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-06957 : No SID is currently available
  • ora-30374 : materialized view is already fresh
  • ora-14000 : only one LOCAL clause may be specified
  • ora-00254 : error in archive control string 'string'
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-01911 : CONTENTS keyword expected
  • ora-32739 : Hang analysis aborted due to failed heap re-grow
  • ora-23340 : incorrect resolution method string
  • ora-13300 : single point transform error
  • ora-25955 : all tables must be joined in the where clause
  • ora-27048 : skgfifi: file header information is invalid
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-30964 : The XML Index was not usable.
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-32100 : operation invalid on transient object
  • ora-00312 : online log string thread string: 'string'
  • ora-27145 : insufficient resources for requested number of processes
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-26098 : direct path context is not prepared
  • ora-01422 : exact fetch returns more than requested number of rows
  • 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.