ORA-24902: invalid subscription name or name-length in subscription handle

Cause : The subscription handle passed into the OCI call does not have a proper name or name-length attribute.

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

Please set the name and name-length attributes using the OCIAttrSet() call.

update : 26-04-2017

ORA-24902 - invalid subscription name or name-length in subscription handle
ORA-24902 - invalid subscription name or name-length in subscription handle

  • ora-21779 : duration not active
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-39600 : Queue keys needs to be a suffix of cluster key.
  • ora-24778 : cannot open connections
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-02778 : Name given for the log directory is invalid
  • ora-39175 : Encryption password is not needed.
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-39702 : database not open for UPGRADE or DOWNGRADE
  • ora-29911 : null scan context returned by ODCIIndexStart() routine
  • ora-30558 : internal error [string] in function based index
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-00910 : specified length too long for its datatype
  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-16537 : child count exceeded
  • ora-29291 : file remove operation failed
  • ora-22278 : must update the LOB only through the LOB buffers
  • ora-16076 : unknown standby database destination
  • ora-00256 : cannot translate archive destination string string
  • ora-12736 : Instant Client Light: unsupported server national character set string
  • ora-16767 : SQL Apply unexpectedly online
  • ora-03119 : two-task detected inconsistent datatype specification
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-12835 : No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
  • ora-17620 : failed to register the network adapter with Oracle Disk Manager library: string
  • ora-12462 : undefined compartment string for policy string
  • ora-24323 : value not allowed
  • 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.